I have a spreadsheet that has the months in columns and names in rows. It
holds historical YTD information for the people, one number for each month.
It also has a column that will average the months. A is the name, B is the
average C-N equals Jan-Dec.

I am building a macro that will open this file, find the name and get the
YTD average. Easy enough. Now I need it to have it find the name and
calculate the average of just the last three months of the data available in
the sheet. This of course will vary depending on when I use this file.
Right now, data is through March, so I need Jan-Mar averaged. Next month, I
will need to calculate Feb-Apr.

Any thoughts? Thanks in advance for your help!