Macro to fill cells with formulas, text and blanks

[muhleebbin]

Thanks in advance for your assistance with this!

Is it possible to create a macro that fills cells with formulas, text and/or blanks depending on the cells in column C?

My workbook is currently structured with a master list of accounts in Sheet2('Variables') and Sheet1('Report'). On Sheet2, column a is the master list and columns b thru j are the potential options to fill from. Most are formulas, some are texts and a few i'd like to leave blank.


This is currently what i'm working with but as you can tell going through 349 rows of this would make this quite tedious and annoying

Worksheets("Sheet1").Range("D13").Formula = "=VLOOKUP($C13,$AT$13:$BA$13,D$8,FALSE)"

The blank cells is what's currently really throwing me in for a loop

 

[muhleebbin]

When I go to put in the formula it gives a compile error....sorry still new to this.

In the first examples you helped with, there doesn't seem to be an issue with the macro, rather an issue with the formula itself. The formula itself should work on its own when used in the report, correct? Would a secondary coding that clears out the "" work?

 

[paldob]

Sorry mate I haven’t had a chance to test any of the formula on excel. The “” means blank in excel so not sure why it’s pulling through. I’ll get on my laptop later today and let you know