Data From One Worksheet To Be Used In A Cell In A Different Worksheet

R

ratt

I have multiple worksheets and wish to use data from a cell in on
worksheet in a formula in a different worksheet..ie take data fro
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
characters/numbers and copy the third character into another cell...t
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 ou
 
D

Dave Peterson

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.
 
R

ratt

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 R17 in GRAND TOTAL FOR B-SHIFT INTO A FORMULA in
CELL B4.
 
R

ratt

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
GRAND TOTAL FOR B-SHIFT INTO A FORMULA in R17 for use a different
worksheet in CELL B4 (in a formual to determine # of computer epaired
per hour automatically by the data entered into the worksheet titled
GRAND TOTAL FOR B-SHIFT). tks

ratt out
 
R

ratt

I have multiple worksheets and wish to use data from a cell in on
worksheet in a formula in a different worksheet..ie take data fro
GRAND TOTAL FOR B-SHIFT INTO A FORMULA in R17 for use a differen
worksheet in CELL B4 (in a formual to determine # of computer epaire
per hour automatically by the data entered into the worksheet title
GRAND TOTAL FOR B-SHIFT). tks

ratt ou
 
R

ratt

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
GRAND TOTAL FOR B-SHIFT INTO A FORMULA in R17 for use a different
worksheet in CELL B4 (in a formual to determine # of computer epaired
per hour automatically by the data entered into the worksheet titled
GRAND TOTAL FOR B-SHIFT). tks

ratt out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple worksheet sales data by month 4
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Can I use a worksheet name in a formula? 4
Conditional formatting multiple cells from one cell to another 3
Type data in one cell - and it automatically populates another cel 5
how do I use a cell from one worksheet in the equation of another 3
Can an incrementing value in a cell point to different worksheets? 3
how do I referance a data valuation cell from another worksheet 2

Top