Hi all,
I have a code that takes all the sheets in my workbook and pastes them each into a new workbook. However, I would like each sheet to paste into Sheet1 of an already existing workbook. Is there anyway to tweak the below code to accomplish this?
Thank you all so much!
Please Login or Register to view this content.
Are you saying that your code doesn't already do that?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi, xladept,
Copy to an existing workbook and on one worksheet only? According to what I read from the code IŽd say no.Are you saying that your code doesn't already do that?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
No. it copies each sheet to a new workbook, but I need it to copy the cells in each sheet into an existing template workbook that I have created.Originally Posted by xladept
Holger,
Yes it does copy the sheets to a workbook, but I need the data in each sheet to copy into a template workbook. Not a new workbook.
Oh Duhhh! I didn't read the whole descriptionThanks for pointing that out Holger and KT I apologise
No problem at all!
Hi, KT99,
maybe have a look at WBs to 1 Sheet which might be needed to adapt to your requirement but will surely point the direction.
Ciao,
Holger
Last edited by JBeaucaire; 12-26-2019 at 04:56 PM.
I'll give it a look! Thank you, Holger
Hi KT,
In atonement:
Please Login or Register to view this content.
Hi,m xladept,
Does your code merge all the contents into one sheet (Sheet1) in an exisitng workbook? Please read the request carefully and try to offer code in a way that starters may follow easily. For your approach it would be easier to use SaveAs for a different extension of the workbook or SaveCopyAs for a backup.I didn't read the whole description
Ciao,
Holger
Hi KT,
Holger is right and I'm wrong againSorry, I'll edit for your requirement anon
Hi KT,
See if this works for you:
*When you replace "Your Book Name" in the code don't forget the ".xlsx" extensionPlease Login or Register to view this content.
Last edited by xladept; 10-11-2014 at 04:23 PM.
Hey Holger and xladept,
Sorry for the late responses. But no, my code doesn't merge all the sheets into one sheet. Basically, I have 15,000 lines of data, I have another code that looks for the unique data and places each group of customer codes as its own worksheet in one book (so I end up with 400 different sheets in one workbook). Each sheet is saved as the customer id name (which is what I need). Then, I have a separate excel workbook (named Template.xlsm) with two sheets in it. Sheet 1 of the template.xlsm document is where I want the data from one of the sheets to post. The code would then save the template.xlsm file as that specific customer code. The code needs to loop to do the same thing for each sheet of customer codes. Essentially I will end up with 400 workbooks, with the data from each sheet of customer codes, pasted into sheet one in each workbook.
Xladept,
I get error #9 subscript out of range when I try to run your code.
is what keeps getting highlighted. I tried every variant of my file name but it still does not work. Do I have to put an additional code in the template to get it to run?Please Login or Register to view this content.
You don't include the path in there, and the workbook must be open.
Remember what the dormouse said
Feed your head
Thank you romperstomper, that worked.
However, this code pastes each sheets info into sheet1 of the template. I need each sheet in the original workbook to paste into its own template.
Say there the sheets in the original workbook are named Customer A, Customer B, and Customer C. I need the code to copy the customer A sheet data, into sheet 1 of the template. Save the workbook as Customer A and then exit out. Then the code would loop back and copy the data from customer B, copy the data into a new template workbook, save the workbook as customer B etc.
Try something like this:
Please Login or Register to view this content.
THANK YOU SO MUCH romperstomper!!!!! THAT IS EXACTLY WHAT I NEEDED!
Sorry to add something,
But the macros I have in the template don't copy to the new workbooks created. Is there a quick fix to this? I have a macro that emails each copy to me, and a print option
the new workbooks created are .xlsx files where as the template is a macro file (.xlsm).
Change this line:
to this:Please Login or Register to view this content.
Please Login or Register to view this content.
Perfection, that worked. Thank you, once again, romperstomper.
Glad to help.
Hi KT,
Thanks for the rep!
Please Login or Register to view this content.
Whoops! I was answering a post on the first page:\
Last edited by xladept; 10-13-2014 at 02:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks