Oct 26 2021 03:31 PM
I have a spreadsheet that I use to track our load pays for payroll. I have tabs that signify each payroll period and a tab that has all of the loads, their pay and W/C Code. I have to change rates for some of the loads. If I change it in the load list page it changes all previous pay period totals that had those loads hauled. This throws off my payroll for year end.
Is there a way to lock previous pay period tabs, so those amounts won't change? I don't really want to start adding more of the same loads, just putting 2021 after them. For instance, OC - Dila Dairy vs. OC - Dila Dairy 2021. This just adds too many loads I have to sort through when entering time cards.
Hope this makes sense and that there is a simple solution. Thank you for any all info.
Randy
Oct 26 2021 04:33 PM
SolutionOct 26 2021 04:55 PM
@mtarler - Never thought of copying and pasting into another sheet. I guess that would be easiest. I'll start that and if there is a "lock" tab way to do it later, I can always change.
Thanks.
Oct 26 2021 04:33 PM
Solution