I have multiple worksheets and wish to use data from a cell in one
worksheet in a formula in a different worksheet..ie take data from
worksheet 3 for use in c3 in worksheet 1 to complete a formula....

also how can I using data in a cell ie...331a ; ignore the first 3
characters/numbers and copy the third character into another cell...to
be updated every time the cell cahnges.....ie...c3 = 331A
c4=A...and change c3 to 334B...then c4 changes to B..

tks ahead of time for the assist...

ratt out


--
ratt
------------------------------------------------------------------------
ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318
View this thread: http://www.excelforum.com/showthread...hreadid=395615