Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Referance over Network | Excel Discussion (Misc queries) | |||
ISFORMULA(Cell Referance) | Excel Worksheet Functions | |||
Help with a formula. Lookup? referance? | Excel Worksheet Functions | |||
Circular Referance | Excel Discussion (Misc queries) | |||
Cell referance for formula | Excel Worksheet Functions |