I have created Test's Team (By Group) with Day 1 through Day 31 tabs on it. On each tab is a list of names with Columns B, C, D and F. I need to pull that data for each person and go into another spreadsheet Test's Team (Individual Monthly) and place Day 1 through Day 31 on each individual's name tab in columns D, G, J and N.
For example:
The macro goes to workbook Test's Team (By Group) looks on each tab Day 1 through Day 31 - finds names in range A3:A21 and then copies data in clumns B, C, D and F and then goes to the Test's (Individual Monthly) - and looks at each tab and finds that name and pastes special text data in columns D, G, J and N for each individual on each tab. Day 1 equals April 1st on the Test's (Individual Monthly) workbook and starts in C11.
If this macro isn't possible, is there another way of perhaps creating another sheet or something? I thought about setting up another sheet on the Test's Team (Individual Monthly) to pull this data - but it would be a large macro I think? Then, I would have to setup formulas to pull on the other tabs. And, I am trying to avoid formulas as much as possible because of possible constant name changes. Any help would be appreciated.
Thanks a bunch.
For example:
The macro goes to workbook Test's Team (By Group) looks on each tab Day 1 through Day 31 - finds names in range A3:A21 and then copies data in clumns B, C, D and F and then goes to the Test's (Individual Monthly) - and looks at each tab and finds that name and pastes special text data in columns D, G, J and N for each individual on each tab. Day 1 equals April 1st on the Test's (Individual Monthly) workbook and starts in C11.
If this macro isn't possible, is there another way of perhaps creating another sheet or something? I thought about setting up another sheet on the Test's Team (Individual Monthly) to pull this data - but it would be a large macro I think? Then, I would have to setup formulas to pull on the other tabs. And, I am trying to avoid formulas as much as possible because of possible constant name changes. Any help would be appreciated.
Thanks a bunch.
