Thread: Adding Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
STEVEB STEVEB is offline
external usenet poster
 
Posts: 1
Default Adding Cells


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

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=48329