View Single Post
  #4   Report Post  
Duke Carey
 
Posts: n/a
Default

Copy the pertinent range on the sheet you want to subtract. Move to
theother sheet and select the top left corner of the same range. From the
menu select EditPaste SpecialSubtract

"jennifer" wrote in message
...
I have two sheets in the same format. Is there a quick way to subtract the
entire sheet one from the other or do I have to resort to just doing a
subtract formula and copying to relevant cells?

Thanks!