circular reference

[eladkroy]

I have a spreadsheet that figures bonus pay off of a sliding scale based on a job's gross profit. It works exactly as planned. I have attempted to post the results of each job report to a new worksheet to keep a running total of job hours and bonuses. I created a macro using the record macro option and have assigned it to a "Post" button. It posts all of the information on the new sheet as designed, but gave me a "circular reference" warning for the bonuses column when I created it. Also, i can keep a running total (sum) of the hours, but not the bonuses. Do you have any suggestions for a way to keep a running total of the bonus amounts my form calculates?

[daffodil11]

The primary issue that is creating the circular reference warning is that when you just use an ordinary copy and paste, you're just pasting the same formulas you used before and their relative references may no longer be valid.

Instead, if you are only keeping the output of your form for posterity and to have running totals, just use Paste Values. Copy, right click the destination, and choose the little "123" icon. This will only paste the actual numbers that come as a result of the formulas.

If you scrub the sensitive information from your form and post it, I'll gladly take a look at how to do what you'd like it to.

[eladkroy]

Thank you for the quick and most helpful response. My spreadsheet is purring contentedly and so am I.

[daffodil11]

Glad I could help.