Previous Topic Next Topic

Copy data from 2 sheets in 1 workbook to new workbook

Closed
DoubleDDD Posts 2 Registration date Tuesday 5 January 2016 Status Member Last seen 6 January 2016 - 6 Jan 2016 à 10:01
DoubleDDD Posts 2 Registration date Tuesday 5 January 2016 Status Member Last seen 6 January 2016 - 6 Jan 2016 à 14:13
Hello,
I am new to macros in Excel and could use any help.

I want to copy the basic name and customer info from 1 sheet(1) and create a new workbook with that customer's name as part of the file (and copy several cells of data) and then have the new workbook have several rows of checkboxes with titles that I can have set up in the original workbook and copy from that sheet(3) as well.

First pic is of existing workbook and 2nd pic is what I want new workbook to look like
and named Bielen info.ods or Bielen info.xls

Thanks for any assistance.




Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
6 Jan 2016 à 11:20
Little confused. In you new workbook there is sheet named Bielen. However there are other sheets too (McGregor)

It looks like to me that you have a template workbook. Based on the data entry, you want to populate that template workbook and save it with a new name
DoubleDDD Posts 2 Registration date Tuesday 5 January 2016 Status Member Last seen 6 January 2016
6 Jan 2016 à 14:13
Sorry for the confusion. I created the Bielen sheet in the same workbook but really I want it to be a separate file that gets automatically generated when I pick that specific customer My reasoning was I thought I could save the checklist on a separate sheet in the original workbook to use to build the new workbook for each specific customer.

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Copy worksheet from one workbook to another workbook in MS Office Excel
SrinivasNittala -
ac3mark -

1 response