Can anybody please help me write a code to do this in excel macro? I
tried recording a macro while I was doing auto filter but that does not
work very well for a generic code. I am not copying my code to keep the
confusion away.

IN EACH CELL OF A COLUMN COPY THE FORMULA FROM PREVIOUS CELL (IN THE
SAME COLUMN) IF THE ADJACENT CELL ON LEFT HAS A VALUE OTHERWISE STOP.
SO, FOR EXAMPLE IF I AM IN CELL “I3”. I WANT TO CHECK IF “H3” IS EMPTY
OR NOT, IF “H3” HAS A VALUE (JUST ANYTHING) THEN COPY FORMULA FROM “I2”
INTO “I3”. AND DO SAME FOR “I4”…WHICH IS, CHECK IF “H4” IS EMPTY OR NOT,
IF “H4 HAS A VALUE THEN COPY FORMULA FROM “I3” INTO “I4”… AND WHEN AN
EMPTY CELL IS ENCOUNTERED IN COLUMN “H” THEN STOP.
THEN PARSE THROUGH ALL THE CELLS IN COLUMN “I” AGAIN AND IF A CELL HAS
“#N/A” VALUE THEN FILL CELL WITH SOMETHING OR IF A CELL HAS SOMETHING
ELSE THEN DO NOTHING AND GO TO NEXT CELL OR IF CELL IS EMPTY THEN STOP.

Thank you very much.

Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=474794