Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Automating a common function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
Common footer but not common margins please -(Page 1 of 2) etc | Excel Discussion (Misc queries) | |||
Any function to determine the smallest common factor from a list? | Excel Discussion (Misc queries) | |||
Automating the Excel camera function | Excel Discussion (Misc queries) | |||
Need help with automating the updating of a function in worksheet | Excel Worksheet Functions |