getting values from adjacent columns on same row

[Elemental]

hi again

i was making a button that i'm not sure how to complete, and what i wanted it to do was enter a formula into column E on a row i select, that equaled the text "LAST RECORD FOR" and then added the date on the same row in column B, and if possible, only added the year value of that date.

so it would look like

[ ][ 27/9/02 ][ 6500 ][ ][LAST RECORD FOR 2002]

anybody know ?

 

[gnaga]

Use the formula in E1

="Last Record For Year " & Year(B1)

should return in E1 as

Last Record For Year 2002

if your date in b1 is within year 2002.

GNAga
This message was edited by gnaga on 2002-09-26 20:44

 

[Elemental]

just got back from lunch



thanks heaps !

 

[Elemental]

now if i could just change the 1 to activecell

would that work ?

 

[gnaga]

It should work for your activecell.

GNaga