Good morning,
Novice here, self teaching and not up on all the lingo.
I have attached a link to a file that shows what I am looking to do, however briefly...
I created a client data summary page that links data from 100 +/- client tabs.
I have a macro at the top that inserts a new summary section into the summary page, at ROW 13, and pulls in data/links from a newly created customer tab.
In order to maximize space, I condensed and merged cells. I know, I know...
The summary is 20 pages long and it needed to be printable on landscape, and I just could not put all the data end to end.
HOWEVER, the summary is fine as it is, but now I have to pull only certain cells, 10 in total, from the roughly 80, from each client summary and link to a second summary page.
I am not sure how to do this because:
Clients will come and go.
Summary sections will be added and deleted.
Client summaries and cell positions will change.
Is there any way to do this by creating a macro to search for specific cell, cell ranges, and pull it to a second summary tab, by searching within a page break preview?
https://www.dropbox.com/s/fp4kb9r3lpgbfz6/Book1.xlsx?dl=0
I appreciate the feedback.
Novice here, self teaching and not up on all the lingo.
I have attached a link to a file that shows what I am looking to do, however briefly...
I created a client data summary page that links data from 100 +/- client tabs.
I have a macro at the top that inserts a new summary section into the summary page, at ROW 13, and pulls in data/links from a newly created customer tab.
In order to maximize space, I condensed and merged cells. I know, I know...
The summary is 20 pages long and it needed to be printable on landscape, and I just could not put all the data end to end.
HOWEVER, the summary is fine as it is, but now I have to pull only certain cells, 10 in total, from the roughly 80, from each client summary and link to a second summary page.
I am not sure how to do this because:
Clients will come and go.
Summary sections will be added and deleted.
Client summaries and cell positions will change.
Is there any way to do this by creating a macro to search for specific cell, cell ranges, and pull it to a second summary tab, by searching within a page break preview?
https://www.dropbox.com/s/fp4kb9r3lpgbfz6/Book1.xlsx?dl=0
I appreciate the feedback.