I have one Master excel file (with multiple dynamic cells), I want to change one cell (B1) in this file and create multiple static iterations (around 70) of this master file.
The numerical value that goes into cell B1, is a list in another excel file (column A) - the macro would need to run through this file, I guess.
Can anyone please help? Thank you !
Explain your overall aim. What do you mean by "multiple static iterations" ... and why do you want to create them (for what purpose)?
Thank you for your time.
I have 70 companies (with different company codes). I have a list of the codes in one excel file.
Then I have the financial template (Master file). I want to enter the company code in this template and save a copy of it. As this master files has a lot of links, the copy that is saved should be only Values (static).
And 70 such copies would be made for each company.
Please let me know in case you have any other questions. Thank you.
That sounds like a VBA process ... what have you managed to write so far?