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

Closed
marks88 Posts 2 Registration date Friday November 18, 2016 Status Member Last seen November 21, 2016 - Nov 18, 2016 at 07:54 AM
marks88 Posts 2 Registration date Friday November 18, 2016 Status Member Last seen November 21, 2016 - Nov 21, 2016 at 01:04 AM
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
Related:

1 response

yg_be Posts 22726 Registration date Sunday June 8, 2008 Status Contributor Last seen April 26, 2024 5
Nov 18, 2016 at 08:11 AM
0
marks88 Posts 2 Registration date Friday November 18, 2016 Status Member Last seen November 21, 2016
Nov 21, 2016 at 01:04 AM
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
0