Need help in copy and pasting multiple lines based on a criteria

[xlbaby]

Hi all,


I need an urgent help on a macro. I have very minimal experience with Macro and is struggling to get this done.

I have a spreadsheet that has close 22K rows with a lot of data. The data is spread across various columns. The cell A1 is the unique id which repeats in various rows.

Criteria Tab: The criteria using which the output needs to be generated. Unique ID (with duplicates removed)
Data tab: The tab where the data is available. The columns where the data is available is on the top row
Output tab: How I want the output to be.

What I need is an output where all the same unique id details are copied and pasted in an order sorted A-Z based on the unique id. The unique id (after removing duplicates) will be in a separate tab within the sheet.

I will have multiple tabs with the data I need to copy. The spreadsheet that I have attached has all the details.

I hope I have explained it properly. If not, I am ready to give additional details.

Thank you so much for your help.

[WideBoyDixon]

This might work but you might need to remove that rogue first row in the Data sheet:

Please Login or Register  to view this content.

WBD

[xlbaby]

WBD , Thank you for this macro. This worked like a charm.

One quick question. Should the macro be changed drastically if I need to copy only certain columns? If yes, then this is fine.

Thank you again for your help on this.

[WideBoyDixon]

Not "too" drastic I would say - it depends which columns you want to keep and which ones you want to remove?

WBD

[jindon]

xlbaby,

Use of AdvancedFilter.

Just copy the headings that you want to copy from Data to Output like attached.

Please Login or Register  to view this content.