I'm trying to set up a spreadsheet that has a summary page with information displayed in rows but each cell in the row is a formula that is referring to other sheets in the same workbook that shows information in columns.
Example
Cell A1 on summary sheet refers to cells C1+D1-F1 on other worksheet
Cell B1 on summary sheet refers to cells C2+D2-F2 on other worksheet
Cell C1 on summary sheet refers to cells C3+D3-F3 on other worksheet
I need the summary sheet to refer to lots of information for a year in weekly buckets so can anyone help me with copying the type of formula above into summary sheet.
Many Thanks for any help you can give.
Muireann
Bookmarks