Adding

[STEVEB]

Hi,

Does anyone have any suggestions for the following:

I would like to add the last cell in column B (The row varies daily) o
sheet 1 to the existing amount on Sheet 2 Cell A2.

For example the last cell on Sheet 1 column B is $100. The amount o
Sheet 2 Cell A2 is $5. I would like a Macro that would find the las
cell on Sheet 1 Column B and add it to the existing value of Cell A
Sheet 2 to create a new cell value of $105.

Any help would be greatly appreciated

 

[Sandy Mann]

I don't recommend it but try:

Select Tools > Options > Calculation
check *Iteration* and input 1 into Maximum Iterations

Now enter :

=A2+LOOKUP(9.99999999999999E+307,Sheet1!B:B)

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk

 

[STEVEB]

Thanks Sandy,

I appreciate your help!