Compile list of same cell from multiple worksheets

[Guest]

I need to extract data from (for example) C2 in numerous worksheets in the
same workbook and list them in a summary worksheet in Column A. Is this
possible?

 

[Ron de Bruin]

Hi

see
http://www.rondebruin.nl/summary.htm

 

[Guest]

Thank you, I have no knowledge of VB I have saved your links and was
wondering if you have any other links/sites that would be helpful for
learning VB.

PCakes

 

[Ron de Bruin]

Hi

Start here
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Download my Google Search add-in
There is also a list with favorite websites in the add-in
http://www.rondebruin.nl/Google.htm

 

[Guest]

Ron,

Is this possible to do from several workbooks in a folder to a summary
workbook?

Interesting problems I have....

Pcakes

 

[Ron de Bruin]

Hi PCakes

See
http://www.rondebruin.nl/summary2.htm

 

[Guest]

Ron,

Thanks for the direction, this works great, however I need to do this but
have several rows copies and placed by row in my summary. E.g. data from
A31-M36
Is that possible to do with this macro?

You have been so helpul!

PCakes

 

[Ron de Bruin]

Hi PCakes

See
http://www.rondebruin.nl/copy3.htm