Something like:

=mid(sheet3!a1,4,1)

If 331A were in A1 of sheet3.

or

=mid(c3,4,1)
if 331A were in C3 of the same sheet.

ratt wrote:

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

--

Dave Peterson