Hi, I have 2 tabs within the same Excel workbook. Both tabs have exactly the same structure (i.e. number of columns and their headers), while the data itself is slightly different. These two tabs are getting updated independently on an ongoing basis.
Is there a way to generate a formula which would be combining the output from both sheets onto a new sheet in the existing workbook? As a one-off solution, copy/paste works just as well but it's not sustainable long term
My ranges are columns A-V and rows 12-50000 on both tabs (currently either tab has about 300 entries but this is growing fast). A related concern is to try and avoid empty rows in the middle of a new worksheet when joining 2 sheets... any advice appreciated!
Is there a way to generate a formula which would be combining the output from both sheets onto a new sheet in the existing workbook? As a one-off solution, copy/paste works just as well but it's not sustainable long term
My ranges are columns A-V and rows 12-50000 on both tabs (currently either tab has about 300 entries but this is growing fast). A related concern is to try and avoid empty rows in the middle of a new worksheet when joining 2 sheets... any advice appreciated!