Hi
I hope all are doing well. Need some help in some automation
i want to fill the cells with formulas down the rows and across columns. I will attack the workbook as example.
for example
my z column has and ab column, the only change is 2 and 4 in the formulas and i have to automate this
Code
z2 cell=IFERROR(VLOOKUP(A2,DATABASE!A:AO,2,FALSE),0)
z3 cell=IFERROR(VLOOKUP(A3,DATABASE!A:AO,2,FALSE),0)
the next column is ab (leaving 1 column after Z COLUMN)
ab2 cell=IFERROR(VLOOKUP(A2,DATABASE!A:AO,4,FALSE),0)
ab3 cell==IFERROR(VLOOKUP(A3,DATABASE!A:AO,4,FALSE),0)
next is column AA AND AC, so here again across columns we change 3 to 5 and down the rows we change from a2 to a3 and b2 to b3 and so on
Code
aa2 cell==IFERROR(VLOOKUP(A2,DATABASE!A:AO,3,FALSE),0)*B2
aa3 cell==IFERROR(VLOOKUP(A3,DATABASE!A:AO,3,FALSE),0)*B3
the next column is AC(LEAVING ONE COLUMN AFTER AA)
ac2 cell=IFERROR(VLOOKUP(A2,DATABASE!A:AO,5,FALSE),0)*B2
ac3 cell==IFERROR(VLOOKUP(A2,DATABASE!A:AO,5,FALSE),0)*B2
is thr any way to automate this across columns Z TO AE