| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data From One Worksheet To Be Used In A Cell In A Different Worksheet
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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. -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=395615 |
|
#4
|
|||
|
|||
|
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 -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=395615 |
|
#5
|
|||
|
|||
|
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 -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=395615 |
|
#6
|
|||
|
|||
|
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 -- ratt ------------------------------------------------------------------------ ratt's Profile: http://www.excelforum.com/member.php...o&userid=24318 View this thread: http://www.excelforum.com/showthread...hreadid=395615 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Cell Reference Math | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
