| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to be able to create a dynamic reference in excel, for exam
My 1st tab is a summary report... references information for all the other
tabs. I want to be able to automatically update the summary report on the first tab, by entering the day # of the year, and from this... the reports will automatically reference the next row (based on day) on the other tabs - so that I don't have to manually update each of the references in my report meaning... I start out with this formula in the First Tab: ='tab2'!C94 but I want to make the row 94 dependant upon a cell in tab1, so I'm trying: ='tab2'!C(Y2) but this is giving me an error message. Does anyone have any suggestions how I could proceed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create the formula "cumsum" in excel | Excel Worksheet Functions | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Create database in excel? | New Users to Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| i need to create an invioce in EXCEL and then send it into a WORD. | Excel Discussion (Misc queries) | |||
Threaded Mode
