What does this mean ='FY04'!H9

G

Guest

I am continuing a worksheet that someone else createdIt has columns for
fiscal years 1993 throu 2004. I have added a column for 2005. Antoher
column contains the current year information in dollars, the column for 2005
is based on formulas which I understand. However, in the previous year
columns, the cells contain a formula similar to this ='FY04'!H9. I'm
thinking that it has something to do with freezing the cells so that when I
enter the current year dollars, the prior year cells don't change. When I
put a similar formula into last years cells, I get an invalid address error
message. I've never seen the above formula before and it's not listed on the
"About Calculation Operators" page.
 
V

VBA Noob

Hi,


The first part is the page the cell is linked to 'FY04'! (I assume thi
is an abbreviation for the financial year 2004) the second part is th
cell ref on that sheet H9

Nope this helps

VBA Noo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula needed 1
=AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 5
Find last column matching criteria 2
COUNTIF ? 6
Cell Referencing 5
date function 10
if function (if more that 7 nesting) 2
conditional formatting using formulas 2

Top