Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() Quote:
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Test if Last Character in Column of Cells is Alpha Character | Excel Programming | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
importing undelimited text file data, character-by-character | Excel Programming | |||
Function to return Character Position of Xth character within a string | Excel Programming |