I would like to ask some help on next problem:
I have a workbook with about 20 sheets.
Main goals is to gather all 'Remains' into one sheet from all columns. Company, Warehouse, Total for all receivers and Receiver 1, 2, 3, 4 and on and on.
Issues I've faced:
1. How to skip all unnecessary columns (income\outcome) as we can just take latest row to get remains.
2. Get all Receiver names, but the problem is: merged cells, getting #REF or only 1st one and it's shown as Receiver, 0, 0 (in 3 cells)
Attaching a file as example. Thanks. Any help is appreciated.