consolidate sheets

I've been having some trouble creating a consolidated orders list from multiple vendors into one masters orders list. I receive files from various vendors which means the data is not set up in the same order or even with the same headers. I need to create a master order list with the following...

Hi I am trying to consolidate multiple sheets into 1 tab. I don't know how to use the sumif because 2 of my criteria are in the same column: the customer name and the value name. I don't even know exactly what formula to use...all help would be appreciated. I am trying to consolidate data in...

I'm working on a company project where I've been asked to use the sumifs function. The issue I got is that I need to combine multiple sheets with different criteria. At this moment, all I've is a Master sheet where I've details about the columns of different worksheets, and the other 3 sheets...

Hello I am on MAC right now, I have 51 spreadsheets with 50 rows and about 25 columns each one, I tried to consolidate but there are many errors when there is a blank column, cell or row. Is there a way to just copy in sequence the lines data from A1 to Z50 from all spreadsheets to one? Any...

HI Forum I've got a question on how to create a summary workbook Here is what I have. - about 15 files, all with 20 sheets - all with different content, but exactly the same structure Here is what I need: - 1 file with the same 20 sheets and the same structure but all the cells are...

Hi Everyone, I am trying to figure out a way to consolidate multiple user's data from different sheets to single master excel sheet using Macros. Eg: . user 1 selects particular rows and once macro is run, these data should automatically get pasted in the last empty rows in master excel sheet...

I have a Master Forecast Report (MFR) in which each resulting column comes from various worksheets in the workbook. The MFR has the following columns that require population from the other worksheets: A: Client Name B: Billed C: Potential New Revenue (PNR) D: PNR Probability E: Forecast...

Hi Guys, I'm seeking some assistance in trying to merge several sheets in a workbook. The problem i'm experiencing is that because the workbook is shared and protected, I do not have the ability to utilize VBA. I also tried to use the add on Kutools. Not sure if you have heard of it, but...