Deleting Columns - Formula Results turn to #REF!
Sandi, could you post back what the formula looks like when the #REF! is
included?
--
Sincerely, Michael Colvin
"Havenstar" wrote:
Hi Michael,
I tried that and I got #NAME?, which gave me a formula of
=SUM(MANPOWER!MANPOWER). Any other ideas?
Thanks
Sandi
"Michael" wrote:
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
|