Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Auto Filling Word Tables Using Excel Data
I am creating a template in Word for business proposals. It includes a table
detailing the following components: Service, Description, Units, Unit Price, and Price. I want to be able to select the service in the first column using AutoFill or a drop-down menu, and then have the rest of the data related to that service imported from an Excel spreadsheet. Consequently, the table needs to be able to insert an additional line after each entry, and then total the pricing information in the last column. Is this as impossible as it seems? I have scoured the Internet for hours and cannot seem to find an answer to this that isn't chock full of programmer jargon. A relatively easy to follow answer would be greatly appreciated! |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Auto Filling Word Tables Using Excel Data
Best to create a UserForm
See the article "How to create a Userform" at: http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm Then, see the article "Load a ListBox from a Named Range in Excel using DAO" at: http://www.word.mvps.org/FAQs/InterD...xFromXLDAO.htm and See the article "How to find out which Items are selected in a Multi-Select ListBox" at: http://www.word.mvps.org/FAQs/Userfo...lectValues.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "O" wrote in message ... I am creating a template in Word for business proposals. It includes a table detailing the following components: Service, Description, Units, Unit Price, and Price. I want to be able to select the service in the first column using AutoFill or a drop-down menu, and then have the rest of the data related to that service imported from an Excel spreadsheet. Consequently, the table needs to be able to insert an additional line after each entry, and then total the pricing information in the last column. Is this as impossible as it seems? I have scoured the Internet for hours and cannot seem to find an answer to this that isn't chock full of programmer jargon. A relatively easy to follow answer would be greatly appreciated! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to combine Excel Data to Word Tables? | Microsoft Word Help | |||
Linking Excel data into pre-existing Word tables | Tables | |||
auto filling of blanks | Page Layout | |||
Auto updating the caption numbers associated with tables of data? | New Users | |||
Linking Excel data to tables in Word | Tables |