+ Reply to Thread
Results 1 to 2 of 2

Change column reference to next column dependent on date

  1. #1
    Registered User
    Join Date
    08-27-2009
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Change column reference to next column dependent on date

    Hi,

    I have a spreadsheet which is a monthly financial report, and there is a figure it brings in from another worksheet which is the corresponding figure for that month from the previous year.

    So currently the formula is simply this: ='LY Figures'!BH61
    For the next month, I need it to be ='LY Figures'!BI61
    So the column has simply moved over to the next one. There are a range of cells that all refer to ='LY Figures'!BH## - different rows each time.

    What I want to do if possible, is automatically change the column reference, leaving the row number alone, dependent on the date.

    So if the current month = 5, then BH.... if month = 6 then BI and so forth.
    I can do an IF function in VBA, but I don't know how to change the column reference.
    I preferably want to change all references of BH to BI, not cell by cell.

    Is this possible and how do I achieve it?

    Thanks,
    Michael

  2. #2
    Registered User
    Join Date
    08-27-2009
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Re: Change column reference to next column dependent on date

    *BUMP*

    Any ideas anyone?

+ 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