Cross Referance

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

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
 
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
 
Back
Top