I have a macro that adds news rows based on a input userbox and I'd like to use the autofill to keep the formulas and also same layout if possible.
Example: I want to add 4 extra products in sheet1. Now, the macro (my button) creates 4 new rows below row #24 (Product1), row #28, and row #32. I want to apply the original formulas in columns O, AB, AO, BB and BO to the new inserted rows. How can I adapt the following code?
Besides, I want to do the exact same thing on sheet2, but in which values of cells are the same as sheet1 (as already set)
Please Login or Register to view this content.
Thanks for your help!
Note that I've tried on other forums but it seems I can't upload the links