Don. I appreciate you taking the trouble to reply but you're assuming a
greater level of knowledge than I possess!

I was looking for a function/functions and don't understand your suggestion.


"Don Guillett" wrote in message
...

As ALWAYS, you should post your code for comments. If you want to find the
last column in row 1

lastcol=cells(1,columns.count).end(xltoleft).colum n

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terry Bennett" wrote in message
...
I know that there will be a simple solution to this but have been playing
with it for 1/2 hour now and not making progress!

I have a table of data (say A1:Z100). An extra column is added each week
when various figures are received. Hence, at the moment, I have a list
of branches in column A and dates across the top in Row 1.

All I need to do is to populate a summary with data extracted from the
most recent figures. I can do this easily with VLOOKUP but how do I
programme it such that Col_index_num returns data from the column with
the most recent date in Row 1? I have tried using MAX but can't seem to
find the right syntax.

Many thanks.