need help with excel 2007

Topics: User Forum
Oct 1, 2011 at 11:58 AM

Hi Guys,

i need some (actuall a lot) help here.

i want do create a excell file with some data in 3 columns

ex : type ref | Ordering code | List Price

i want to use this as a base file with tghe above data

then i want these data in another file (actuall a set of file) to work on.

if i type any thing that is under type ref, i want a suggestion box/some thing like that and once i select that i want either the ordering code / list price to appear in the next column.

i should be able to select if i want the ordering code or list price.

Guys please help me with this. <!-- / message --><!-- attachments -->