How to do in excel

Closed
Report
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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 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.

Pls suggest how to do it.

Thanks & Regards

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Ugn10,

So when you open the file you want to loop through all months sheets column Q to find dates that are the same as today.

When found copy/paste corresponding subscription date to 1st sheet "Cover Page".
At what location?

Did I understand you correctly, because the layout of "Cover Page" would suggest otherwise.

Best regards,
Trowa
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
@Ugn10

Creating the same thread again without answering my response.

What is the point of that?

Anyway best of luck with your query.