Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
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. I did play around with power query but I couldn't get anything that works the way I want it to.
I've been playing around with VSTACK but if I include blank rows in the range, they return as "0" in the combined sheet. I need the sheet to have all data in one block, not with loads of blank rows included in-between all the data, example:
Rows 15-30 are blank in the first sheet, but they return 0's in the VSTACK (column A is custom date formatted).
How do I get the formula to ignore blank rows, so that row 31 would be at row 15?
Thanks
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. I did play around with power query but I couldn't get anything that works the way I want it to.
I've been playing around with VSTACK but if I include blank rows in the range, they return as "0" in the combined sheet. I need the sheet to have all data in one block, not with loads of blank rows included in-between all the data, example:
Rows 15-30 are blank in the first sheet, but they return 0's in the VSTACK (column A is custom date formatted).
How do I get the formula to ignore blank rows, so that row 31 would be at row 15?
Thanks