politicalangel
New Member
Hi,
I have over 200 workbooks / similar templates that I need data from to populate into a summary sheet.
So I need Cell C6 From referenced worksheets to populate. Does ayone have a macro to do so?
All the workbooks are labeled e.g
1-Jan/Store 1
1-Jan/Store 3
2- Feb/Store 10
2- Feb/Store 2
3-March/Store 200
an so on...
I need the data from this workbooks/worksheets that are in cell C6 to popluate across my rows on my summary sheet if the store is referenced
So in short a marco that will open the file, read the cell, and hardcode the amount into the summary sheet OR
an easy way to create a link for all the different workbooks that gives me the amount on tha cell
Please see attched for example...
Thank you in advance
I have over 200 workbooks / similar templates that I need data from to populate into a summary sheet.
So I need Cell C6 From referenced worksheets to populate. Does ayone have a macro to do so?
All the workbooks are labeled e.g
1-Jan/Store 1
1-Jan/Store 3
2- Feb/Store 10
2- Feb/Store 2
3-March/Store 200
an so on...
I need the data from this workbooks/worksheets that are in cell C6 to popluate across my rows on my summary sheet if the store is referenced
So in short a marco that will open the file, read the cell, and hardcode the amount into the summary sheet OR
an easy way to create a link for all the different workbooks that gives me the amount on tha cell
Please see attched for example...
Thank you in advance