View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
QP1 QP1 is offline
external usenet poster
 
Posts: 1
Default update a sheet automatically with changing values from another she

Hello,

I would like to create a macro so that when I close my workbook, my "total
days" value and "total cost" value (which are in my "Cost Tracking Summary"
Sheet) are added to a new row of a table on a different worksheet, only if
the "Total Days" has changed. These values (Total Days and Total Cost) are
collated from other worksheets.

If anyone can assist me I would greatly appreicate it.