I have a Formula that gets data from another tab
EXAMPLE:
=' TAB NAME'!$C$16
I want to be able to put a number in a different CELL that will change the
16 on the above formula... so if i a put a 19 in A1, the formula will get
information from the other tab, in the C Column, and the 19th row... (not
real good with excel terminalogy.. sry) Need this for updating a page...
with many different column Letters and the same 16, need to change them all
by hand at the moment.
Thanks in Advance
(please give examples as i may not understand it right away =P)