Project to take an input of data and from user input, create sheet with relevant data

[GibbysThirdChin]

Okay, I am pretty new to VBA coding in excel so I will do my best to explain but I am inexperienced.

So, there is a massive report that contains information such as worksite, ID#, name, etc. This data is then manually entered into manually created "sign-in" sheets where they are then printed off to be used by clients. Obviously this takes an insane amount of time and I want to make it a little more automated.

My idea was to have the roster (big sheet with all the data) be copied into this macro workbook then, depending on what the user selects from a dropdown of locations, take the entered location, search the roster and create a sign-in sheet from a premade template that includes all of the lines that share the same location as what is selected by the user.

For explanation purposes I have had to simplify my issue but hopefully with the provided attachments I can make clear what I want to have happen.

So say in Sheet 1 there is a dropdown for users to select from "KS", "OK", "AZ" and "NY" I want, from that selection. A program to detect what selection was made, go through the roster looking for that location, find all lines containing that location and pasting them into a copy of a template for a sign-in sheet.

VBA Help Book.xlsx

Please let me know if I need to provide further information

[jolivanes]

Have a look at the yellow banners above. This one, "HOW TO ATTACH YOUR SAMPLE WORKBOOK", will show you how to attach a workbook.

Not everybody wants to download from the net so a concise explanation, without information who is going for coffee at what time, is usually a better idea.