Cross Referance
 

I am creating a spread sheet, there is alot of repeated
item but there is differant prefixes in from of them all.
i was wondering if there was a way i could take a cell
from one sheet to another sheet with a differant prefix

eg.
sheet = Web Sites
cell = B5
cell contents = hershaltech.com

i want to take that cell and add it a part of another cell

sheet = FTP
cell = B5
cell contents = ftp.hershaltech.com

is there a formula i can use or another way i can do it
automatically without having to type it all in???

thanks
nathan

Cross Referance
 

In Sheet FTP, put the following formula for Cell B5

="FTP." & WebSites!B5

Format cells on sheet FTP as Hyperlinks using Insert Hyperlink Place in
this Document, and select the range of cells in sheet FTP that you require
to be set as hyperlinks.


Cheers
Nigel


"Nathan" wrote in message
...
I am creating a spread sheet, there is alot of repeated
item but there is differant prefixes in from of them all.
i was wondering if there was a way i could take a cell
from one sheet to another sheet with a differant prefix

eg.
sheet = Web Sites
cell = B5
cell contents = hershaltech.com

i want to take that cell and add it a part of another cell

sheet = FTP
cell = B5
cell contents = ftp.hershaltech.com

is there a formula i can use or another way i can do it
automatically without having to type it all in???

thanks
nathan




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---