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

Question

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

Report

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

Copy data from one sheet to a new workbook and save loop
Transfer a row of data from one sheet to another same workbook ✓ - Forum - Excel
How to copy data from one sheet to another in excel using formula - How-To - Excel
Automatically transfer data from one sheet to another in excel - How-To - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel

1 reply

Ask a question

yg_be · Answer 1 · 2016-11-18T08:11:28-0500

Answer 1 / 1

yg_be

Posts: 13943
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 18, 2021

4
Nov 18, 2016 at 08:11 AM

Does this help?
https://ccm.net/forum/affich-939492-copy-paste-rename-based-on-cell-value#p940051

Report

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

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

1 reply

Your reply

Subscribe To Our Newsletter!