Forum

Notifications
Clear all

Copy data from multiple worksheets with same cell reference

2 Posts
2 Users
0 Reactions
65 Views
(@shireofgingin)
Posts: 4
Active Member
Topic starter
 

I am trying to find a way to copy the result from cell C7 from 136 different worksheets into one worksheet on separate lines alongside the sheet name.  I have found a macro to list the sheet names but have not been able to find a solution to extract the value at C7.  Would you be able to offer any suggestions on how to achieve this?

 
Posted : 20/06/2017 8:01 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Please refer my answer to your previous post :

how to copy data from same cell from multiple worksheets within same workbook to separate cells with worksheet name

 
Posted : 20/06/2017 8:46 pm
Share: