Compile list of same cell from multiple worksheets

P

PCakes

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?
 
P

PCakes

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
 
P

PCakes

Ron,

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

Interesting problems I have....

Pcakes
 
P

Pcakes

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
 
Top