All,
I have a spreadsheet with 20 columns of data. I use a Sales system that I can refresh data from directly in excel. Based on that data, I have some calculations to the right in columns following the pull. The sales system pulls about 10 columns of data, and then based on those pulls (which refresh weekly), 7 of the 10 columns on the right re-calculate to the right. Another positive is that when a new sales deal is added, it adds directly to the bottom.
Here is my issue - I did a random refresh and notice that 3 deals fell out of the middle. There's no problem witht the calculations columns since they auto-update. Unfortunately, 3 of the columns MUST be snap shots from the start so they can compare to the refresh so it can be tracked over time. Obviously when 3 middle rows disappear, these "paste as values" or "constants" or locked rows or whatever are now misaligned.
Any general advice on how to handle or readings you can point me to for ideas on handling? Hope the quetsion isn't too generic.
Thanks!
I have a spreadsheet with 20 columns of data. I use a Sales system that I can refresh data from directly in excel. Based on that data, I have some calculations to the right in columns following the pull. The sales system pulls about 10 columns of data, and then based on those pulls (which refresh weekly), 7 of the 10 columns on the right re-calculate to the right. Another positive is that when a new sales deal is added, it adds directly to the bottom.
Here is my issue - I did a random refresh and notice that 3 deals fell out of the middle. There's no problem witht the calculations columns since they auto-update. Unfortunately, 3 of the columns MUST be snap shots from the start so they can compare to the refresh so it can be tracked over time. Obviously when 3 middle rows disappear, these "paste as values" or "constants" or locked rows or whatever are now misaligned.
Any general advice on how to handle or readings you can point me to for ideas on handling? Hope the quetsion isn't too generic.
Thanks!
