Hi Everyone,
I get a data pull weekly that has multiple tabs across multiple workbooks, and within each tab there are summaries of different company data.
So a tab might look like this:
COMPANY Name
data 1
data 2
data 3
data 3
display sum
COMPANY Name #2
data 1
data 2
display sum
There is an existing spreadsheet which links to these files and automatically pulls the data, but I have to go into each sheet and tab and manually append the company name after "display sum". So in the end it will end up being "display sum COMPANY Name"
Couple of important points:
-The number of companies in each tab can change week to week
-the number of data points can change week to week
-The "display sum" will ALWAYS be the last row of the data
-The company name and "display sum" will always be in the same column (A)
Is there something I can write that will cycle through the sheets and append the company name to the end of "display sum"?
Any suggestions welcome!
Bookmarks