Searching Columns for a particular month then moving data from that column to User Form

Hi all,

I need some help. I have an excel spreadsheet where the columns have the 12 months of the year in Row 1. What I need is code that will find the month (from the column) which I select (via a listbox in a userform) and then go down that column and move the data that corresponds to that month to the userform.

So, If I select January from my userform, all data below January will then be moved to the userform and the same thing will occur with each month I select. I know how to move the data from the sheet to the userform, I just don't know how to match my data with the selected month.

If your Months start from Column "A" = "January", then this code will give you the related Month column from the list box Month Selected.

Please Login or Register  to view this content.

Regards Mick

Hi MickG,

Your code works but it does not do what I need.
What I have is the following:

Column "B" is January
Column "D" is February
Column "F" is March and so on...

What I need the code to do is to find the month I select using the listbox in the UserForm then move the item below the column where the month is to the UserForm.

Example:
If in my listbox I select March my code will search "Row 1" until it finds March, then it will go down that Column (the March column) and move the items in the March column (in this case numbers) to the proper location within the UserForm. If I select January the same thing will occur and so on. I hope I am clearer this time. Thanks for your help.

IF your Months columns start in Column "B" and are set in every other column then you can still use the Code by adding 2 to the end as below.
This will be your column "Number" relating to the Month selected.
This code will select that month and Copy the range below Row1 of that month to Listbox2.

Please Login or Register  to view this content.