Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Formula Not Adjusting Down the Column
I have a spreadsheet that has a summary sheet and multiple tabs. I have the
following formula in one of my summary sheet columns: =IF('1300'!$F$9=" "," ",'1300'!$F$9) -where 1300 is the name of one of the tabs and F9 within each tab is the piece of information I want pulled into the summary tab. The formula works correctly when I manually type it into any row with any tab # within it, so I think the formula itself is ok. However, it's not letting me drag the formula through the column and autofilling by changing 1300 to 1301, 1302, etc(representing pulling information off each consecutive tab). I already check that my calculation option is set to automatic and I've F9'd about 10 times now. Any other suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Formula Not Adjusting Down the Column
Try:
=IF(INDIRECT("'" & (ROW()-1+1300) &"'!$F$9")=" "," ",INDIRECT("'" & (ROW()-1+1300) &"'!$F$9")) Adjust to your starting row. HTH "lost in excel" wrote: I have a spreadsheet that has a summary sheet and multiple tabs. I have the following formula in one of my summary sheet columns: =IF('1300'!$F$9=" "," ",'1300'!$F$9) -where 1300 is the name of one of the tabs and F9 within each tab is the piece of information I want pulled into the summary tab. The formula works correctly when I manually type it into any row with any tab # within it, so I think the formula itself is ok. However, it's not letting me drag the formula through the column and autofilling by changing 1300 to 1301, 1302, etc(representing pulling information off each consecutive tab). I already check that my calculation option is set to automatic and I've F9'd about 10 times now. Any other suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adjusting column width using keystrokes | Excel Discussion (Misc queries) | |||
Fill a column with a formula | Excel Discussion (Misc queries) | |||
Adjusting Formula | Excel Worksheet Functions | |||
How do I quickly fill a formula result into a column of cells? | Excel Worksheet Functions | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |