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
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