Previous Topic Next Topic

Copy data from one sheet to a new workbook and save loop

[Closed]
Report
Posts
2
Registration date
Friday November 18, 2016
Status
Member
Last seen
November 21, 2016
 -
Posts
2
Registration date
Friday November 18, 2016
Status
Member
Last seen
November 21, 2016
 -
Hello,

I have a sheet with multiple values which I want to copy into a new workbook, in a certain format, save as a certain name and then repeat for all rows of data. See below.



and put it into a format like the below and save as Cell A1 + A2:



Any Ideas?

Thanks

1 reply

Answer 1 / 1
Posts
17188
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 27, 2021
 5
Does this help?
https://ccm.net/forum/affich-939492-copy-paste-rename-based-on-cell-value#p940051
Report
Posts
2
Registration date
Friday November 18, 2016
Status
Member
Last seen
November 21, 2016
Hi Thanks, I am trying to apply it to my spreadsheet with difficulty... Not sure if its possible to do what I want, format etc... Can you assist further?

Thanks
Ask a question