Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a cell based on current month
In Column E in a workbook I have cells with a month in it, formatted 'mmm'.
There will not be a cell for every month of the year. For example, one cell could be Jan, the other May, Aug, etc. Using VBA, is it possible to look for the current month in the column, if it doesn't exist, look for the previous month until it finds the most recent. IE: Look for Nov, if Nov doesn't exist, find Oct, if Oct not found, look for Sep? Thanks for any help -- Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Year-to-date based on current month | Excel Discussion (Misc queries) | |||
Finding values based on current month | Excel Worksheet Functions | |||
Finding values based on current month | Excel Programming | |||
Insert Criteria Based on Current Month | Excel Worksheet Functions | |||
Current date formula based on month | Excel Discussion (Misc queries) |