Chinngineer

New Member
Joined
Mar 5, 2019
Messages
3
Is there a way to assign a date to when a sheet updates information from another sheet?
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Col Delane

Active Member
Joined
Jan 14, 2014
Messages
303
  1. Decide on a cell on the sheet being updated that will hold the date upon which the update should occur.
  2. Assign that cell to a Defined Name (say "Update_Date")
  3. Enter your required update date.
  4. Switch Excel's Calculation mode to MANUAL, then add some VBA to the sheet object of the sheet being updated that recalculates (and therefore updates) that sheet ONLY if the current system date ("DATE) = the specified date entered in "Update_Date"
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,965
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top