Hello All,
As I am trying out to link the sheets i.e from dashboard sheet i want to link the type form tab. from the main partner sign up report. Actually the thing is on one click of type form i want the overall pivot summary report to show. One option is I can use the hyper link to the type form tab. I would also want the pivot table data to be updated accordingly as per the daily updation basis. I would like to know is it the only way that I can opt for. Or else i can use some formula or something to make the work done. But according to me the hyper linking will show the entire worksheet of main partner sign up report where as i want only the pivot data summary to be showed or linked..If I can opt for any formula or something pls help me with that..sharing the file for your reference
Regards
Jaya
As I am trying out to link the sheets i.e from dashboard sheet i want to link the type form tab. from the main partner sign up report. Actually the thing is on one click of type form i want the overall pivot summary report to show. One option is I can use the hyper link to the type form tab. I would also want the pivot table data to be updated accordingly as per the daily updation basis. I would like to know is it the only way that I can opt for. Or else i can use some formula or something to make the work done. But according to me the hyper linking will show the entire worksheet of main partner sign up report where as i want only the pivot data summary to be showed or linked..If I can opt for any formula or something pls help me with that..sharing the file for your reference
Regards
Jaya
