+ Reply to Thread
Results 1 to 5 of 5

Change the cell focus based on month and year

  1. #1
    Registered User
    Join Date
    01-22-2010
    Location
    Milton Keynes
    MS-Off Ver
    Excel 2007
    Posts
    15

    Change the cell focus based on month and year

    Hi,

    I have a worksheet called "zz_Exchange" that contains the exchange rate for my company for each month of the financial year. I am using this info in a summary page that uses the data for multiple calculations in the workbook.As we pass each month I would like to move the focus of a cell in the summary sheet to the relevant month in "zz_Exchange"

    The column names are "currency_code" (USA Euro etc),
    "currency_year" (09, 10)
    "period" (1-12)
    "exchange_rate" (this is where the data is held)

    Thanks
    Gruf1968

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Change the cell focus based on month and year

    My initial thought is a helper column that has =A1&B1&C1, copied down, then a Vlookup in your summary table that combines those three elements. If this doesn't work, could you post a dummy workbook?

    Also, if you'd like flexibility to show multiple months or the same month in different years, etc., you could consider a pivot table.

  3. #3
    Registered User
    Join Date
    01-22-2010
    Location
    Milton Keynes
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Change the cell focus based on month and year

    This is the dummy sheet showing the two parts that are relevant.
    Attached Files Attached Files

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Change the cell focus based on month and year

    You manually put the months into column F. But the currency year is the same for December and the next row's January. Is that how the data is organised?

    Anyway, If this column can hold a real date, a formula along these lines would work:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-22-2010
    Location
    Milton Keynes
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Change the cell focus based on month and year

    thanks with a bit of manipulation on the part of my data that solves my problem. Thankyou
    Last edited by gruf1968; 01-24-2010 at 02:04 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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