Previous Topic Next Topic

How to do in excel

Closed
ugn10
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
 - May 20, 2013 at 02:23 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 - May 27, 2013 at 12:06 PM
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

Answer 1 / 1
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 515
May 21, 2013 at 12:00 PM
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
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 515
May 27, 2013 at 12:06 PM
@Ugn10

Creating the same thread again without answering my response.

What is the point of that?

Anyway best of luck with your query.
0