I want to make an order entry program for customers...
 

I would appreciate if someone could point me in the right direction... What I
would like to be able to do is have a work sheet with columns for Part#
Width, Height, Depth, Specs., etc... When some one uses the drop down lists
on this work sheet it should bring the information that I just out lined with
it and show up in the appropriate columns and rows.

Is this the right program or would something like access be more along the
lines of what I need?

Thanks in advance

I want to make an order entry program for customers...
 

You can probably do it in either Access or Excel. If you have an extremely
large database and are not running xl2007, Access might be better for
inerfacing your order and inventory system. But basically, either would
work. I would consider using listboxes or comboboxes for calling up the
variations of parts and specifications so that choices can be made by the
user and then transferred to a single entry on the worksheet. You could
possible use textboxes but I find the listboxes easier to work with for
multiple choices. Everyone has their own preferences, depending on approach.

"John" wrote:

I would appreciate if someone could point me in the right direction... What I
would like to be able to do is have a work sheet with columns for Part#
Width, Height, Depth, Specs., etc... When some one uses the drop down lists
on this work sheet it should bring the information that I just out lined with
it and show up in the appropriate columns and rows.

Is this the right program or would something like access be more along the
lines of what I need?

Thanks in advance

I want to make an order entry program for customers...
 

Good samples he
http://www.vertex42.com/

Purchase Order:
http://www.vertex42.com/ExcelTemplat...ase-order.html

Or, just Google for it.


Regards,
Ryan---
--
RyGuy


"JLGWhiz" wrote:

You can probably do it in either Access or Excel. If you have an extremely
large database and are not running xl2007, Access might be better for
inerfacing your order and inventory system. But basically, either would
work. I would consider using listboxes or comboboxes for calling up the
variations of parts and specifications so that choices can be made by the
user and then transferred to a single entry on the worksheet. You could
possible use textboxes but I find the listboxes easier to work with for
multiple choices. Everyone has their own preferences, depending on approach.

"John" wrote:

I would appreciate if someone could point me in the right direction... What I
would like to be able to do is have a work sheet with columns for Part#
Width, Height, Depth, Specs., etc... When some one uses the drop down lists
on this work sheet it should bring the information that I just out lined with
it and show up in the appropriate columns and rows.

Is this the right program or would something like access be more along the
lines of what I need?

Thanks in advance