|Sorry, perhaps I didn't make myself clear.|
This is for my shop's product database. The worksheet that I want this function to apply to is filled with functions which feed the information through from another - main - worksheet in the book. In the main worksheet, my products have one row per product, with all the information being transferred by formulas into the subsidiary worksheet. However, on the subsidiary sheet, I need to have three rows for each product. Therefore, I need the macro, if possible, to add in the two extra blank rows beneath each data filled row on the subsidiary sheet.
The upshot would be that as I enter a new product on the main sheet, it would appear on the subsidiary sheet with two additonal rows beneath it. I hope this makes things clearer.