Use Excel's Data Form to add records, edit, delete and search by criteria by Chris Menard

[@chanchalsharma866]

Sir, no words to say for you.............. hats off

[@ChrisMenardTraining]

Thank you.

[@dwight6651]

Thank you .... Ive been tasked at work to come up with a spreadsheet that will receive hundreds of new data entries per day. This technique you've demonstrated will work for me..... Thank you again ... from someone who is little more than excel newbie.

[@ChrisMenardTraining]

Glad it helped!

[@deepikaraj9894]

I am searching where is this form button in last minute of my excel exam....Then I found your Video....Very helpful Sir❤Thank You🙏🏻

[@scienceclasssinhala654]

Thank you your valuable ideas.

[@ChrisMenardTraining]

You are most welcome

[@stanTrX]

Thanks. Does it also allow combox in that form?

[@cecilhudgins6569]

Excellent, just what I was looking for!

[@ChrisMenardTraining]

Thank you.

[@danyos777]

Great! Thank you! QUESTION: How can I export to a new tab the list of items found based on searched criteria? Thanks for sharing your knowledge.

[@javieresquivel9100]

thank you sir....i wonder if you can teach me how to have a new number automatically when you click new on the form????

[@hH-qp9kx]

32 columns. Thank you

[@its_ankit3219]

Sir Balance ki column me plus hoga ya minus hoga please reply

[@faithdeyto9860]

Can this be used via shared file in ms outlook?

[@adolfoysulan7512]

I wonder how to change form control from text to combobox.

[@johnchristopherlacaba6387]

Can this form holds huge data with more than a hundreds columns?

[@andyneal3317]

you have the same issue in the search you put google adds & said 2 BUT i know you corrected this WHAT you got was location 2 the the next said the next location. the problem is number 2 is Facebook number 3 location is google so my problem is i have 1000 names i type in the name or part of name 1 it does not hight light on the list the name & if i go next next then find the name i want the number at the top says example 778. so close form look at 778 its not the right name its 779. that's my problem. It seems to be using the header as number 1 not the first input. It knows i have a header in the list so why is it counting. Can you help.

[@Sucre318]

What do you do when you get an error message “this value doesn’t match the data validation restrictions defined for this cell”

[@clayvlogg605]

Exact information ...... thanks

[@ChrisMenardTraining]

Happy to help

[@roomibudhwani8818]

U r awesome

[@ChrisMenardTraining]

Thank you.

[@Fireflies817]

Sadly, I don't think this is available for Mac users. :(

[@jcruz6888]

This is useful but not what I came for What if I want to add multiple records at once from another table that has the same headers? Do I just copy paste?

[@gailchesler]

I wonder if I can EDIT existing records using the data form? I see that I can FIND them by criteria; can I then EDIT other cells in that record?

[@ChrisMenardTraining]

Yes, you can add, find, and edit records with the data form.

[@ghsskattampoondi858]

need code