LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ratt
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 06:27 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"