Pls suggest for Excel

Closed
Report
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
-
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
-
Dear all,

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 Subscription dates on one sheet (say, on 1st sheet) automatically one the date of Subscription Ending, if file is opened on that date.

Also when I click that date on that sheet (say, 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

The report file uploaded is just an idea.
I want all Subscription date to be copied automatically from all sheets to one sheet (says, 1st sheet) one the date of Subscription Ending, if file is opened on that date.

Pls suggest how to do it.

Thanks & Regards

1 reply

Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Hi

File not found in that link