B
Buffyslay_co_uk
Hi
anyone got any idea on this?
I am using Excel 2000 (SP-3)
I have a vlookup, which is picking up data from another page in the
same workbook, I have to F2 and then Enter to make Formula Work. If i
make changes then i have to do this again.
This also happens when i copy/paste values (I am consolidating lots of
data all linked by unique id, and want to get it into a single usable
workbook - would rather use access, but am not allowed!)
Any ideas? Thought about doing the F2/Enter in vba, but that didnt
seem to work either!
P
http://www.buffyslay.co.uk
anyone got any idea on this?
I am using Excel 2000 (SP-3)
I have a vlookup, which is picking up data from another page in the
same workbook, I have to F2 and then Enter to make Formula Work. If i
make changes then i have to do this again.
This also happens when i copy/paste values (I am consolidating lots of
data all linked by unique id, and want to get it into a single usable
workbook - would rather use access, but am not allowed!)
Any ideas? Thought about doing the F2/Enter in vba, but that didnt
seem to work either!
P
http://www.buffyslay.co.uk