Adding cells with programmed data

[Guest]

I need to know how I can add cells with data already in them, but have these
cells hidden. I'm working on an order confirmation. There is a main document
and then the order confirmation is a separate document that feeds off it. The
order confirmation will change as the main document changes. An example of
what I'm trying to do is to have only the object that a customer is buying
come up on the order confirmation. Whereas the main document has all the
possible thing they could buy- having a quantity column beside it.

If anyone has any suggestions they would be greatly appreciated! Thanks

 

[Gord Dibben]

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

 

[Guest]

Chelsey,

What I would suggest is that you have a seperate worksheet with all the
products. This can then be maintained outside the order confirmation process
and only one copy is available.

You then use a dialog box to process adding a new order line to the order
confirmation and the dialog box uses a combo box to select the product which
is filled from the other product list.

Once the user presses the OK button on the dialog box your code fills in the
line in the order.

Hope this makes it a little clearer.