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