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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.