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) on 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 on Sheet 2 Cell A2 is $5. I would like a Macro that would find the last cell on Sheet 1 Column B and add it to the existing value of Cell A2 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" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> Does anyone have any suggestions for the following:
>
> I would like to add the last cell in column B (The row varies daily) on
> 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 on
> Sheet 2 Cell A2 is $5. I would like a Macro that would find the last
> cell on Sheet 1 Column B and add it to the existing value of Cell A2
> Sheet 2 to create a new cell value of $105.
>
> Any help would be greatly appreciated.
>
>
> --
> STEVEB
> ------------------------------------------------------------------------
> STEVEB's Profile:
> http://www.excelforum.com/member.php...fo&userid=1872
> View this thread: http://www.excelforum.com/showthread...hreadid=483281
>

[STEVEB]

Thanks Sandy,

I appreciate your help!