Help with Moving Data Between Worksheets Using a Userform


New Member
Aug 21, 2013
Thank you for taking the time to read through this! I appreciate any and all help!

The Goal

I am trying to create an Excel program that can help me generate grocery lists and meal plans (simple enough, right?). I currently have a userform that allows me to search a master list of ingredients/grocery items and I need that user form to add each selected grocery item to a grocery list.

The Current State

I have the master list created and the userform does about 75% of what I want it to do. Currently, the userform cannot search for grocery items AND place the selected items into a grocery list.

The Problems

- I have a limited understanding of the VBA I'm using (most of it I have pieced together from other solutions found online, but that has only gotten me so far).
- I need the user form to be able to perform a live search of the master list, select items, and place those items in another worksheet (this would be the grocery list).

I can email you my workbook so that you can get a better understanding of what I'm doing.

Last edited:

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.


Board Regular
Nov 10, 2017
Lets say Column A hosts your 'Meal' and Column B hosts your 'List', you could generate a routine that FINDS the 'MEAL' and for each instance copies the contents of 'LIST' into a generic blank workbook file. This will utilize a few different strategies depending on how you built both. Blank rows in-between each 'LIST' grouping could help by performing the copy function until it finds an empty cell. You will be able to utilize the same code over and over until your done selecting items. Then you could do something for counting items in your grocery list in another column to condence the list and get the appropriate quantity of supplies. If you need code strategy pm me and we can swap files to find a solution.

Watch MrExcel Video

Forum statistics

Latest member