#1   Report Post  
SLLD
 
Posts: n/a
Default linking

I have a spreadsheet with numbers in left column
Words in right one
when I put a number in the 1st colum of a linked sheet , I want the words to
be transfered to the right one
TIA
Jim


  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Jim, you may want to try something like this:
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"SLLD" wrote in message
.. .
I have a spreadsheet with numbers in left column
Words in right one
when I put a number in the 1st colum of a linked sheet , I want the words

to
be transfered to the right one
TIA
Jim




  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use a VLookup formula to return the words that match the number
you've entered. There's information on VLookup in Excel's Help, and
instructions and examples he

http://www.contextures.com/xlFunctions02.html

and another sample with instructions he

http://www.contextures.com/xlOrderForm01.html

SLLD wrote:
I have a spreadsheet with numbers in left column
Words in right one
when I put a number in the 1st colum of a linked sheet , I want the words to
be transfered to the right one



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #4   Report Post  
SLLD
 
Posts: n/a
Default

thank you
I am just a bit new to this..

"SLLD" wrote in message
.. .
I have a spreadsheet with numbers in left column
Words in right one
when I put a number in the 1st colum of a linked sheet , I want the words
to be transfered to the right one
TIA
Jim




Reply
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
conditional forming causing linking errors Dave Breitenbach Excel Worksheet Functions 0 April 1st 05 08:19 PM
Linking worksheets after runnning report Steve Excel Discussion (Misc queries) 0 February 28th 05 10:21 PM
linking to other worksheet phlashh1 Excel Worksheet Functions 0 February 2nd 05 06:09 PM
Have to use cursor keys cannot use mouse in excel when linking fo. LUFC Excel Worksheet Functions 0 January 31st 05 10:51 AM
Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 09:27 PM


All times are GMT +1. The time now is 04:07 PM.

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

About Us

"It's about Microsoft Excel"