sweeneytime
Board Regular
- Joined
- Aug 23, 2010
- Messages
- 183
Hi Guys,
Can you create a dynamic array from cell values please?
Below is an example of my cost centers per manager, stored on the first tab (about 50 managers) so I would like to loop through and create an array to group the sheets, each cost center is in a separate cell. Then create a new wb for each manager (that part is grand)
John: 10,20,30
Mary: 40,50,60
Jim: 20,50,70
I've been searching for a while and my skills just aint cutting it. All suggestions welcome!
Cheers,
Alan
Can you create a dynamic array from cell values please?
Below is an example of my cost centers per manager, stored on the first tab (about 50 managers) so I would like to loop through and create an array to group the sheets, each cost center is in a separate cell. Then create a new wb for each manager (that part is grand)
John: 10,20,30
Mary: 40,50,60
Jim: 20,50,70
I've been searching for a while and my skills just aint cutting it. All suggestions welcome!
Cheers,
Alan
