Previous Topic Next Topic

How to do in excel

Closed
ugn10 Posts 44 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 Contributor 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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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.

Similar discussions

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

6 responses
How to export datatable to excel using c# in ASP.NET?
Vikram_27 -
ac3mark -

3 responses