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
15614
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
May 15, 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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!