MS EXcel. Show only required data and transfer to MS Word

[NeilPattison]

I have a spreadhseet that shows some materials we use in our company. The first column shows a description of the material, the second column shows the catalogue number of the material and the third column is left open for the user to enter in the required quantity.

I have attached to the spreadsheet a command button but I need some help with the VB coding. What I'd like to do is have the user enter the required quantities in the 3rd column and then click on this command button which would then only show the rows that have had quantities entered. If I could get this done it would be sufficient.

However if it is possible I would then like to have these rows tranfer into an order form which i already have developed in MS Word.

Any help with this would be greatly appreciated.

 

[comboy]

Hi Neil
You don't need VB to meet your first requirement just use the autofilter option under the Data menu and set it to display only the "non blanks" cells.

If you really want this on a button just record a macro of this action and work from there.

Secondly to place the records into word document use a mail merge.


Give me a shout if you need any help with either,


Graham.