M
Max
Looking for help with a sub to automate this process
Book is set to manual calc
I have a DV list in B3 of say, 5 items (all items are text values),
eg:
Nov06
Dec06
Jan07
Feb07
Mar07
I select the 1st item in the DV: Nov06, press F9 to recalc (this takes
around 1-2 mins). When recalc completes, I copy the entire sheet and do
paste special as values & as formats into a new sheet inserted. I then
rename the new sheet after the item selected, ie as: Nov06.
I would then repeat the process for the next DV item: Dec06,
and continue until all items in the DV list are exhausted.
The book is then saved.
Thanks for insights
Book is set to manual calc
I have a DV list in B3 of say, 5 items (all items are text values),
eg:
Nov06
Dec06
Jan07
Feb07
Mar07
I select the 1st item in the DV: Nov06, press F9 to recalc (this takes
around 1-2 mins). When recalc completes, I copy the entire sheet and do
paste special as values & as formats into a new sheet inserted. I then
rename the new sheet after the item selected, ie as: Nov06.
I would then repeat the process for the next DV item: Dec06,
and continue until all items in the DV list are exhausted.
The book is then saved.
Thanks for insights