PDA

View Full Version : [SOLVED] Circular Reference Error



av8tordude
12-06-2013, 09:22 AM
The formula in column "F" is causing a circular reference error. Is there a different formula I can use that I can substitute or maybe a VBA that I can used to fill this task? What I'm trying to achieve is put whatever value in cell "G1" into column "F" if column "G" has a number greater than zero (0). I've attached a sample book.

Thanks for your assistance.

sassora
12-07-2013, 08:25 AM
For the first of the circular references, replace G8 in the F8 formula with the contents of the G8 formula. Edit the rest in a similar way.

Using some named ranges could make the formulas in the sheet easier to understand.

By the way, snap on our join dates!

av8tordude
12-07-2013, 09:38 AM
Thanks Sassora :-)

BTW, what so you mean snap on our join dates?

sassora
12-07-2013, 10:02 AM
We both joined in VBAX in Jan 2008