consolidate command

I am trying to total up materials entered across 80 tabs. I want a macro or function that will look in certain rows and columns to see if there is data there, if there is I want it to copy the information on to a separate sheet. If there are multiple entries with the same name, then the total...

Hi All, I currently have two tables that are on separate worksheets in the same workbook. I want to combine them onto a third worksheet in that same workbook. When I say combine, I mean literally stack one right on top of the other*. Both tables have the same column headers, but all of the data...

I want to bring all the data in different sheets(same file) in a single sheet. The data is in the same format shown below in all the sheets. <tbody> Description Drawing no. EDP Unit Price </tbody> I need to have a single sheet having the same column headings at the top of that...

Excel 2007 I would like to combine a number of spreadsheets that are very different but have one common column: Course number. All the course numbers are from 3 to 5 digits and are of the same data-type in all spreadsheets (numeric, general). Each spreadsheet has different information...

I am working with a very large report 291,000+ lines with about 20 columns. In consolidating line items in the report the consolidate command fails if I select more than 65,500 lines at one time. Does anyone know if there is a hard limit of 65,500 lines for the consolidate command? If I select...