Add to Data Validation Values From Data Entry Cell

That would defeat the very purpose of data validation, which is to control the type of data you entered!

Originally Posted by josephteh

That would defeat the very purpose of data validation, which is to control the type of data you entered!

Typically, yes. That would very much be a ridiculous contradiction. The reason I am looking to do this, however - and my apologies for not saying so to begin with to better clarify the purpose - is for my own usage, and not for others for whom I am creating a sheet.

So to keep it short but informative, I am basically trying to take current "forms" being used by my job and make them more efficient and effective. As an example, one form I use is to log received payments from clients. On that form, there are collumns for their client # in our inventory/billing system, the name that appears on their checks, and their name as it appears in our system. Unfortunately, there is no way for me to export that info, and going through the client database and just copying them onto the form would waste a lot of time as there are many imactive accounts. The idea is to have those fields reference a table so that I could enter in just the client number and the other fields would auto-populate, saving time from having to always type in the other two fields.

Being that I don't have a quick and/or easy way of getting that info into a table, I need to manually enter that info each day as I get payments from clients until I finally have a working, current client list for the form to reference. I just figured, instead of having to jump back amd forth between the table and the form as I compile the client list, if I had the dropdown fields be able to add to the table from the field would save me from doing double work with each client.

Hopefully that clarifies why I'm looking for this solution.

Originally Posted by Mumps1

It would be easier to help if you could attach a copy of your file so we could see how your data is organized and test possible solutions. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

Ahh, sorry. I should have remembered to do this.

I added the file to the original post. Thank you!

Originally Posted by HSV

Code behind worksheet Summary.

Please Login or Register  to view this content.

That worked perfectly! Thank you!

One last thing - I am sorry for not clarifying it in my original post, but I'd also like to have the values in Columns C & D also copied over on the Values sheet to their respective columns, B&C.

I did try to dissect the code and see if I could figure out how to alter it msyelf...but my VBA is still developing, and I couldn't figure it out.

Originally Posted by HSV

Columns C:D contain formulas.

Does that mean they can't be copied? If a new value is entered in Column B on SUMMARY, then new values would also be added in both C & D, overwriting the formulas.

Originally Posted by bakerman2

I created a non foolproof (no personal intent ) solution but since you're the only person working with the file it might work.
On entering a new value in column B, C & D return zero meaning there's no extra info in CustInfo table.
After overwriting the formulas in C & D with the new values you need to select the cell in column E next to the new values.
The new values are added in CustInfo table next to the newly entered customer number and the formulas are restored in C & D column.
Test it and just let me know if you have any other questions.

Working like a charm! Thank you SO much!

Oh, and no offense taken. 😁