Thread: Cross Referance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nathan[_3_] Nathan[_3_] is offline
external usenet poster
 
Posts: 2
Default 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