I am new here and I am not really new to Code but it takes me longer than normal to understand it as it takes that special teacher to explain it for me to understand it totally. So the question is this I know it can be done I just for the life of me cannot find it online to understand it. So here we go.....
I have a workbook with 4 -5 tables on one sheet called FoodList( with tables for Protein, Carbs, Fats, Fiber, Specialty) might add more later... But anyway on the Main sheet (Meal Plan) I want add some command buttons to open these tables from the FoodList sheet in order to input new foods into the tables when called on. So I would like to add a button for each table for inputting the new food. I know this is possible. Excel is amazing and it does what ever you need you just need to understand it more.
I have also added some dropdown boxes to the selections using the Vlookup function which works great I am just a little lost on the buttons.
Do I need to make forms for each table?
Is there a way to just call up the built in form for that table on a different sheet?
I have attached a copy of the workbook I am dealing with so you can see and understand more what I am wanting to do. Now I have not added the buttons as of yet to the Main Sheet. (This is the one I use for Practicing before I get it figured out to move to the good one) LOL...
Thanks in advance!!!