Fill down formula based on another column data

**krjoshi** · 03-17-2012, 06:10 AM

Hi Folks,

I have some formulas in Cells “V3” and “W3”. I want to fill down the formula if I enter new data in Q column. I have built below code to this but I am getting this error “ method ‘Range’ of object ‘_Worksheet’ failed”. Please help me.

Please Login or Register  to view this content.

Thanks in advance,

Joshi

**rscsmith** · 03-17-2012, 07:07 AM

Hi Joshi

I've been playing with this, and it seems to fail if I don't have two rows to fill from (i.e. V2:V3).

I would try Copy instead of AutoFill:

Please Login or Register  to view this content.

Best regards, Rob.

**krjoshi** · 03-18-2012, 10:41 AM

Hi Rob,
Thanks for sharing ideas. Its working great.

Thanks,

Joshi

Fill down formula based on another column data

LinkBack

Thread Tools

Rate This Thread

Display

Fill down formula based on another column data

Re: Fill down formula based on another column data

Re: Fill down formula based on another column data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions