Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lmatarazzo
 
Posts: n/a
Default how do I make a word typed in a cell go to a specific cell in anot

My proble is I have to use abbreviations in the cell Im writing in and then
when ever that word is placed in a cell I want it to transfer to a specific
cell in another sheet.Example: y11 would be placed in a cell in sheet 1 and
it would transfer to a cell in sheet three that said yard1????
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

What is the correlation between an unknown abbreviation and
a specific unspecified cell. Did you try recording a macro to
get you started. If you can do the specific steps needed
manually to do what you ask you can record a macro.

Being able to describe what you want is usually half way toward
a solution.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lmatarazzo" wrote in message ...
My proble is I have to use abbreviations in the cell Im writing in and then
when ever that word is placed in a cell I want it to transfer to a specific
cell in another sheet.Example: y11 would be placed in a cell in sheet 1 and
it would transfer to a cell in sheet three that said yard1????



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

I would suggest you have a read in Help on VLOOKUP.

You will need a two column table with your abbreviations and words then a
VLOOKUP formula in a cell on Sheet3.

If you post a sample list of abbreviations and words and where you want the
output, we could come up with a formula.



Gord Dibben Excel MVP

On Fri, 15 Apr 2005 09:47:03 -0700, "Lmatarazzo"
wrote:

My proble is I have to use abbreviations in the cell Im writing in and then
when ever that word is placed in a cell I want it to transfer to a specific
cell in another sheet.Example: y11 would be placed in a cell in sheet 1 and
it would transfer to a cell in sheet three that said yard1????


  #4   Report Post  
Lmatarazzo
 
Posts: n/a
Default

okay here it is:Abbreviations sheet 4
Office 1 OF1 Yard 10 Y10 Yard 50 Y50 Yard 90 Y90 Fire Lane 1 FL1
Office 2 OF2 Yard 11 Y11 Yard 51 Y51 Yard 91 Y91 Fire Lane 2 FL2
Office 3 OF3 Yard 12 Y12 Yard 52 Y52 Yard 92 Y92 Fire Lane 3 FL3
Office 4 OF4 Yard 13 Y13 Yard 53 Y53 Yard 93 Y93 Fire Lane 4 FL4
Office 5 OF5 Yard 14 Y14 Yard 54 Y54 Yard 94 Y94 Fire Lane 5 FL5
Office 6 OF6 Yard 15 Y15 Yard 55 Y55 Yard 95 Y95 Fire Lane 6 FL6
Office 7 OF7 Yard 16 Y16 Yard 56 Y56 Yard 96 Y96 Fire Lane 7 FL7
Office 8 OF8 Yard 17 Y17 Yard 57 Y57 Yard 97 Y97 Fire Lane 8 FL8
Office 9 OF9 Yard 18 Y18 Yard 58 Y58 Yard 98 Y98 Fire Lane 9 FL9
Office 10 OF10 Yard 19 Y19 Yard 59 Y59 Yard 99 Y99 Fire Lane 10 FL10
Office 11 OF11 Yard 20 Y20 Yard 60 Y60 Yard 100 Y100 Fire Lane 11 FL11
Office 12 OF12 Yard 21 Y21 Yard 61 Y61 Yard 101 Y101 Fire Lane 12 FL12
Ramp 1 R1 Yard 22 Y22 Yard 62 Y62 Yard 102 Y102 Fire Lane 13 FL13
Ramp 2 R2 Yard 23 Y23 Yard 63 Y63 Yard 103 Y103 Fire Lane 14 FL14
Ramp 3 R3 Yard 24 Y24 Yard 64 Y64 Yard 104 Y104 Fire Lane 15 FL15
Ramp 4 R4 Yard 25 Y25 Yard 65 Y65 Yard 105 Y105 Fire Lane 16 FL16
Ramp 5 R5 Yard 26 Y26 Yard 66 Y66 Yard 106 Y106 Fire Lane 17 FL17
Ramp 6 R6 Yard 27 Y27 Yard 67 Y67 Yard 107 Y107 Fire Lane 18 FL18
Ramp 7 R7 Yard 28 Y28 Yard 68 Y68 Yard 108 Y108 Fire Lane 19 FL19
Ramp 8 R8 Yard 29 Y29 Yard 69 Y69 Yard 109 Y109 Fire Lane 20 FL20
Ramp 9 R9 Yard 30 Y30 Yard 70 Y70 Yard 110 Y110 Fire Lane 21 FL21
Ramp 10 R10 Yard 31 Y31 Yard 71 Y71 Yard 111 Y111 Fire Lane 22 FL22
Ramp 11 R11 Yard 32 Y32 Yard 72 Y72 Yard 112 Y112 Fire Lane 23 FL23
Ramp 12 R12 Yard 33 Y33 Yard 73 Y73 Yard 113 Y113 Fire Lane 24 FL24
Back Rd 1 BR1 Yard 34 Y34 Yard 74 Y74 Yard 114 Y114 Fire Lane 25 FL25
Back Rd 2 BR2 Yard 35 Y35 Yard 75 Y75 Yard 115 Y115 Fire Lane 26 FL26
Back Rd 3 BR3 Yard 36 Y36 Yard 76 Y76 Yard 116 Y116 Fire Lane 27 FL27
Back Rd 4 BR4 Yard 37 Y37 Yard 77 Y77 Yard 117 Y117 Fire Lane 28 FL28
Back Rd 5 BR5 Yard 38 Y38 Yard 78 Y78 Yard 118 Y118 Fire Lane 29 FL29
Back Rd 6 BR6 Yard 39 Y39 Yard 79 Y79 Z1 Z1 Fire Lane 30 FL30
Back Rd 7 BR7 Yard 40 Y40 Yard 80 Y80 Z3 Z3 Fire Lane 31 FL31
Back Rd 8 BR8 Yard 41 Y41 Yard 81 Y81 Circle1 C1 Fire Lane 32 FL32
Back Rd 9 BR9 Yard 42 Y42 Yard 82 Y82 Circle2 C2 Fire Lane 33 FL33
Back Rd 10 BR10 Yard 43 Y43 Yard 83 Y83 Circle3 C3 Fire Lane 34 FL34
Back Rd 11 BR11 Yard 44 Y44 Yard 84 Y84 Circle4 C4 Fire Lane 35 FL35
Back Rd 12 BR12 Yard 45 Y45 Yard 85 Y85 Circle5 C5 Fire Lane 36 FL36
Back Rd 13 BR13 Yard 46 Y46 Yard 86 Y86 Circle6 C6 Fire Lane 37 FL37
Back Rd 14 BR14 Yard 47 Y47 Yard 87 Y87 Circle7 C7 Fire Lane 38 FL38
Back Rd 15 BR15 Yard 48 Y48 Yard 88 Y88 Circle8 C8 Fire Lane 39 FL39
Back Rd 16 BR16 Yard 49 Y49 Yard 89 Y89 Circle9 C9 Fire Lane 40 FL40
that is the list and this is the sheet I want it to go to:sheet 3 where it
needs to copy to
Door 1 HEL ME OH Office 1 Yard 10
Door 2 csxu 932813 inb Office 2 Yard 11
Door 3 NCHU 282749 inb Office 3 Yard 12
Door 4 hunu 663504 inb Office 4 Yard 13
Door 5 csxu 933247 inb Office 5 Yard 14
Door 6 Cown 53815 inb Office 6 Yard 15
Door 7 CSXU 933410 inb Office 7 Yard 16
Door 8 CSXU 937939 inb Office 8 Yard 17
Door 9 csxu 935082 inb Office 9 Yard 18
Door 10 csxu 933272 inb Office 10 Yard 19
Door 11 sftz 220959 inb Office 11 Yard 20
Door 12 NCHU 686430 inb Office 12 Yard 21
Door 13 hubu 281630 inb Ramp 1 Yard 22
Door 14 USAZ 240761 inb Ramp 2 Yard 23
Door 15 csxu 930050 inb Ramp 3 Yard 24
Door 16 RDWY 901283 h891 Ramp 4 Yard 25
Door 17 COWN 54290 h905 Ramp 5 Yard 26
Door 18 Ncju 932635 inb Ramp 6 Yard 27
Door 19 Cowan 53940 inb Ramp 7 Yard 28
Door 20 Cowan 53976 inb Ramp 8 Yard 29
Door 21 cowan 80184 H909 Ramp 9 Yard 30
Door 22 inca 461 8467 Ramp 10 Yard 31
Door 23 solo 1 h906 Ramp 11 Yard 32
Door 24 cown 53899 h902 Ramp 12 Yard 33
Door 25 inca 531 8252 Back Rd 1 Yard 34
Door 26 Back Rd 2 Yard 35
Door 27 inca 520 57553 Back Rd 3 Yard 36
Door 28 Back Rd 4 Yard 37
Door 29 Cown 80806 h908 Back Rd 5 Yard 38
Door 30 cown 65039 h910 Back Rd 6 Yard 39
Door 31 regency 3176 1371 Back Rd 7 Yard 40
Door 32 Back Rd 8 Yard 41
Door 33 cowan 80201 h903 Back Rd 9 Yard 42
Door 34 C&S 11008511 1368 Back Rd 10 Yard 43
Door 35 cowan 81026 h914 Back Rd 11 Yard 44
Door 36 regcy 3337 1366 Back Rd 12 Yard 45
Door 37 INCA 625 8244 Back Rd 13 Yard 46
Door 38 c&s 68008178 1388 Back Rd 14 Yard 47
Door 39 Back Rd 15 Yard 48
Door 40 Back Rd 16 Yard 49
the second sheet is where the abbreviations have to go and they need to
transfer to the above spots so that when you enter a abbreviation in sheet 2
it copies the cells next to it to the 3 sheet




"Gord Dibben" wrote:

I would suggest you have a read in Help on VLOOKUP.

You will need a two column table with your abbreviations and words then a
VLOOKUP formula in a cell on Sheet3.

If you post a sample list of abbreviations and words and where you want the
output, we could come up with a formula.



Gord Dibben Excel MVP

On Fri, 15 Apr 2005 09:47:03 -0700, "Lmatarazzo"
wrote:

My proble is I have to use abbreviations in the cell Im writing in and then
when ever that word is placed in a cell I want it to transfer to a specific
cell in another sheet.Example: y11 would be placed in a cell in sheet 1 and
it would transfer to a cell in sheet three that said yard1????



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
Displaying cell references next to embedded cells in Word 2000 The Consigliere New Users to Excel 1 April 9th 05 02:58 PM
I want to type the letter Y in a cell and have the word Yes appea. jhardw New Users to Excel 3 April 2nd 05 12:24 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM
Copy Word table into Excel cell by cell hg Excel Discussion (Misc queries) 3 December 15th 04 05:43 PM
how do I make a cell flash pedro Excel Discussion (Misc queries) 1 December 15th 04 01:42 PM


All times are GMT +1. The time now is 03:52 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"