Please help me, I have been using my tried and trusted method for years,
Now it says it is a Circular Reference

When i download data off our Data base it appears like this

CUSTOMER PRODUCT CUST FORULAE
Customer 1 Product1
Product 2
Product 3
Customer 2 Product 1
Product 2
Customer 3 Product 1
Product 3


Imagine this are Cells A1 to B8

In C1 I would normally write the trusted IF(A2="",C1,A2) Then auto fill
down the C Column

This for some reason has become a circular ref, although both C1 & A2
are text and not linked to any other cell

Please help, i am losing my mind

PS The Products will all appear in the B col. Would be great if we
could Paste in this forum


--
MIVELD
------------------------------------------------------------------------
MIVELD's Profile: http://www.excelforum.com/member.php...o&userid=24562
View this thread: http://www.excelforum.com/showthread...hreadid=565928