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!

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies