I have 12 worksheets that are all identical in regards to formatting, cell locations, etc. The sheets are labeled "January", "February", etc.
I have another worksheet that serves as a summary sheet...See Attachment.
The formula in the cell for January at the North Yard is as follows...
=SUM('January '!AG8+'January '!AG12+'January '!AG16+'January '!AG20)
I want the identical formula in the cells for Feb through Dec. Is there a way to drag the formula to the right instead of having to manually select the cells for each cell?
Bookmarks