I am working on a spreadsheet that list a number of packages available.
Each package has a name and 3 to 6 cells under it listing what is in that
package.
For instance: FAX MACHINE PACKAGE is the 1st cell and under it is Fax
Machine, power cord and RJ Cable each in their own cell

I have already created a dropdown box so the packages can be listed and
chosen that way but what I need to figure out is how to get excel to take
that drop down information(package name) and show me what is in the package.

I am using all of this in an email to order items. The person selects what
package they need and a box populates with the contents (so they can edit out
what they dont need)

Any of that make any sense at all or am I hopelessly confusing myself?

--


``DAThomas``

How are you transferring the drop down from Excel to email? Are you attaching
the Excle file?

For a sample solution go to
http://www.contextures.com/excelfiles.html#DataVal and search for "Product
List by Category". You may also look at "Move Items to Order Form".

"David" wrote:

I am working on a spreadsheet that list a number of packages available.
Each package has a name and 3 to 6 cells under it listing what is in that
package.
For instance: FAX MACHINE PACKAGE is the 1st cell and under it is Fax
Machine, power cord and RJ Cable each in their own cell

I have already created a dropdown box so the packages can be listed and
chosen that way but what I need to figure out is how to get excel to take
that drop down information(package name) and show me what is in the package.

I am using all of this in an email to order items. The person selects what
package they need and a box populates with the contents (so they can edit out
what they dont need)

Any of that make any sense at all or am I hopelessly confusing myself?

--


``DAThomas``

Well I was just using copy and then the paste special as an excel spreadsheet
command
--


``DAThomas``


"Sheeloo" wrote:

How are you transferring the drop down from Excel to email? Are you attaching
the Excle file?

For a sample solution go to
http://www.contextures.com/excelfiles.html#DataVal and search for "Product
List by Category". You may also look at "Move Items to Order Form".

"David" wrote:

I am working on a spreadsheet that list a number of packages available.
Each package has a name and 3 to 6 cells under it listing what is in that
package.
For instance: FAX MACHINE PACKAGE is the 1st cell and under it is Fax
Machine, power cord and RJ Cable each in their own cell

I have already created a dropdown box so the packages can be listed and
chosen that way but what I need to figure out is how to get excel to take
that drop down information(package name) and show me what is in the package.

I am using all of this in an email to order items. The person selects what
package they need and a box populates with the contents (so they can edit out
what they dont need)

Any of that make any sense at all or am I hopelessly confusing myself?

--


``DAThomas``