Inserting cells as part of if function

C

Colin Vicary

I'm using Excel for an inventory spreadsheet where I paste in a colum
of product codes and stock quantities.

I use the if function =if(c1=a1,"Good","Bad") to compare the ne
product code in column c against the existing code in column a to chec
if any products have been added or removed. I sort into product cod
order first!

This works fine and I then manually insert cells in either a or c t
"line things up" again.

Is there any way I can automate the insertion of the cells?

Thanks

Colin (a newbie with a worn out "help" button
 
B

Bob Phillips

Not with the IF statement. Could be done with event code when the cell
changes.

Give details of which cells get the formula, where the inserts go for
further help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

Colin Vicary

Column a contains prouct codes 1(0, 20,30 for example) and column b a
qty.

I am given a .csv of product code and qty sold this week which I then
drop into column c and d. In e I put the formula that checks if the
product code in a and c are the same.

If a new product code is added (13 for example) my function would
report that back. What I then want to do is to then insert product code
13 in column a and the qty in column b, making a and c match again. I
would need to move down the data in column a and c.

Does that make sense?
 
Top