0

  1. I have a .xlsx file that contains 4 sheets filled with data and formulas etc.

  2. I need to duplicate that .xlsx file 1000 times and save each file with a different name.

  3. I have another .xlsx file containing the list of 1000 names that I would like these duplicates to be named when saved.

  4. Is it possible for me to do this without manually copying the file 1000 times and renaming every one?

  5. I am using excel on a Mac, not sure if this limits my options....

Siddharth Rout
  • 147,039
  • 17
  • 206
  • 250
Cole
  • 1
  • 3
  • yes, you can easily do something from the "Terminal" command prompt to do this. – Marc B Aug 11 '14 at 18:54
  • Are you open to a VBA solution? – Siddharth Rout Aug 11 '14 at 21:39
  • I am open to any solution! I spent a few hours searching around and trying to do it through the terminal but failed miserably with the looping and renaming part of the duplication. Any tips would be appreciated. – Cole Aug 12 '14 at 19:35

0 Answers0