Macro to find a value and insert blank space after it

[deweyirl]

Hi all,

I have a load of data. This data for a many many months and many many different items numbers. The item numbers do not appear the same amount of time, each time. Some appear only once while others might appear 20 times. I have the data ordered to the item numbers are all from smallest to largest. What I would like to do is use a macro to paste the item number, find the last time item 1 shows, insert a blank line after it and then group the items and them repeat the process for the rest of the items.

I am wondering is this possible to do?

Thank you in advance,

Stephen

[Olly]

Why not just sort?

You could make it more complex, with something like:

Please Login or Register  to view this content.

But I reckon, if I've understood your requirement, that simply sorting would do the job.

[deweyirl]

I have attached a copy of an example.

the first sheet shows what I have while the second sheet shows what I want.

[Olly]

This does exactly what you want - transforms Sheet1 into the structure shown in Sheet2:

Please Login or Register  to view this content.