I'm combining weekly and bi-weekly payroll amounts into a summary column on a third sheet. The summary sheet is bi-weekly, so it takes the bi-weekly salary from sheet a and the two column weekly hourly from sheet b and adds them together in sheet c. For example:
=Salary!ab2+Temp!cd1+Temp!ce1. This sums, for example the bi-weekly salary with the two weekly payrolls for the same period. My problem is, when coping the summary column in the to the next column for the next bi-weekly period, my Temp!xxx references move 1 column at a time and I need them to jump two columns while the Salary!xxx only jumps once.
In the above example, my next column in the summary sheet should be:
=Salary!ac2+Temp!cf1+Temp!cg1, but I'm getting =Salary!ac2+Temp!cd1+Temp!cf1.
How can I add additional columns for payperiods without manually adjusting the formulas?