Inserting new rows in sheet B, based on values in cells in sheet A within the same workbook?

[titanium_hwite]

Hey there,

I've tried searching for this question before and have found several answers if the new rows are in the same sheet, but I'm needing to create rows in a separate sheet. My experience with excel is quite limited, and I'd say severely limited when it comes to VBA!

In sheet A, I have several columns (A to M) that I can fill in based on the information of an item and some of these items have multiple sub-items. In column N I can select "Yes; No" depending on if there are any sub-items and with column O I can define the number of sub-items.

Data from sheet A columns A to C are automatically copied over to sheet B, and with sheet B I'd like to go into more granular details with the sub-items if they're selected. To do this, I'd need to enter new rows below that main item.

For example, if I enter "3" in sheet A, column O, then I'd need 3 rows to be entered below the main item in sheet B.

I hope this makes sense, if so, would this be at all possible in excel? Any help would be greatly appreciated!

Many thanks