So I have a monthly spreadsheet for every month and then a totals sheet to show an annual count, but it does have a month by month breakdown. On every monthly spreadsheet I have a totals cell that is the same for every month, but I have 28 different things that I am tracking that has a total. So for instance in my totals page in cell c3 it will read =January!C$53 cell c4 will read =February!C$53 cell c5 will read =March!C$53, so on and so on. Is there anyway for me to just put in the January cell total, and then drag down so it pulls cell C53 from every months page, so I don't have to click on every months tab and click on cell C53?
Sorry if this is confusing. Let me know if you have questions or if I need to post any spreadsheets to clarify. Thank you for your help this would save me a lot of time clicking through all of the sheets.
Thanks again!
Bookmarks