Is there a formula or way to automate this process?
I am trying to automate my oncall tracking spreadsheet. This is what the first row looks like. What I want to do is be able to just update Column B with the new date and the have the current data in Columns B, C, D shift over one column to the right. The data in Column E would be replaced by the data in Column D. Currently, I am just doing the classic copy and paste.
Column A Column B Column C Column D Column E
Name Most Recent On Call Next On Call Next On Call Next On Call
daJimmer 2/13/2023 1/02/2023 11/19/2022 9/24/2022