I am trying to create a macro that will sum the previous week's time entered in the USAGE VIEW to a custom field in the GANNT VIEW. any ideas?