+ Reply to Thread
Results 1 to 5 of 5

Year to month and back - entry formula to itself

  1. #1
    Forum Contributor
    Join Date
    08-22-2012
    Location
    Czech republic
    MS-Off Ver
    Excel 2010
    Posts
    119

    Year to month and back - entry formula to itself

    Hi all,
    I am trying to create a simple calculator where I would like to be able to choose between entry to "A1" - year, or "A2" months. I want it recalculate the other one no matter where I put it.
    So, I enter 5 years, it will calculate 5*12 in months. If I enter 24 months, it will calculate 24 / 12 in year.

    Do you have any idea how to do it?
    (so far, if you tell me how to make a macro which start when value is change MANUALLY, not by VBA, I can do it.)

    Thanks for any idea.
    Olwy

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Year to month and back - entry formula to itself

    Try this.....
    Please Login or Register  to view this content.
    Place the above code into worksheet module.

    Is this what you are trying to achieve?
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    08-22-2012
    Location
    Czech republic
    MS-Off Ver
    Excel 2010
    Posts
    119

    Re: Year to month and back - entry formula to itself

    Exacly. That is better than perfect. :-) Thanks a lot, "shukria" or धन्यवाद

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Year to month and back - entry formula to itself

    You're welcome. (आपका स्वागत है) Can you read this?
    Thanks for the feedback.

  5. #5
    Forum Contributor
    Join Date
    08-22-2012
    Location
    Czech republic
    MS-Off Ver
    Excel 2010
    Posts
    119

    Re: Year to month and back - entry formula to itself

    Not at all, I just have been in Hyderabad and Lucknow for couple months, but I cannot read it at all. I just love Hindustan and know a little bit of hindi.
    Thanks for your help.

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Year to month and back - entry formula to itself

    Oh that's great. Lucknow is only 90 Km. away from my home town Kanpur.
    Glad I could help. Pleasure is all mine.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Forcing month/year entry to last day of month
    By Gunther Maplethorpe in forum Excel General
    Replies: 8
    Last Post: 06-13-2013, 03:16 PM
  2. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  3. Replies: 4
    Last Post: 02-14-2010, 05:21 AM
  4. formula for prior month & year of a month end date.
    By mikeburg in forum Excel General
    Replies: 2
    Last Post: 09-25-2007, 04:01 PM
  5. [SOLVED] Formula to return last day of month for each month in year?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-03-2006, 12:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1