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

Posts
17188
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 27, 2021
5
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