Pandab2002
IS-IT--Management
Hi. I have an excel spreadsheet the has 132 rows of information. I am trying to come up with a way to use the data in column "I" as "save as" file names for another spreadsheet that is open. In other words, I want to select the contents of "I2", do a CTRL-C (to copy), the select the other workbook, do a ALT-F-A (to save as), do a CTRL-V (to paste the new save name). And finally, send a "S" to save. Then I want to repeat the whole process 131 more times, stepping down to "I3" then "I4" and so on. Any suggestions?
Thank you
Paul...
Thank you
Paul...