Hi all,
Many time user, first time poster! Just cant seem to find code already made to get what I need and hope you can help...
I have a workbook (master) which I need to replicate many times in the same folder whilst modifying one cell and saving as using a list...
eg. In this file I need to change one cell (A10 in 'Summary') based on a list in excel then I need to recalculate the file, paste copy values the summary sheet and finally save as using the same list of numbers as the file name
I hope this is not a difficult challenge
Thanks in advance
Vic
Many time user, first time poster! Just cant seem to find code already made to get what I need and hope you can help...
I have a workbook (master) which I need to replicate many times in the same folder whilst modifying one cell and saving as using a list...
eg. In this file I need to change one cell (A10 in 'Summary') based on a list in excel then I need to recalculate the file, paste copy values the summary sheet and finally save as using the same list of numbers as the file name
I hope this is not a difficult challenge
Thanks in advance
Vic