Hi Havenstar. Try using Edit-Replace and replace #REF with MANPOWER. I use
this method to update a P & L report based on a download from QuickBooks
every month and it works great. HTH
--
Sincerely, Michael Colvin


"Havenstar" wrote:

I am trying to pull information from a schedule and am running into a
problem. The person updating the schedule deletes the previous week and my
formula result changes to #REF!. Is there an easy way to fix this.

I had fixed this using a Macro but he added rows and my Macro got messed up.

The formula I am using is =SUM(MANPOWER!F49:I49).
Thank you,
Havenstar