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
Bookmarks