Hi everyone

My first thread

I want to copy dynamic cells from one sheet (let's call it "Master") to multiple sheets, based on certain requirements. There are many steps, but I think it's easier if I take it one step at a time

In Master, there's a column with names. The same name might appear several times, but it is ordered (fx George in 5 rows, then Jane in 11 rows etc.). The new sheets that are created are named according to the name column, but there's only one new sheet for a unique name (even if there are 5 Georges, only one sheet named George is created etc.). Also, in A1 for every new sheet is the same name.

How to do this?

Any help will be appreaciated.

Regards,

Saud