combine sheets

I have a workbook with sheets for each financial year from 2010 onwards. All column headers are the same across all sheets. I need to be able to combine all the sheets into one sheet *BUT* I need this combined sheet to change with the others if rows are added/deleted in any of the other sheets...

Hello Gurus, I'm currently working on a project and using below VBA codes. Sub Consolidate Application.ScreenUpdating = False Dim LastRow As Long, ws As Worksheet, desWS As Worksheet LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row If Not...

The title makes this sound simple enough but my problem is that the source information is live (shared through Office 365) and also formatted in a way that makes it tricky to combine. I have tried to get the people I work with used to a format that doesn't have date headers but they found this...

Hello! I have built an ordering workbook in which 12 different markets have a designated sheet to place hardware orders. The sheets are titled: Netherlands Portugal Austria Italy Belgium Russia Ukraine Poland Spain Switzerland Czech Republic Slovakia Each sheet has the exact same columns (I...

Hello, I have 2 sheets. Sheet 1: Sheet 2: Part # Description Weight Part # Description Price a xxxxx 2 b xxxxx 1.00 b xxxxx...

Help needed! I have multiple sheets within a workbook that I use to input information for particular pieces of plant and the history of the items. I'm wanting to combine all of these sheets within one sheet for ease of printing (and so as to not waste paper). However, I'm wanting a way to do so...

I have 6 worksheets: Aug (2015) Sept (2015) Oct (2015) Nov (2015) Dec (2015) Jan (2016) Each is formatted EXACTLY the same. The data contains individuals and their specific performance information for the respective period. There may be someone who appears on 1 or more sheets and their maybe...

Hi everybody I have a master file named "Trial.xlsm" and Files as Project01.xlsm, Project02.xlsm ...to 30 in a server... Trial file have two sheets "Report" and "Data". Project01...30 files having a sheet named "List" and a Chart also. *Note: Among these files Project01 to 30, any file will be...

So I got assigned the project of the year for the company. I need to combine about 15 years of inventory into a searchable database so that I can import it into our new software. I managed to normalize the data from its multiple "index cards" to lists on worksheets. Now I need to combine those...

Does anyone know how to do this? I would like to keep the file name the data came from in the first column of the combined worksheet. If possible, I would like to skip blank rows but insert one blank row between combined worksheets or export worksheet name with each line of exported data. The...