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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response