In the workbook whose worksheets you want to consolidate, choose Data | Consolidate. (See Figure 1.) There are many controls in the dialog box, but the primary thing you need to worry about is specifying the ranges to consolidate. When you specify the range reference, you click Add, and the reference appears in the All References list. Range("A1") ' work through sheets For J = 2 To Sheets. I need to merge the sheets so that the columns are as follows: Donor Name Total Gifts 2012 Total Amount 2012 Total Gifts 2013 Total Giving 2013 etc. You continue to define reference ranges until they are all complete. So you may have given in 2012, 2014, 2015 but not 20 therefore those would be left blank. By category means that you want to combine data from tables in which the data may not use a consistent structure. Specify in the box the first range you want to consolidate. Mastering advanced Excel macros has never been easier. You use this type of consolidation if the columns in the data tables are in different orders. If you are consolidating by position, then the reference should not contain any column labels; if by category, then you should. Check out I have 5 sheets with donation history for individual years 2012-2016. Questions on Stack Overflow are expected to relate to programming within the scope defined by the community.Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope.
I shared with him two ways that I typically handle this depending on the complexity and size of the worksheet: (1) manually copying and pasting or (2) using formulas, such as concatenating (=CONC).
If you are on a personal connection, like at home, you can run an anti-virus scan on your device to make sure it is not infected with malware.
If you are at an office or shared network, you can ask the network administrator to run a scan across the network looking for misconfigured or infected devices.
While I have only done this manually a few times, I found it to be extremely time-consuming and more likely to produce errors.
This prompted me to look for a new solution to the issue.