VBA - Applying Autofill with inserted rows (based on input box) and apply it to other shee

Hello everyone!

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?

Please Login or Register  to view this content.

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)

Thanks for your help!

Note that I've tried on other forums but it seems I can't upload the links

Hi !

If you use an Excel table rather than just a range of cells the formulas are automaticly added when creating new rows …

Hi, thanks ! Yes indeed, but how to convert the initial row + the extra created rows into a table in a dynamic way in VBA. Besides, I would need to create as much tables as there are markers (5 in total), right?

Hello, thanks for the info, I'm aware now of this rule. I wanted to upload the links but it seems I can't because not enough posts yet on my side..