Word doc to excel worksheet

[ipbr21054]

Evening.
I am currently using a word document as a invoice sheet which I then print for the customer and also save a copy.

I now wish to use excel for this task.
Would you advise me to start again in excel or transfer this word doc to the worksheet somehow.

My reason for this is that I'm now getting a few repeat customers and quicker to select from a drop down list rather than typing it out again and again each day.

Many thanks.
I can supply this word doc here should you require it.

 

[Macropod]

Even in Word, you can use a dropdown or combo-box content control for selecting items like customer names...

In the longer term, though, you'll probably want to store the data in Excel or Access and use automation or mailmerge to produce the invoices in Word.

 

[Macropod]

Cross-posted at: Drop down list for word doc
Please read Mr Excel's policy on Cross-Posting in rule #13 : Forum Rules

 

[ipbr21054]

I didnt know it was cross posting seeing it was 2 different sites.

 

[Macropod]

That is precisely what cross-posting is. Kindly read the Board Rules.