+ Reply to Thread
Results 1 to 3 of 3

Select multiple rows and cells based on a single date

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Select multiple rows and cells based on a single date

    In Excel, I have 3 columns of monthly historical data: Date (month end), Account Name, and Ending Dollar Value.

    The data consists of 3 accounts each with monthly ending dollar values dating back for several years.

    I have a cell that calculates the most recent month end, cell A1, and it uses the offset formula to do so, no problems here so far.

    I'd like to create a macro to select each account name and ending dollar value based on the most recent month end (currently 9/30/13 found in cell A1) and paste them on another sheet in the workbook. For example, if the 3 accounts have data from 12/31/2007 to 9/30/2013, I only want to display the data for 9/30/13 on the second worksheet.

    I have limited programming/visual basic experience and have taken on this project as a result of a looming deadline and our programming contractor disappearing from the face of the earth. Any help is much appreciated!

    Thanks,

    Lee

  2. #2
    Registered User
    Join Date
    10-04-2013
    Location
    Irving, Texas
    MS-Off Ver
    Office 2003-07-10-13
    Posts
    34

    Re: Select multiple rows and cells based on a single date

    can you upload a sample worknook showing what the beginning and finidhed results should look like?

  3. #3
    Registered User
    Join Date
    10-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Select multiple rows and cells based on a single date

    Sure, see attached.

    I need the macro to look at date in cell A1, find all accounts with that date in the Account History table and display those account numbers and ending balances in the Account Summary section to the right.

    As we move forward through the year, I will be adding new monthly data to the Account History section of the spreadsheet, so in November there will be ending monthly data for 10/31/13, cell A1 will show 10/31/13, and the Account Summary section should then show those accounts / values.
    Attached Files Attached Files

+ 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. [SOLVED] Select rows based on date range and copy to multiple tabs
    By B-Rell in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-01-2012, 09:27 AM
  2. Selecting multiple cells in multiple columns and rows to paste into a single row.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2012, 04:03 PM
  3. Converting multiple rows to single row based on a key
    By p51-mustang in forum Excel General
    Replies: 1
    Last Post: 07-05-2011, 01:26 PM
  4. Create new rows based on multiple cells on single row
    By julesie in forum Excel General
    Replies: 0
    Last Post: 10-20-2010, 02:10 PM
  5. Select rows in table based on start and end date
    By packe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2007, 12:18 PM

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