Merge tables/cells from multiple worksheets

cpking

New Member
Joined
Jun 8, 2020
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I have a workbook that contains several worksheet, each with exactly the same layout but differing data. This is an expense report and each worksheet is a different employee's expense report. Each sheet has varying numbers of entries, and is broken into (possibly) two pages. Page 1 and page 2 totals are added and summed at the bottom of the first page as most reports are only one page long. Each of the two pages contain tables of that set of expenses. For example, Clayton's expense reports consists of Clayton1 and Clayton2; Mitch's are Mitch1 and Mitch2, and so on.

My goal is to consolidate the nonempty rows of each table into a new worksheet. This worksheet would follow the same layout as the expense reports, but would also have additional columns used to manipulate the data, all for the purpose of importing into Quickbooks later.

Any thoughts on the best (and easiest) approach?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

vw412

Active Member
Joined
Dec 16, 2011
Messages
343
Office Version
  1. 2019
  2. 2016
  3. 2010
  4. 2007
Platform
  1. Windows
Some questions:

Are you wanting to consolidate each employee's two expense report pages into 1 single worksheet? Or are you wanting to consolidate all employees sheets into one "master" sheet?

The new worksheet that will contain the consolidated data, should it only have detail data or should it also have all the totals/subtotals and any other non-detail data?

Will the consolidation process simply be a straight copy of rows or will there be some data merging or manipulation involved?

Could you perform the process you want done by hand and track all the steps you performed to get to your final product? That will go a long way to helping you automate the process.
 

Forum statistics

Threads
1,141,413
Messages
5,706,300
Members
421,440
Latest member
cmphares

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