VBA Macros to copy row to a new sheet

[hecgroups]

Hello Again,

I am looking for VBA Macros where i can extract complete row uptill certain column and add a new sheet and past the row with header.

Details Below:-

I have a worksheet with column from A till BQ (Can be add or delete columns).

Check the unique values in column BL and create the names for that values and extract the data uptill blue color column i.e. From Column A till AU.

Sample file is attached for your reference.

[AB33]

Try the attached.

[hecgroups]

Thanks AB33 it is working i need 1 more thing. Let say i need to extract only 5-Target Not Match without input box function how should i do that. Your script is extracting all the unique values from column BL.

[AB33]

I am not sure I understand your request.
The code does extract values which are in column BL. The names of the tabs are created from these values. The code does not duplicate names, if a name tab exists, it copies its rows only. I have not used input box function. If you want to
"extract only 5-Target Not Match". The data for this tabs are on that tab and you can ignore all the other tabs, or I can add a line which deletes all sheet except 5-Target Not Match, but this defeats the purpose of writing the code in the first place.

[hecgroups]

No no i totally agree with you it is working perfect.

Topic marked as solved and reputation added.

[AB33]

hecgroups,
You are welcome and thank you very much for rep!