Copy/Paste a column in a new sheet based on a criteria

Hi all!

I'm new at using VBA for Excel.
My problem is that I want to copy a column depending on its label by typing the name in an inputbox (that all are on line 1) and paste it in a new sheet (named as the label), and also add the 2 first columns of my initial sheet.
I get to create the sheet, and paste the first 2 column, but when I try to copy paste another column based on the criteria = the text of its 1st line, I can't find a solution...

Many thanks for your help!

Please Login or Register  to view this content.

Does anyone has an idea of how to solve this? Thanks!

Maybe?

Please Login or Register  to view this content.

It works perfectly! Thanks a lot!!

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