What I am looking to do is this. I have a dollar figure in a cell on one
sheet. On another sheet I have another dollar figure. I would like to
subtract the dollar figure on Sheet 1 from the dollar figure on Sheet 2. I
will have to do this a lot so the cells will be different each time but I
don't know where to start. Also, I have renamed the worksheets so when doing
the formula will I use the new names in the formula? Or still refer to them
as "Sheet 1" and "Sheet 2"? I hope this makes sense. Thank you.