how do I

senario : i have three costs, three catagories, three codes

if i select code (a) it needs to auto collect pertaining data and sho
them in pre selected cells, which in this case would be
(A), product text, Cost (digits) there will only be three combination
and the data will not vary from these combinations. when i select (a
the relevant product data will be displayed , along with the cost

if code is needed and is available it would be much appriciated

reg

--
kevat
-----------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...fo&userid=3024
View this thread: http://www.excelforum.com/showthread.php?threadid=51235

It would help if you could show how input data is organised and how you want
the output i.e. what are the pre-defined cells.

"kevatt" wrote:


how do I

senario : i have three costs, three catagories, three codes

if i select code (a) it needs to auto collect pertaining data and show
them in pre selected cells, which in this case would be
(A), product text, Cost (digits) there will only be three combinations
and the data will not vary from these combinations. when i select (a)
the relevant product data will be displayed , along with the cost

if code is needed and is available it would be much appriciated

regs


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=512352

ok:

(a1) = my Ref IE: (A)= manully inputed data (my ref)
(b1) = my product text
(c1) = my price

when i enter the (My Ref A) in cell (a1) information needs to auto fill
both (b1) product text And (C1) price . i do not need to enter
infomation into b1 or c1 i think that the first cell (A1) is the cell
thats need the code

so in short i need to insert (manually) either a, b, c in Cell (a1)and
the informatin that is linked to either a, b, c will auto fill (b1) and
(c1)

if it helps the a,b,c is selected from a drop down list box


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=512352

kevatt Wrote:
ok:

(a1) = my Ref IE: (A)= manully inputed data (my ref)
(b1) = my product text
(c1) = my price

when i enter the (My Ref A) in cell (a1) information needs to auto fill
both (b1) product text And (C1) price . i do not need to enter
infomation into b1 or c1 i think that the first cell (A1) is the cell
thats need the code

so in short i need to insert (manually) either a, b, c in Cell (a1)and
the informatin that is linked to either a, b, c will auto fill (b1) and
(c1)

if it helps the a,b,c is selected from a drop down list boxstill need help


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=512352

Hi,
look at

http://www.contextures.com/xlDataVal02.html

or consider using VLOOKUP FUNCTION.

"kevatt" wrote:


ok:

(a1) = my Ref IE: (A)= manully inputed data (my ref)
(b1) = my product text
(c1) = my price

when i enter the (My Ref A) in cell (a1) information needs to auto fill
both (b1) product text And (C1) price . i do not need to enter
infomation into b1 or c1 i think that the first cell (A1) is the cell
thats need the code

so in short i need to insert (manually) either a, b, c in Cell (a1)and
the informatin that is linked to either a, b, c will auto fill (b1) and
(c1)

if it helps the a,b,c is selected from a drop down list box


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=512352