Hi,

Please can you confirm whther you wish to add this new data into a new row on
your corresponding sheet or whether it will replace data already there.

Thanks,

Simon

puiuluipui wrote:
hy, i hope someone can halp me..
i have 4 sheets...A,B,C,and FRONT..and i want to select in "FRONT" from a
drop down box "A,B or C"...and the data that i put in the row, to appear in
the corespondent worksheet(ex A)

ex:
sheet FRONT
A 23 14 55 22 (A is a dropdown box)
if i select from the dropdown box "B"...the data to automatically be
transfered to B sheet

sheet A
a b c d

1 1 0 18 29

2 20 20 0 0

3 23 14 55 22 (this is the last numbers that i put in
the "FRONT"sheet's row

thanks alot...i hope that my english in k..:) thanks again

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1