A
AmyTaylor
Hi everyone, this sort of relates to an earlier message, but I have
tried to simplfy what I am asking about (more for my benefit than
yours!)
I have a spreadsheet with a number of worksheets, eg: Name1, Name2,
Name3.
These names are held in worksheet "AllNames" between cells A1:A10
What I would like to do is loop thru the list of names in "AllNames"
A1:A10 and for each inidividual worksheet save the relevant worksheet
as a new workbook file in the same filepath but a folder called
"Names". If possible with the date it was saved hard coded in.
Is this possible??
If so, all help gratefully received
Love Amy xx
tried to simplfy what I am asking about (more for my benefit than
yours!)
I have a spreadsheet with a number of worksheets, eg: Name1, Name2,
Name3.
These names are held in worksheet "AllNames" between cells A1:A10
What I would like to do is loop thru the list of names in "AllNames"
A1:A10 and for each inidividual worksheet save the relevant worksheet
as a new workbook file in the same filepath but a folder called
"Names". If possible with the date it was saved hard coded in.
Is this possible??
If so, all help gratefully received
Love Amy xx