Having a bit of mare with the following, although it should be straightforward (ish) My macro, in which I've tried to do the following (Macro2), has turned out to be a complete disaster for some reason!!
Here was the idea:
1. Copy D2:H ("Data"), & paste one row under the last point in column I ("Sheet1") - Row 327.
2. Delete all the unique values under L1 (Sheet1) (I used conditional formatting, then filter - although there might be an easier way)
3. Move M327:P, into H2:K (the tricky bit is that M327 could vary after the previous step)
4. Then delete data that was pasted in step 1 (Sheet1) & remove the conditional formatting from column I.
There are probably easier/more efficient ways to perform each step.
Any questions please drop em below
Ty
Mdn
Bookmarks