How can I return the current cell address ( eg. 'A1' ) into a formula?
I want to be able to paste the same formula into a different cell in many workbooks that works out a value by looking at two rows up and one column across. The cell I paste the formula into will be different for each workbook but the formula will be refering to values in the same relative locations.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.
I want to be able to paste the same formula into a different cell in many workbooks that works out a value by looking at two rows up and one column across. The cell I paste the formula into will be different for each workbook but the formula will be refering to values in the same relative locations.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.