auto fill of formulas that based on cells

[albert28]

Hi Guys,

Is there any vba codes that can fill automatically the formulas from last empty row. but the formulas is in Row A1,b1,c1,D1? Formulas consist of vlookup,


Thanks advance!

[ajryan88]

Please Login or Register  to view this content.

I hope this helps

[albert28]

thanks ajryan88.

but I need to populate formulas based on Row 1 and paste it as values afterwards.

see attached sample file.

[ajryan88]

More like this?

[albert28]

yes but i need to populate the formulas if Column A and B is not blank. and paste the formula as values.

[albert28]

moreover, if column A and B have a data and not blank the formula from row 1 will populate on column C2 downwards, and if i dump another data from the last cell of column A and B will do the same process.

hope u can help me with this

[ajryan88]

OK that explains things a little bit better.

How about now?