I am using a vlookup fomula in one worksheet whick looks up the data for
each month....Jan, Feb, March... are the column headings. It looks up
values in another workbook, with worksheets for each month...Jan, Feb,
March...are the worksheet names. Is there a way to autofill the
vlookup formulas to change to avoid retyping the Month reference.?

Thanks


--
nihad
------------------------------------------------------------------------
nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285
View this thread: http://www.excelforum.com/showthread...hreadid=538476