LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Summary Sheet Automatically MarkT Excel Discussion (Misc queries) 7 December 18th 07 07:43 PM
How can I get data to automatically update using a master sheet? Julia Excel Worksheet Functions 0 July 30th 07 05:58 PM
how do I update a sheet automatically with the info from another? Richard New Users to Excel 3 April 21st 06 08:17 PM
Copying (Master) column to another sheet to automatically update LostInVirtualSpace Excel Worksheet Functions 0 September 19th 05 06:57 PM
How do I set my webpage to automatically update a changing spread. kluelessinky Excel Discussion (Misc queries) 0 February 10th 05 01:43 PM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"