Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!