Is there an excel formula to automate copying name by n amount of times. Can this be done by copying macro from one name to another?
This is very easy to do it manually. I have lots of names to do it. Please see the attached spreadsheet.
So, first row is list of names; and second rows is number of times to being copies. Last row is just excel formula to count names to avoid careless errors