Hi Debra, being a retired gentleman I have taken up learning Excel to keep my brain active and to have a purpose to get up in the mornings. So enjoy watching your very informative videos and using them to learn, at the same time designing useful projects. Thank You for you guidance, even at 70 I get excited when I see the results. Kind Regards Stewart Huddersfield UK 🇬🇧 😁👍
Thanks so much for this - really clear and concise. As someone who's taught themselves to use Excel on a strictly "as needed" basis, named ranges have come as a complete revelation to me!
Thank you so much for this!! Took me all day but I just used your tutorial to make my job easier!!! I have been writing out my material lists and estimating my jobs totals by hand for the last 4 years. You have no clue how happy I am right now
Hi Debra.. nice video lesson on making an Excel order form. You outlined some good tips and presented a logical structure and construction for a useful template. Thanks and thumbs up!
Hi, Debra. Thank you for posting this! I followed your steps and achieved the same results using Google Sheets; the only issue was I couldn't figure out how to utilize named ranges in the Data Validation dialog box, so instead for Data Validation Criteria I used: List from a range, Products!A2:A6 for ProductList and later used Customers!A2:A5 for CustList. However Google Sheets did make ProductLookup and CustLookup available when typing the formulas.
Thank you for the tutorial. This was very informational. I do have a question. When I create names of each order, how do I capture the save order so that when I pull the name up it captures what they chose from my dropdown?
You're welcome, and to store the order info, you could manually copy the customer names and items to a different sheet, or create a macro to do that. Then you'd need formulas to create a list of items for the selected customer name, and use that list for the drop down.
@@contextures Thank you for your quick reply. In the interim, i will do a manual copy customer's name. I would like to learn how to do this. Do you have any tutorials on creating macros?
@@rblack2k17 The "Record and Test a Macro" page on my site has a few videos that could help you get started: www.contextures.com/excel-macro-record-test.html
Hi Debra, Thanks for putting this together. I would like to see the orders stored separately in rows on a sheet. Also, I would like to see data for each item in order to segregate them for sales analysis. Any pointers?
Thanks, Lalit, and I don't have a video, but there's a page on my Contextures site that might help you. It shows how to enter rows of data, then click a button to store that data on a different sheet, and see summary of the stored data: www.contextures.com/excelcaloriecounter.html
Thanks, Jennifer, and you'd need to store the data for each invoice and its items. I don't have a sample for that, but something like my parts order example: www.contextures.com/exceldataentryupdateform.html -Debra
Fantastic! I want to also track inventory numbers in another worksheet inside the same Excel file, such that when I complete an order form, the inventory totals will automatically adjust. Have you added this demo?
Hi Debra, I followed each step as explained and when i tried to put another product on my order form the price does not show up. Can you please try to help me out? I do not understand what is going on.
Hi, thanks for the named range and using the table as the source for the drop-down. However, I have 1 issue with the drop-down not appearing in the auto extend row in the table. The formulas remain intact, but the cell with drop down list has its data validation missing.
Add another column, with a drop down list of colours. If colour choices depend on which product was selected, use a dependent drop down, similar to what I show in this video: ruclips.net/video/lGUkXviPyGE/видео.html
Hello ma'am, very useful video. But i have a question that if i want to save the entered details in other sheet and make the form blank, can it be done?
Hi good day please help me to have a excel operation system how can i create a orders same time a inventory to know the products are good please help me on this. Thanks
Hi Debra, Apologies for asking an offtopic.. It's been quite long time I have been searching for a solution but failed to do so. Do you know how to make a "Project Unviewable" module? Bcz I have developed an add-in I don't want someone to penetrate to my script. Could you please make a video. Bcz it will help lot of developer. I have seen an add-in where the developer has protected his project. I am just curious to know how it can be done?
Thanks, Susanta, and that's a great idea for a video topic! Here are some written instruction from the Microsoft site, that might help you until there's a video ready: answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-lock-my-vba-project/66c8eb3f-38b5-45d9-8b7a-66952790df37
@@contextures Thanks for quick response. Hope you understood my query. To remind you I am looking for "Project is unviewable" feature for xlam file. Please make a video on it.
@@susantakumar8330 If you make the workbook shared, then protect it, people will see that message. You could do that, and save a copy as xlam. Or use a product like Unviewable+ that will add the protection for you. Be sure to make a copy of the file, before doing this!
Hi Debra, do you have an example where you are adding more data to the from the product form like MSRP and Retail price both included with product description?
![[TF2] The Russian Bear Trap](http://i.ytimg.com/vi/YFNSwz2_rOA/mqdefault.jpg)
Hi Debra, being a retired gentleman I have taken up learning Excel to keep my brain active and to have a purpose to get up in the mornings. So enjoy watching your very informative videos and using them to learn, at the same time designing useful projects. Thank You for you guidance, even at 70 I get excited when I see the results. Kind Regards Stewart Huddersfield UK 🇬🇧 😁👍
You're welcome, Stewart, and you for your lovely comment! Glad to hear that you still love Excel projects.
Thanks so much for this - really clear and concise. As someone who's taught themselves to use Excel on a strictly "as needed" basis, named ranges have come as a complete revelation to me!
Thank you so much for this!! Took me all day but I just used your tutorial to make my job easier!!! I have been writing out my material lists and estimating my jobs totals by hand for the last 4 years. You have no clue how happy I am right now
You're welcome, Cassie, and thanks for your lovely comment! It's great to hear that you stop doing these estimates by hand now!
Brilliant! Thank you so much
You're welcome, Emilia, and thanks for your comment - I appreciate it!
Hi Debra, Love your confidence and how simple you explain this. Thank you for sharing your knowledge.
Fenómena!
Thank you!
so helpful! thank you so so much!
You're welcome, and thanks for letting me know that the video was helpful to you!
This was perfect. Thank you!
You're welcome, and thank you for your comment!
Nice tutorial 👍
Thank You!
You're welcome!
Thanks for this, I adapted this heavily for stock taking. Couldn't have done it without this tutorial though :) :) :)
Thanks, Mike!
Good Morning, Debra
Thanks for the your efforts, helps alot. Your explanation is excellent.
You're welcome, Feroz, and thank you for letting me know that the video helped you!
thnk u somuch you solved my big probolm
Hi Debra.. nice video lesson on making an Excel order form. You outlined some good tips and presented a logical structure and construction for a useful template. Thanks and thumbs up!
Thank you, Wayne! I'm glad you liked the order form template
Hi, Debra. Thank you for posting this! I followed your steps and achieved the same results using Google Sheets; the only issue was I couldn't figure out how to utilize named ranges in the Data Validation dialog box, so instead for Data Validation Criteria I used: List from a range, Products!A2:A6 for ProductList and later used Customers!A2:A5 for CustList. However Google Sheets did make ProductLookup and CustLookup available when typing the formulas.
Thank, Christian, and it's great to hear that you were able to get this working in Google Sheets too, with only a minor change to the setup.
Thank you for the tutorial. This was very informational. I do have a question. When I create names of each order, how do I capture the save order so that when I pull the name up it captures what they chose from my dropdown?
You're welcome, and to store the order info, you could manually copy the customer names and items to a different sheet, or create a macro to do that. Then you'd need formulas to create a list of items for the selected customer name, and use that list for the drop down.
@@contextures Thank you for your quick reply. In the interim, i will do a manual copy customer's name. I would like to learn how to do this. Do you have any tutorials on creating macros?
@@rblack2k17 The "Record and Test a Macro" page on my site has a few videos that could help you get started:
www.contextures.com/excel-macro-record-test.html
Hi Debra,
Thanks for putting this together.
I would like to see the orders stored separately in rows on a sheet.
Also, I would like to see data for each item in order to segregate them for sales analysis.
Any pointers?
Thanks, Lalit, and I don't have a video, but there's a page on my Contextures site that might help you. It shows how to enter rows of data, then click a button to store that data on a different sheet, and see summary of the stored data: www.contextures.com/excelcaloriecounter.html
So helpful!!
Hi Debra, thank you for your clear explanation. I want to know how to retrieve the orders into the same worksheet?!
Thanks, Jennifer, and you'd need to store the data for each invoice and its items. I don't have a sample for that, but something like my parts order example: www.contextures.com/exceldataentryupdateform.html
-Debra
Fantastic! I want to also track inventory numbers in another worksheet inside the same Excel file, such that when I complete an order form, the inventory totals will automatically adjust. Have you added this demo?
Thanks, Gina, and I don't have any videos on that topic.
thank so much ....respected sister......
Hi Debra, I followed each step as explained and when i tried to put another product on my order form the price does not show up. Can you please try to help me out? I do not understand what is going on.
This is like programming. And I failed that subject. Btw thank you for the tutorial
Oh no! Sorry to bring back bad memories for you!
Very Nice Excellent
Can you show how the order form can generate an order number?
Thanks for your question, but I don't have a video that shows how to do that
Hi, thanks for the named range and using the table as the source for the drop-down. However, I have 1 issue with the drop-down not appearing in the auto extend row in the table.
The formulas remain intact, but the cell with drop down list has its data validation missing.
Thanks, and is there a drop down in every row of the table? If it's been accidentally removed in some cells, that might cause the problem.
Congratulations!
How would you go about adding colour options to the products?
Add another column, with a drop down list of colours. If colour choices depend on which product was selected, use a dependent drop down, similar to what I show in this video:
ruclips.net/video/lGUkXviPyGE/видео.html
Hello ma'am, very useful video. But i have a question that if i want to save the entered details in other sheet and make the form blank, can it be done?
Hello. I was wondering how I could protect the formulas? Do you have a video with that topic? Thank you.
HI Debra- is it the same when you do it on google sheet?
Thanks for asking, Lilyrose, and I've never tried this in Google Sheets.
Do you have an excel video showing how to create inventory tracker sheet
Thanks for asking, Laura, but I don't have any videos on that topic
How can this excel order form be an interactive pdf? Thanks
make vedio
how to excel data convert to andriod app without coding
on appsheet
hi dear good job but i want my all entries save in an other workbook please tell me as soon as possible dear i am waiting please
Hi good day please help me to have a excel operation system how can i create a orders same time a inventory to know the products are good please help me on this. Thanks
Does anyone know how to insert the product list as data validation source on a mac? F3 does not do the job
Type an equal sign, then the product list name
I am struggling with the vlookup
Hi, what if I want to add another order form? Can I join it with the first form or I have to create another sheet?
Try my multi-item order form sample file instead. It's in the download section here: www.contextures.com/xlForm03.html
I followed all the steps, but when I put the =IF(B10="","",1) it says that the formula contains errors.... Can someone help please?
Try this =IF(B10="";"";1)
Hi Debra,
Apologies for asking an offtopic..
It's been quite long time I have been searching for a solution but failed to do so.
Do you know how to make a "Project Unviewable" module? Bcz I have developed an add-in I don't want someone to penetrate to my script. Could you please make a video. Bcz it will help lot of developer.
I have seen an add-in where the developer has protected his project. I am just curious to know how it can be done?
Thanks, Susanta, and that's a great idea for a video topic! Here are some written instruction from the Microsoft site, that might help you until there's a video ready: answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-lock-my-vba-project/66c8eb3f-38b5-45d9-8b7a-66952790df37
@@contextures Thanks for quick response.
Hope you understood my query. To remind you I am looking for "Project is unviewable" feature for xlam file. Please make a video on it.
@@susantakumar8330 If you make the workbook shared, then protect it, people will see that message. You could do that, and save a copy as xlam. Or use a product like Unviewable+ that will add the protection for you. Be sure to make a copy of the file, before doing this!
They sat. Tricounty does not have program even explain
Chinese put my child back, you and.
My head hurts. No formulas
Hi Debra, do you have an example where you are adding more data to the from the product form like MSRP and Retail price both included with product description?
nevermind, got it figured out. thanks for this information its great!
You're welcome, Michael, and thanks for letting me know that you figured it out.