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.