- Messages
- 1,448
- Name
- Chris
- Edit My Images
- Yes
Morning all,
I'm hoping there is a VBA wizz out there who can help me out, before I go insane.
Basically I have about 200 single paged workbooks with a single persons data for the previous day on it (50 rows maximum).
What the people in charge want is these 200 sheets putting onto a single page of a different workbook, and then to be able to click on a persons name if it appears elsewhere in the book and be taken to that persons bit of the huge spreadsheet.
Not being a VBA wizz myself the only solutions I have come up with are extremely labour intensive in terms of lines of code and would not be easily modifiable (i.e. basically writing individual code for each agent :bang
If anyone can help they will be rewarded with many
, a 
and some 
Cheers
Chris
I'm hoping there is a VBA wizz out there who can help me out, before I go insane.
Basically I have about 200 single paged workbooks with a single persons data for the previous day on it (50 rows maximum).
What the people in charge want is these 200 sheets putting onto a single page of a different workbook, and then to be able to click on a persons name if it appears elsewhere in the book and be taken to that persons bit of the huge spreadsheet.
Not being a VBA wizz myself the only solutions I have come up with are extremely labour intensive in terms of lines of code and would not be easily modifiable (i.e. basically writing individual code for each agent :bang
If anyone can help they will be rewarded with many
, a and some Cheers
Chris