Dear All,
Please refer to the attached excel file which is having nearly 10 worksheets in it.
Actually this is the loading list for shipping out containers.
I have updated formulas in sheets name BRG, BRG6, BRG7, Transshipment and 5600(DIS) to get the data from sheet proposed loading list automatically once data is there in proposed loading list sheet.
the problem here is the data from the proposed loading list sheet to other sheets are not sorted, I mean the if the data is for BRG sheet is mentioned in row 117 in proposed loading list sheet it gets updated in same row in BRG sheet.
Is there any formula if the data gets updated in other sheets from Proposed loading list sheet gets sorted out automatically?
Attached excel file for your reference.
Bookmarks