Filldown a specific formula as per the data availability of data in a specific column

[uday]

Hi,

I want a macro that will fill down "=C6*E6" as per the data availability of column C. If the column C does not have any data then it will look for next data availability in C by row.

Please find the attachment. The above mentioned formula is F6 cell of attached file.

 

[Hui]

F6: =IF(ISNUMBER(C6),C6*E6,"")
Copy down

 

[uday]

Thanks for your suggestion Sir. I want to do it by VBA code, because in my attached workbook there are set of table and I am also ignore to copy down all the cells.

 

[uday]

Please find the latest attachment below.