Hi
Could anyone please help me to update my existing VBA code so that the row with the new product gets formatted in the same way as row above and all the formulas are copied too.
I thought because I have my price lists data converted into a table it should automatically do that for me anyway, but it does not seem to be the case.
Please see my file attached, if you run a macro to add Product 11 to each price list - you should see what I mean
Thanks,
Jurate