I am trying to auto populate a "shipping ticket" based off of a checklist on a seprate sheet that has a list of all possible items that one person may need. for example on one sheet there will be a list of 25 items that can be picked, so a person will only check or select what is needed, so say they only need 5 things from the list. How do I make those 5 things that are "checked" or "selected" appear on a seperate sheet in sequential order? attached is an example of the shipping ticket where I want things to autopopulate to based off what is selected
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How make selected items in a checklist auto populate in another sheet
0
Answers
0
It should be possible to do what you want using worksheet functions and filters. It will be a complicated process and the user must have detailed step-by-step instructions. Therefore the better way would be using VBA.
The best way to solve the problem with VBA would be to put the list in a ListBox. The user clicks on the items he wants and the selected items get transferred when the ListBox is closed.
In Excel 2007 and up you could have a ListBox on the sheet itself. Since your sample workbook is in Excel 2003 you would need to create a user form which contains the ListBox. The user form would open when a button on the sheet is pressed and closes when a button on the firm is clicked. The transfer takes place at that moment.
If you write a little code starting to implement the idea you can find help here if you get stuck.
0
Another way you go at this is using data validation. Add a sheet listing the 25 possible items that can be picked. Using data validation in the description cells of the shipping ticket will limit the choices to only those available and will ensure the description is accurate and consistant. The attached file demonstrates what I am describing.
Cheers ;-}