Previous Topic Next Topic

How to do in excel

Closed
ugn10 Posts 44 Registration date Saturday 27 October 2012 Status Member Last seen 4 March 2014 - 20 May 2013 à 14:23
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 May 2013 à 12:06
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
21 May 2013 à 12:00
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
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 May 2013 à 12:06
@Ugn10

Creating the same thread again without answering my response.

What is the point of that?

Anyway best of luck with your query.

Similar discussions

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

6 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses