|Subject:||Re: Excel 2003 - VBA - Lookup to determine ROW of Match|
|Posted by:||Zumble (Zumb…@Zumble.Zumble)|
|Date:||Thu, 10 Jul 2008|
Please don't do that.
Use Pivot tables.
Pivot tables can automatically group data in months.
Pivot tables can read flat files.
Pivot tables are a teeny weeny bit difficult to master.
Once you have cracked the idea, you will save yourself years of writing
"Craig Brandt" <brandtcra…@att.net> a écrit dans le message de news:
> I would like to do a lookup with the intent of determining the row of the
> I have several years of data in a flat file and am interested in doing a
> vertical lookup confined to a months worth of data. To do this I need to
> know what row the month starts and what row it ends.
Excel 2003 - VBA - Lookup to determine ROW of Match posted by Craig Brandt on Thu, 10 Jul 2008