Merging Worksheets

sniderrn03

New Member
Joined
Aug 25, 2011
Messages
12
Hello,
I am extremely new to macros/VBA in excel. I have been reading through the threads, however, am having difficulty changing the current macros shown to what I need. I am sure this is due to my inexperience.
I have a workbook with 8 worksheets. The first 6 worksheets are going to have 14 columns (Date of entry; Priority/Severity; Provider Name; NPI; Member Name; Member ID; PA Number; Issue 1; Issues 2(optional); Issue 3 (optional); disposition of PA; Additional Information; Reported by). The 7th and 8th worksheets have other information, however, I do not want to merge these worksheets.
My goal is to merge worksheets 1-5 into worksheet 6 that is labeled: All Current and Entered. I would like worksheet 6 to auto update as changes or new rows are added to worksheets 1-5.

Any help would be greatly appreciated.
Thank you,
Sniderrn03
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

sniderrn03

New Member
Joined
Aug 25, 2011
Messages
12
Thank you for the link. I had read through this link from other questions I had found in he forum, however, the code that this link shows is not providing what I need for this particular file. It first gives me an error on the LastRow code and according to the instructions, it is just going to add a new worksheet, which is not what I am looking for at this point. I have a current master worksheet 6 with some data that was manually copied in, however, I obviously am trying to avoid the manual cut and paste as others update their individual worksheets 1 - 5. I also don't see how the code listed in the link provides automatic updating from the worksheets 1 - 5 when new rows are added.
Thank you,
 

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,591
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top