kpasa
Board Regular
- Joined
- Nov 20, 2015
- Messages
- 82
I have a table that is acts functionally as a database. Each line is a customer/project and each column is a checkpoint in my workflow for the customer/project.
What i would like to do is have a second table of tasks or To-Dos and link the tables by the customer name. I would like to be able to look up the to-dos in a userform I already have active. I know I can create a relationship with tables in Excel, but i dont know how to functionally use them.
The end goal would be to use my existing UserForm which i use to view, edit, and log my customer/project progress and also display the list of to-dos found in the linked data table. An added bonus would be to have check boxes by them so i could also mark them as done, all from within the userform.
What i would like to do is have a second table of tasks or To-Dos and link the tables by the customer name. I would like to be able to look up the to-dos in a userform I already have active. I know I can create a relationship with tables in Excel, but i dont know how to functionally use them.
The end goal would be to use my existing UserForm which i use to view, edit, and log my customer/project progress and also display the list of to-dos found in the linked data table. An added bonus would be to have check boxes by them so i could also mark them as done, all from within the userform.
Last edited: