Need assistance on Macro

Hey there,

Attached is the sample file which has two sheets. Sheet 1 contains Raw data and Sheet 2 contains auditor names with the count. I need to allocate the data to particular auditors in such a way that whatever count we enter beside the auditor name that many times should copy and paste into the "auditor" column in sheet 1.
For instance, If I enter the number '5' for Pawan then Pawan should copy 5 times in the auditor's place and others accordingly.

Also, need one more button where I can filter the "assignement_week". For example, there will be many week numbers in that column. However, if I enter as 32 then it should delete all other week's data and should show week 32 data only.

Please review and assist me with this.
Waiting for your response.

Thanks in advance.Sample file.xlsx

Hi John,
Thanks for looking into the query. I guess there is some error showing for me..After running the macro by entering the count the first row (auditor name) was getting deleted from sheet 1. Can you please review and advise? However filter macro was working fine.
Thank You

Hey Sintek,
Yes, the above-mentioned code was working fine.
Thanks a lot for your help.

Hi,
There is one modification that should be done for the same query. While running the code the starting cell data was getting deleted. So can you please review and fix it for the same?

Hey Jhon,
This code was working cool now.
I guess because in the previous code it was mentioned as lr = .Cells(Rows.Count, "A").End(xlUp).Row which is why cleared the row. However, the updated code was working fine now.

Thank you so much for looking into it again.

Resolved the thread as the query has been resolved. Once again thanks a lot to both of you for resolving the query on such short notice. This really helped me a lot.

Welcome, John. I really appreciate the support you guys are giving which helping a lot of people out there. 😊

Hey HSV,
The issue was resolved. However, the above-mentioned code deletes the starting cell data (Auditor) in the "Raw data" sheet. thanks a lot for looking up the query.