Need your help on a problem, I was working on.
I have a worksheet with two tabs.
Tab 1 : Application List
Tab 2: Job list by application
Tab1 : Columns
Application Code, Application Name, # of Jobs (Using formula COUNTIF("JobList"!$A$1:$A$200)
I have used hyperlink function within number of jobs area using hyperlink. IN this way a user can click on the hyperlink which will take to JobList sheet.
Tab2: Columns
Application Code, Job Name
Need your help on the following:
On App Name when user clicks on # of jobs, it should automatically filter column A for the value from Application List tab and put the cursor on first row in Job List.
I tried to use VBA, but don't know how to combine hyperlink and VBA.
Thank you for your help.
I have a worksheet with two tabs.
Tab 1 : Application List
Tab 2: Job list by application
Tab1 : Columns
Application Code, Application Name, # of Jobs (Using formula COUNTIF("JobList"!$A$1:$A$200)
I have used hyperlink function within number of jobs area using hyperlink. IN this way a user can click on the hyperlink which will take to JobList sheet.
Tab2: Columns
Application Code, Job Name
Need your help on the following:
On App Name when user clicks on # of jobs, it should automatically filter column A for the value from Application List tab and put the cursor on first row in Job List.
I tried to use VBA, but don't know how to combine hyperlink and VBA.
Thank you for your help.