Hi guys,

I have a headache and I hope you guys can help me out.

I have 2 group of people.

Group 1 is the one that will update the mastersheet excel by adding the client#, items name and donation up to 100.

Group 2 will use the userform to retrieve the information from this mastersheet. By entering the client# only, the items and donation amount from the mastersheet will show up in the listbox.

However, the Group 1 can go in the mastersheet and update the items and donation amount, or even add new client.

My request will be how can I organise a easy way for the Group 1 to add or modify the items without having to manipulate too much with excel because of the risk that they mite delete some others client info.

Here is the attach file of the idea. I really dont know where to start exactly. My main problem is how to have a master sheet to keep data (2 column absolutely!!)
ITEM | DONATION
ITEM | DONATION
ITEM | DONATION

PLease help anyone!! Thank you very much.

Master.xlsm