SOLVED
Home

Automatic Excel population from another Excel sheet upon download of document from a website

%3CLINGO-SUB%20id%3D%22lingo-sub-353577%22%20slang%3D%22en-US%22%3EAutomatic%20Excel%20population%20from%20another%20Excel%20sheet%20upon%20download%20of%20document%20from%20a%20website%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353577%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%20-%20if%20you%20could%20help%20me%20it%20would%20be%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22inherit%22%3EI%26nbsp%3Bhave%26nbsp%3Ban%20Excel%20document%20which%2C%20in%20an%20ideal%20world%2C%20%3C%2FFONT%3E%3CFONT%20face%3D%22inherit%22%3EI%20would%20like%20people%20to%20be%20able%20to%20download%26nbsp%3B%3C%2FFONT%3Efrom%20my%20website%3CFONT%20face%3D%22inherit%22%3E.%20It%20contains%20template%20information%20about%20an%20order%2C%26nbsp%3B%3C%2FFONT%3Ebut%20with%20empty%20spaces%20in%20relation%20to%20three%20columns%3A%26nbsp%3B%3CSTRONG%3Eitem%2C%20price%20and%20deposit.%26nbsp%3B%3C%2FSTRONG%3EThe%20details%20for%20these%20three%20column%20is%20contained%20in%20a%20separate%20Excel%20document.%26nbsp%3B%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EIdeally%2C%20a%20client%20would%20go%20to%20an%20item%20on%20the%20site%20and%20download%20the%20template%20document%20from%20there%2C%20which%20would%20then%20automatically%20fill%20in%20the%20item%2C%20price%20and%20deposit.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EIs%20there%20a%20way%20to%20do%20this%3F%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThanks%20again%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-353577%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353616%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20Excel%20population%20from%20another%20Excel%20sheet%20upon%20download%20of%20document%20from%20a%20website%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353616%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F287138%22%20target%3D%22_blank%22%3E%40sally365%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHere's%20a%20video%20I%20created%20showing%20how%20to%20create%20an%20order%20form%20with%20drop-downs%20that%20I%20think%20will%20explain%20how%20to%20do%20exactly%20what%20you're%20requesting%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F8tMUIuUSnnc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2F8tMUIuUSnnc%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20this%20helps%20you%20accomplish%20what%20you%20need%20to%20do!%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353608%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20Excel%20population%20from%20another%20Excel%20sheet%20upon%20download%20of%20document%20from%20a%20website%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353608%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20a%20video%20I%20created%20showing%20how%20to%20create%20an%20order%20form%20with%20drop-downs%20that%20I%20think%20will%20explain%20how%20to%20do%20exactly%20what%20you're%20requesting%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F8tMUIuUSnnc%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2F8tMUIuUSnnc%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20this%20helps%20you%20accomplish%20what%20you%20need%20to%20do!%3C%2FP%3E%3C%2FLINGO-BODY%3E
igpr2
New Contributor

Hello everyone - if you could help me it would be much appreciated.

 

I have an Excel document which, in an ideal world, I would like people to be able to download from my website. It contains template information about an order, but with empty spaces in relation to three columns: item, price and deposit. The details for these three column is contained in a separate Excel document. 

 
Ideally, a client would go to an item on the site and download the template document from there, which would then automatically fill in the item, price and deposit.
 
Is there a way to do this? 
 
Thanks again
2 Replies
Solution

Here's a video I created showing how to create an order form with drop-downs that I think will explain how to do exactly what you're requesting: https://youtu.be/8tMUIuUSnnc

 

Hopefully this helps you accomplish what you need to do!

In this video, I'll show you how to easily create an order form in Microsoft Excel 2016 (similar in most versions). I'll show you how to create drop-down menus so users can select from options you set using cell range naming and data validation. I will also show you how to format cells so data ...
Highlighted

Thank you!


@sally365 wrote:

Here's a video I created showing how to create an order form with drop-downs that I think will explain how to do exactly what you're requesting: https://youtu.be/8tMUIuUSnnc

 

Hopefully this helps you accomplish what you need to do!


 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies