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

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

On Fri, 24 Aug 2007 16:22:02 -0700, Chelsey- Really need help!
<(E-Mail Removed)> wrote:

>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

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.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Chelsey- Really need help!" wrote:

> 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