I need to know a little more about your spreadsheet:

Is column F in every sheet the same length?
If not, how many sheets are there?
What is the name of your summary page?
Are there empty rows between any entries in column F of ANY sheet?


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=556610