I need to merge for worksheets (in the same workbook) into 1 large worksheet.
Is there a command that does this? Or do you guys have a custom macro that does this?
I need to merge for worksheets (in the same workbook) into 1 large worksheet.
Is there a command that does this? Or do you guys have a custom macro that does this?
Last edited by newbieexceldude; 05-11-2009 at 09:01 PM.
What specifically do you mean by "merge"? Is it more complex than copying all of the data on one sheet, and pasting it into the other sheet (and then sorting or arranging as needed)?
If your situation is more complex, please provide more detail.
Thanks for your reply
I really just need a replacement for cutting and pasting.
Each sheet has about 12 columns (A - L) and some have more rows than others, but not more than 200 per sheet.
Does this help?
hi,
Edit: Sorry Paul, I didn't see your post when I typed this up.
...
Yes, custom macros can be written to do this. You may find some useful techniques on Ron's page: http://www.rondebruin.nl/copy2.htm which I found by Googling http://www.google.co.uk/search?hl=en...erge+sheets%22
If you have further questions, can you please post a dummy workbook with the layout so that helpers can see the context & provide an accurate customised solution for you?
hth
Rob
Last edited by broro183; 05-09-2009 at 07:49 PM.
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Thanks for your reply and the link.
I tried using his macro, but I kept getting an error. I'm not sure why.
Can you please provide more details...?
Which of Ron's macros?
What line does the code stop on (ie highlight yellow)?
Can you please upload an example file for users to work from?
Rob
Maybe something very basic like this:
This macro creates/replaces a sheet called MERGE in the existing workbook and copies all data from sheet1 to sheet(last) one below the other.Please Login or Register to view this content.
Last edited by JBeaucaire; 05-11-2009 at 06:58 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Dude, you're awesome! Works like a charm, except 1 small detail.
It creates an extra row separating the data from each page. No big deal though.
Thanks again. This really helps me out!
Last edited by shg; 05-11-2009 at 06:54 PM. Reason: Deleted spurious quote
First, look back in the code I posted, you'll see a bit in red...change that to a 1 to eliminate the space, which i put in on purpose to make the pages evident.
Second, if that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].
(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)
hi JB,
Just curious, why did you declare ws as an object rather than as a worksheet?
Rob
Slip of the finger...harmless interchangeability in this instance.
lol
Yes, harmless, but it does mean there is limited (no?) Intelli-sense when working with the code.
Anyway - it's mission accomplished now.
R
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks