|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com