Combine Multiple Sheets into One and Update Continuously

purpleeagle

New Member
Joined
Feb 3, 2014
Messages
2
Hello,
I am brand new to this forum and am having some trouble finding a Macro that fits my needs. My problem is this: I have a workbook with 6 sheets that I update daily: 1-10, 2-8, 1-67, 3-16, 2STB, 204th. They all contain a header row and the last row in each sheet is used to calculate subtotals. What I need is a macro that will copy and paste all the rows containing data (not the header and not the subtotal) into one "Master" sheet. Ideally, each time I add row to one of the 6 sheets, I would like it automatically be added to the master sheet. There are other sheets in my workbook that I do not want to be included in this function as they simply serve as references for my VLOOKUP functions in my 6 working sheets. I have experimented with lots of Copy/Paste rows code that I've found on the forum but as I am brand new to VBA have not been able to manipulate it to fit my needs. Also, is there anyway I can upload my spreadsheet so that the people working my questions can actually work with my sheet? I see the HTML maker download is not up right now for some reason when I look for it on the site. I am working with the 2010 version of Excel. Please let me know if the example provided is not sufficient or not in the proper decorum per forum etiquette. Thanks for the help and I will post my second issue in a new thread.

Control #Losing BNGaining UIC Gaining BNGaining BDELin Nomenclature Qty QTY ExecutedDST Suspense Days Remaining DST SuspenseDays Remaining Remarks Status in DSTFSCAbove/Below LineIUID
D.13.340.19781-10 CAVWANLAAHQ, 1ABCT1ABCT70156NPAPER SHREDDING MACHINE, ELECTRIC MTR DR1 February 28, 2014266-Jan-14-27RECLAMA; UnservicableOpen Below
D.13.352.29918131-10 CAVWE5JAAHHD, 759TH MP BN 759 MPT41203TRK CGO W/MHE M1084A11 January 24, 2014-924-Jan-14-9DOLOpen1-10 FSCAbove
D.13.345.7881-10 CAVWHZZAA1-25 ATK4th CABT87243TRK TK FS M9781 January 1, 2014-3231-Jan-14-2DOL; Ready for PU; GUIC needs to extend if cannot meet suspenseOpen1-10 FSCAbove
D.13.307.71-10 CAVWJKGAASTB1ABCTA79381 ANT GRP OE-254()/GRC 4 December 31, 2013-3315-Feb-1413Moved to 2/15 by Chief SuttonOpen Above
70
<colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;" span="2"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="141" style="width: 106pt; mso-width-source: userset; mso-width-alt: 5156;"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="394" style="width: 296pt; mso-width-source: userset; mso-width-alt: 14409;"> <col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="123" style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" span="3"> <col width="222" style="width: 167pt; mso-width-source: userset; mso-width-alt: 8118;"> <col width="64" style="width: 48pt;" span="2"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,122,604
Messages
5,597,128
Members
414,126
Latest member
jellevansoelen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top