#1   Report Post  
Old July 23rd 12, 06:11 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 3
Default Character Link

Hello, I'll try to explain this as best I can. I am not the most technical user but I'm trying to learn. What I'm trying to do is figure out if by using the * character I can use it to link to a different cell. On sheet A you'll see the same name, one with & without the *. Is there a way to make it link to either the green or blue cells on sheet by just by that character alone? Thanks in advance for any help!


  #2   Report Post  
Old July 23rd 12, 06:16 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by Rixster View Post
Hello, I'll try to explain this as best I can. I am not the most technical user but I'm trying to learn. What I'm trying to do is figure out if by using the * character I can use it to link to a different cell. On sheet A you'll see the same name, one with & without the *. Is there a way to make it link to either the green or blue cells on sheet by just by that character alone? Thanks in advance for any help!

Hi Rixster,

What do you mean by "link" exactly? Your post doesn't make it clear what you're actually trying to do...

Also, a sample workbook rather than an image file will yield an appropriate reply far quicker.
  #3   Report Post  
Old July 23rd 12, 06:28 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 3
Default

Quote:
Originally Posted by Spencer101 View Post
Hi Rixster,

What do you mean by "link" exactly? Your post doesn't make it clear what you're actually trying to do...

Also, a sample workbook rather than an image file will yield an appropriate reply far quicker.
Sorry, can't post the workbook. Ricght now, it's set up so that when John oe's name goes in on sheet A, it pulls the $ amounts from the green cells in sheet B. I'm looking for a way to have it recognize a change so instead of pulling from the green in sheet b it would pull from the blue. so John Doe = Green cells on sheet B, John Doe* = Blue cells on sheet B. Is that possible?
  #4   Report Post  
Old July 23rd 12, 06:29 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 3
Default

Quote:
Originally Posted by Spencer101 View Post
Hi Rixster,

What do you mean by "link" exactly? Your post doesn't make it clear what you're actually trying to do...

Also, a sample workbook rather than an image file will yield an appropriate reply far quicker.
Sorry, can't post the workbook. Right now, it's set up so that when John Doe's name goes in on sheet A, it pulls the $ amounts from the green cells in sheet B. I'm looking for a way to have it recognize a change so instead of pulling from the green in sheet b it would pull from the blue. so John Doe = Green cells on sheet B, John Doe* = Blue cells on sheet B. Is that possible?


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
Excel 2007 - Formatting text in cell (character by character) TomC Excel Discussion (Misc queries) 0 January 29th 10 07:25 PM
Test if Last Character in Column of Cells is Alpha Character Benjamin Excel Programming 6 September 21st 09 06:36 PM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 06:36 PM
importing undelimited text file data, character-by-character The Mos$ Excel Programming 4 December 26th 05 11:01 AM
Function to return Character Position of Xth character within a string Andibevan[_2_] Excel Programming 4 June 9th 05 03:24 PM


All times are GMT +1. The time now is 11:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017