av89
07-02-2012, 02:46 PM
Hello all,
I have a question regarding some commandbuttons and userforms. I have a list of clients in Col A and Col B,C,D all contain relevant data to the client. I want to set up three different command buttons on my master spreadsheet (Add new client, Edit existing client, delete client). I have 10 other sheets that this information should flow into. My add new client button works as it should except for the fact that I can't get the inserted client to flow into the other 10 sheets. Some help doing that would be great. I should mention that Col E through L on the master spread pulls in numbers from the other sheets that contain formulas. I would like the formulas to be included when the new client is added. My userform is set up as a textbox for client name, combobox for col b, combobox for col c, textbox for col d.
As for my edit and delete client buttons. I have very little idea as to how to approach these problems. My userform has not changed except for the textbox for client name has changed to a combobox in order to select which client to edit. I would also like this information to flow through the rest of the workbook. The information for col b,c,d inputted into the userform should override previous cell data.
I have attached a dummy file for better understanding.
Thanks for the help.
I have a question regarding some commandbuttons and userforms. I have a list of clients in Col A and Col B,C,D all contain relevant data to the client. I want to set up three different command buttons on my master spreadsheet (Add new client, Edit existing client, delete client). I have 10 other sheets that this information should flow into. My add new client button works as it should except for the fact that I can't get the inserted client to flow into the other 10 sheets. Some help doing that would be great. I should mention that Col E through L on the master spread pulls in numbers from the other sheets that contain formulas. I would like the formulas to be included when the new client is added. My userform is set up as a textbox for client name, combobox for col b, combobox for col c, textbox for col d.
As for my edit and delete client buttons. I have very little idea as to how to approach these problems. My userform has not changed except for the textbox for client name has changed to a combobox in order to select which client to edit. I would also like this information to flow through the rest of the workbook. The information for col b,c,d inputted into the userform should override previous cell data.
I have attached a dummy file for better understanding.
Thanks for the help.