I apologize if this has been covered somewhere else, but I'm not even sure how to accurately search for my problem. I have a spreadsheet in which I have calculated a lot of data on 3 separate sheets. I'm trying to consolidate the data into a "Totals" sheet. I have used the following formula in cell B5 on the Totals sheet to do this: =$'5th'.B5+$'6th'.B5+$JH.B5+$HS.B5. In cell B6 on the Totals sheet I used this formula: =$5th.C5+$6th.C5+$JH.C5+$HS.C5. I need to drag this formula across the page on the Totals sheet and have it fill in the formula for a cell found in every other column on the individual sheets. I have manually entered in the info for the first two cells, but when I try dragging it across to fill in or copy the formula, it doesn't fill in for every other column, it fills it in consecutively. I am desperate to find a formula to do this automatically to save me hours of time doing it manually. Does anyone have any suggestions?