Pls suggest for my following issue related to Microsoft Excel.
I created a Report in Excel having many sheets. In all sheets, Subscription Dates are available.
Now I want all those Subscription dates on my 1st sheet automatically one the Subscription Ending Date, if file is opened on that date. Also when I click that date on 1st sheet, the corresponding sheet should open with location of that cell (like hyperlink).
Download the report file here. http://speedy.sh/MjZwA/Sales-Report.xlsx
You see the same thing in this that I told. I want all Subscription date automatically from all sheets to 1st sheet at the Subscription Ending date, if file is opened on that date.