VBA Help Copy, Sort, Report

[8mycsh]

Hi there, I am new to VBA and have taken on more then I can chew with this assignment. I am hoping that someone in the community can help me with this. I know my way around excel but not vba.

What my setup looks like. I have 3 sheets in the workbook. Sheet 1 has all the data Column A-H. The second sheet has columns A-J labeled "job descriptions 1-9" in different columns. I am looking to search sheet 1 and organize the job descriptions in to columns on sheet2 as these columns will be used for a drop down on a different sheet. On sheet 3 is a report of everyone that is on days off from Sheet 1 Column H. The data will be constantly changing on Sheet 1 so sheet 2 and 3 need to be able to update the lists when the macro is run.

Thanks for the help.

 

[KennyGreens]

Maybe I am misunderstanding, but what is the sorting criteria for what is on sheet 1? What are you looking for on sheet 1 to specify which column on sheet 2 it belongs in? I'm also not really sure what sheet 3 is being used for or how a macro is necessary for that.

 

[8mycsh]

Maybe this can help explain it a little better.

https://drive.google.com/file/d/1xHfol8nq6tJhw4GWlAJYnprnt0N6NNAC/view?usp=sharing