This is very hard to explain but here it goes.
I have a spreadsheet A which columns B to J, Q and R from row 3 to 2000 are reference cells to another spreadsheet (in a separate file/workbook - spreadsheet B) are referenced from.
In spreadsheet A, Columns K to P from rows 3 to 2000 are drop down list YES/NO and have conditional formatting for cell color (local cells, not reference)
Here's my problem...
Dept that updates spreadsheet B, adds, inserts, or deletes rows which affect columns B to J, Q and R of spreadsheet A. This Dept will not keep lines to delete and put strike through lines nor add to bottom all the time of spreadsheet B.
As a result, spreadsheet A, columns B to J, Q and R keeps offsetting data compared to columns K to P.
Is there any way to auto-sort or auto-offset columns K to P in spreadsheet A when spreadsheet B changes?
I have a spreadsheet A which columns B to J, Q and R from row 3 to 2000 are reference cells to another spreadsheet (in a separate file/workbook - spreadsheet B) are referenced from.
In spreadsheet A, Columns K to P from rows 3 to 2000 are drop down list YES/NO and have conditional formatting for cell color (local cells, not reference)
Here's my problem...
Dept that updates spreadsheet B, adds, inserts, or deletes rows which affect columns B to J, Q and R of spreadsheet A. This Dept will not keep lines to delete and put strike through lines nor add to bottom all the time of spreadsheet B.
As a result, spreadsheet A, columns B to J, Q and R keeps offsetting data compared to columns K to P.
Is there any way to auto-sort or auto-offset columns K to P in spreadsheet A when spreadsheet B changes?
Last edited:
