Hi,
The code below automatically fills down columns D19 and E19 with the formula that is in it until the last row which is based off the data in columns A,B and C (so if the data in Columns A,B and C end in row 25 then the last row is row 25). I would like to insert an "if" function that if column D (starting from D19) is already filled down (manually) to at least the second row (D20) then the code below should only fill down column E (from E19) and not touch column D.
Also (this goes for both functions whether one column is already filled out or both aren't) if there is only one row of data in columns A,B and C then there won't be any need to have this code fill down the formula because we only have one row. So I will need an "if" function that if the last row is the 19th row then the code below should not take effect (You might ask, "then don't use this code at all", i'll answer that this code is only part of a bigger code which I didn't feel the need to attach) .

I would appreciate any help on this matter. Thanks in advance.


Please Login or Register  to view this content.