Originally Posted by Spencer101
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?