Also - you can embed the Excel Workbook in a Word document and it will work exactly as if you were in Excel.
Tony

That is exactly how I need it to work. I would need it in my word document and I do not know how to embed it??

Hi
Follow these steps to embed the Excel solution in your Word document:
1. Place your cursor in the Word document at the point you want the Excel object to be displayed.
2. Select Insert followed by Object followed by Create From File.
3. Click on Browse and locate the Excel Workbook you wish to embed and click Insert.
The Excel Object will then be inserted at the point of the cursor in your document.
To activate (change) the entries in the workbook you simply double-click anywhere in the objdect and it cna be changed just as if you were inside Excel.
Make your changes as required and click anywhere outside of the Excel object and your changes will be display in the Word document.
If you have any further queries then please come back to the Forum.

Good luck.
Tony

Hi Tony,

No Luck on the embedding of excel file. I was able to get the file into my Word doc but I could not pick items from my drop down menu. It was just a "snapshot" of my file. Any suggestions?

Hi
Did you make sure you chose "Create From File" and then once it is in your document you double click on the workbook and it acts exactly as if you were in Excel.
Just tested it here and it works fine.
If still no luck can you send me a copy of your Word document and Excel file to tony.king@capita.co.uk and I will take a look for you.
Tony

Hi
I have just tested it here and it works fine.
Can you send me a copy of both documents to tony.king@capita.co.uk and I will take a look.
Tony