Need help on Automating a common function
Dear Mr. Gary''s Student - Thank you. Unfortunately it did not work. It says
the formula is not correct. I am using Office Excel 2007. Just FYI we are
attempting to use the same hyperlink
"https://egov.uscis.gov/cris/caseStatusSearch.do?appReceiptNum=" in all cells
but the unique case number EAC0516151060 changes for each cell.
"Gary''s Student" wrote:
If B1 contains:
EAC0516151060
and A1 contains:
James Ravenswood
then in C1 enter:
=HYPERLINK("https://egov.uscis.gov/cris/caseStatusSearch.do?appReceiptNum="
& B1,A1)
This will produce a nice, clickable link.
--
Gary''s Student - gsnu200851
"Stumped Non-IT-ian" wrote:
We liaise with DHS. In our excel sheet we have 2 columns, A and B. A has
names. B has unique 10 digit alpha-numeric case numbers DHS generates, say
EAC0516151060. We can check case status at website:
"https://egov.uscis.gov/cris/caseStatusSearch.do?appReceiptNum=EAC0516151060"
This way we have 100 names and 100 unique numbers that we enter on Excel
sheet on daily basis.
Can excel sheet be configured in a way that once I enter the unique case
number in column B, the web address with the correct unique case number gets
automatically attached to the cell so that I have to just click to visit the
external website and see the end result?
Thanks
Raj
|