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

Copy the car loan worksheet to a new workbook
City car driving free download - Download - Simulation
Copy worksheet to another workbook vba - Guide
Car parking multiplayer pc - Download - Simulation
Water bottle on top of car - Home - Apps & Sites
Transfer data from one excel worksheet to another automatically - Guide

1 response

Answer 1 / 1

yg_be Posts 23437 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 5
Nov 18, 2016 at 08:11 AM

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

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

Similar discussions

Copy worksheet from one workbook to another workbook in MS Office Excel

Working with multiple worksheets in a workbook

Create Multiple Workbooks With Template At Once

Similar discussions

Subscribe To Our Newsletter!