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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to be able to create a dynamic reference in excel, for exam
Hi!
Try this: =INDIRECT("''tab2'!C"&Y2) Biff "Lee" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to be able to create a dynamic reference in excel, for
Thanks for the response... but I'm getting a #REF
What can I show you to work through this? Thanks, Lee "Biff" wrote: Hi! Try this: =INDIRECT("''tab2'!C"&Y2) Biff "Lee" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to be able to create a dynamic reference in excel, for
I removed one of the ' before tab2 and it seems to now be working!
Thanks for your help! "Biff" wrote: Hi! Try this: =INDIRECT("''tab2'!C"&Y2) Biff "Lee" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to be able to create a dynamic reference in excel, for
Ooops!
I think I had one too many ' in there. Here's the "exploded" view for easy reading: =INDIRECT( " ' tab2 ' ! C " & Y2 ) Just remove all the spaces. Biff "Lee" wrote in message ... Thanks for the response... but I'm getting a #REF What can I show you to work through this? Thanks, Lee "Biff" wrote: Hi! Try this: =INDIRECT("''tab2'!C"&Y2) Biff "Lee" wrote in message ... 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? |
Reply |
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) |