Macro that fills entire table row based on first row value and another cell

[Zexze]

Hi all

Whoever solves me this, saves my life:D

I think it's a simple macro, but i just can't find the right way to do it.
All i got is a simple macro that fills the row, but since the table is supposed to have 365 columns, i need something that loops or so. (I hate the fact that my background isn't programming, for i think i would do this in a sec).

I want to make a table row fill with "P" depending on the first row value and the cell above the table.
(easier when looking at the example)

help macro.png

I'll attach the file aswell

Thank you!

[dflak]

You do not need a macro to do this. A formula will work. In Cell J13 enter: =IF(VALUE(RIGHT(J$11,1))=$I13,"P",""). You can then copy this formula to all the cells in your table.

[Zexze]

Thank you for the help!

Thats somewhat the solution i currently have.
Problem is, i got 365*150 cells with the formula, making it kinda heavy and sometimes excel crashes

my bad here, i didnt upload the file i have with the formula i have - will do.
as a last resort, maybe my formula can be smaller, making the file lighter.

Thanks again!

[dflak]

I've extended the table to 365*500 rows and it's still responsive.

If anything, a macro would probably be slower.