Hi! PLEASE help! I've been stuck on this for days...

I have a listbox with several values in them. The listbox gets those values from row1 of my sheet. When I click a button, I need for the code to loop through the listbox, and search for each value in Sheet1 (which will always be in Row1), and I need it to select the entire column where that value is located.

For example, I have values a, b, and c in the listbox. Upon clicking a button, I need for it to go search Sheet1, find where values a, b, and c are located in Row1 of Sheet1, and I need it to select the entire column and copy that column.


All help is extremely appreciated.