sweeneytime
Board Regular
- Joined
- Aug 23, 2010
- Messages
- 183
Hi Guys,
I want to know is the following possible please?
I have say 50 cost centre: 10,20,30,40,50,60……. One per worksheet
Then a worksheet of what mangers gets what: each cost centre in a different cell
Paul: 10,40,50
Jim: 20,30,40
Mary: 40,60
Based on those cells I want to group the worksheets and put in them in a new workbook. The new workbook part is grand, it is just grouping them.
1) How would select a sheet based on a cell value?
2) Do I need to define variables to hold the values as it loops through each list of cost centres? Then group the variables so it creates the new workbook before moving to the next name?
I have thought about this for a while, but each light bulb moment gets smashed by the reality of noobi-ness!
Cheers,
Alan
I want to know is the following possible please?
I have say 50 cost centre: 10,20,30,40,50,60……. One per worksheet
Then a worksheet of what mangers gets what: each cost centre in a different cell
Paul: 10,40,50
Jim: 20,30,40
Mary: 40,60
Based on those cells I want to group the worksheets and put in them in a new workbook. The new workbook part is grand, it is just grouping them.
1) How would select a sheet based on a cell value?
2) Do I need to define variables to hold the values as it loops through each list of cost centres? Then group the variables so it creates the new workbook before moving to the next name?
I have thought about this for a while, but each light bulb moment gets smashed by the reality of noobi-ness!
Cheers,
Alan