VBA Macro to copy rows that meet certain criteria

Hi everyone,

I am having some trouble coming up with a Macro that works for what I am trying to do. I have attached a sample of my workbook to this thread.

I am trying to write a macro that looks at the "Agent ID" and "QA Counts" from the "Pivot" worksheet, goes into the "Raw Data' worksheet and searches in the "Last User" column for that Agent ID and copies the specified number of rows from "QA Count" and pastes them into the "Orders" worksheet. It does not have to paste them in any specific order. Whenever I try to combine my individual macros into one macro it keeps giving me Run-time errors. I would like to start off with a fresh group of Macros.

Randomizer Test.xlsm

Thank you in advance for your help.

Todd Rossi

Maybe:

Please Login or Register  to view this content.

Thank you so much for your help! It worked like a charm!

You're welcome. Glad to help out and thanks for the feedback.

I have a follow-up question: If I wanted to make it so that I get a better blend of data from the various regions. Would I be able to edit that into the macro? I am looking for about 20% by region as well as meeting the counts by agent.

Not sure I understand the question. However, if you can clarify, I'd have too address it tomorrow. Gone for today.

Did that make sense? I feel like I am not explaining it correctly

Are you wanting a calculation on your Pivot Sheet as you've shown manually?

I was looking for the actual order's that are put into the "Orders" worksheet to be the count by agent and also make sure that they add up to the QA counts by region that are at the bottom of the "Pivots" worksheet.

I hope I explained that better than before.