Hello.
I'm working on a Delivery schedule. I have 2 data tables, one for item weight based on item codes, one for customer location (City and District) and travel time.
In my working sheet I have some index/match formulas to extract such information and each new sheet is a different day. Everytime I use the worksheet, I would copy paste the previous day to values to make sure theres only one sheet with ongoing calculations. However every new sheet made the file more and more bloated and the file become very difficult to work with due to loading time.
Can someone examine my file and show me what I did wrong, or how should I optimise my file. Thanks,
My file
I'm working on a Delivery schedule. I have 2 data tables, one for item weight based on item codes, one for customer location (City and District) and travel time.
In my working sheet I have some index/match formulas to extract such information and each new sheet is a different day. Everytime I use the worksheet, I would copy paste the previous day to values to make sure theres only one sheet with ongoing calculations. However every new sheet made the file more and more bloated and the file become very difficult to work with due to loading time.
Can someone examine my file and show me what I did wrong, or how should I optimise my file. Thanks,
My file