After tedious and numerous excel video search, finally found this! this is exactly what I'm looking for. The right key word is Auto-populate! Thank You Sharon for this video. Very helpful!
This was EXACTLY what I was looking for. Very well explained and easy to follow. I'm using it to make a macro counter and calculator for a keto diet based on a spreadsheet of foods I've made. It worked perfect!!!
THANK YOU THANK YOU THANK YOU!!! I have been fighting with this all morning trying to make this work and you solved my issues in 5 mins. You are a saint!
omg a few hours later I finally found what I was looking for, THANK You so much you just helped me simplify my recipe building process w cost inputs your the best!!😬😬😬
Excellent video. Clear, and very well presented. There are others I've watched on the same subject where the channel creators hum and ha, are constantly clicking for no apparent reason and I'm left feeling irritated and confused. Not so with this demonstration. So, many thanks for the video. It's much appreciated. 👍👍
Thank you so much for the great feedback! I'm so glad to hear you found my video helpful. I appreciate you taking time to leave a nice comment. Thanks for watching!
OMG, I have been searching for the solution to a problem just like this for well over an hour, Thank you for posting this video! As always, its hard to find a solution when you don't know how to describe your problem in the vernacular of the software.
Oh, I'm so glad you found this video and that it helped you solve your problem! That is my goal. Thanks for taking time to leave a nice comment, I appreciate it. Thanks for watching my videos!
I looked at about 7 different videos on this topic and none made sense. This one was perfect and easy to follow. The main different, the rest were all taught by men. LOL! Lesson learned. Thank you!!
Perfect, exactly what i need for my quote form and my gantt chart. thank you for sharing your knowledge Sharon. if you need to know anything about renovations just ask me. thank you again.
Awesome . Thank you so much for ur Great and useful Videos 🙏 honestly I did not have the opportunity to to go to school or learn things in my childhood and now I'm a refugee and waiting for resttlement and I'm trying to learn Microsoft office and Excel for my Future I hope someday I can have a job as an Excle expert.😊
You are very welcome, Musa! I'm so glad you are learning from my videos. My goal is to share knowledge so people can improve their skills. You can do anything you set your mind to! Best of luck! Thanks for watching!
Gave me an idea on how to make a school card system that generates various grades depending on the name of students and their corresponding year, all thru excel only... So for this, Thank you very much.
Is there a way to do this but instead of a dropdown list but with checkbox list; they check a few boxes and it auto-populates a paragraph with 3 sentences based off those 3 lines of text that they checked next to?
This is fantastic. Thanks. I have a started a quote sheet by following this process. Now I have a cell that needs to say If this, then 0 and if that, then doe a vlookup. When I try this, I get a correcting saying I am putting too much in the cel.
Oh, thank you so much for the Super Thanks!! I really appreciate your support! I'm so glad you found my videos helpful. Your donation goes directly into creating more videos like this for my Channel. You have made my day! Thank you and I wish you the best!
Great presentation. I was getting real frustrated because my formula wasn't working. Had to find additional resources that told me the "source" needs to be pulled from the leftmost column (or first column) in a table. The
that is exactly what i was looking for! thank you so much ! the video was perfect , very easy to understand and also so short! saving time and learning new things i never heard of you but i instantly subscribed and liked your video
Its so easy to understand, thaks. How put formula to auto fill wholesale, retail and mrp in different Calum after select a product from dropdown. Please help
You've made my day. Thanks for the excellent tutorial. Question though... How can I... if need be... overwrite the cells containing the drop down list with regular text?
I have my first dropdown with 2 selections: Standard Glass and Tempered glass. I have another dropdown where the user can select the width of the glass. My problem: the second dropdown values need to change depending on what kind of glass was selected in the first dropdown. Please provide the solution
I have now added the client detail to auto fill in quote. How can i auto fill products and cost per client in quote as all clients have different costs on products
Hello Ali - here is a video you may find helpful that shows a way you can have text or images appear based on a drop-down selection in Word: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UEHeTuv5tG0.html Thanks for watching!
it was so helpful, thank you, I used in a tab I named payroll getting the data from another tab tha I named data it worked perfect!, now I'm stock trhying to get the total hrs from another tab I named week containing all people in the company some worked some didn't, is there a formula that let me get the total hrs only from people who worked? Thank you in advance for your reply Sharon kind regards
Ive made a macro to copy the customer details on an invoice form to a customer list (New_Customer) however the efficiency of this is only usefull if we can populate the main cell still from a list. I'd love it if you have a work around for getting autocomplete (Normally on same column data) on the customer name cell, to come from the customer list, but still allow the new entry so new customers can be added still with the macro. All I can think of is hiding another copy of the customer name list in the colum below the invoice form so autocomplete works
Thanks ma'am for your great video 🙏❤️ I just have a query...can this autopopulation be really automatic so that just by entering the Client name or code no. the address n phone no.etc. is automatically copied from the assigned cell/s by linking those cells to the name cell 🙏 please let me know as I am trying to analyse my Bank statement each row to Account n then automatically generate the Group Head like INCOME, EXPENSES,ASSET, LIABILITY,etc. 🙏😭
Thank you for making this tutorial video, I am struggling with how to deal with same name people in the drop down list? Excel automatically combines all duplicate values in a drop down list. I have tried using a number in front of a name to make it unique, the drop down does show as unique entries but then the vlookup function is hard to implement. Still stuck and haven't found a solution. :((
Is there a drawback to turning a datasheet/database into a table since I would line to get be able to pull customers by their phone numbers as I create new invoices? Is there a limit to a table versus a nun table database? Hope make question makes sense..