Adding rows in between varying group sizes

[GavAdams]

To set the scene:

I have 800 or so products, each with a unique identifier.
These products have associated notes on a system, each with a varying number of notes. These notes are managed on an Excel document.
Therefore, on a spreadsheet, I have groups of products. Some are in groups of 2, some in groups of 5, etc. They each then have a sequence number to notify their order in a list.

I need to add a new note in for every one of these products. The new note needs to go last in the sequence order, but because the products are all in different group sizes, I can’t add in the new note at regular intervals.

What is the best way to add a new row in for each unique product, with the same text column, but different sequence numbers based on the group sizes.

Quite a hard one to put into words, apologies.

Many thanks,
Gav

 

[mumps]

Could you post a screenshot of what your sheet looks like? In which column are the product names?

 

[GavAdams]

Could you post a screenshot of what your sheet looks like? In which column are the product names?

 

[hiker95]

GavAdams,

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.