How to assign an ID to a batch of copied data

This is easy enough to do, but far easier if we could see an example workbook. Any chance you could attach a desensitised version for us to work with?

With a sample workbook we could also see how you're copying and pasting the subsequent batches and more than likely tidy your code up a little for you.

BSB

Thanking you!

I should give more context with the file, i essentially have a lot of data which is aggregated based on Packed Data column O.. essentially need to create a new Unpacked tab where it's separated out by rep. so Rep 1 appears in 4311 rows copy that into the Unpack sheet and same with Rep 2 and Rep 3 etc

My code is essentially filtering value 1 on columns P, Q & R respectively and just copying...but then i need an additional identifier in order to signify that this row is relating to Rep 1, 2 or 3 in particular....just for reference in the real data set there are 20 reps with way less rows but this is just the desensitised version i could come up with...happy to assist on further details

So, for clarification, the data is filtered based on column O to anything that contains "Rep 1", those rows are copied to the other sheet and a 1 is added to the last column. Then the same for Rep 2 and Rep 3 etc., even if those rows already exist on the other sheet?

BSB

Also, does your real data actually say Rep 1, Rep 2 etc., or does it have actual rep names?

BSB

Depending on your answers to my questions above, the below code could work for you.

Please Login or Register  to view this content.

BSB

I'm afraid I get the below error?


Attachment 843886