Name Age Id# Sex Anne H 21 kn129 Female Bill G 33 kl556 Male Erin H 32 kl521 Female Fred H 32 km225 Male John L 25 kn559 Male Mary K 36 kl236 Female Range Name Refers to MyRange =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$See here for dynamic range examples: http://www.ozgrid.com/Excel/DynamicRanges.htm OzGrid Business Applications if it's Excel it's us. From training to consultancy. http://www.MicrosoftExcelTraining.com http://www.OzGrid.com This example is explained in more detail here in Issue 9 http://www.ozgrid.com/News/Archive.htm2,0,0,COUNTA(Sheet1!$A$2:$A$100),COUNTA(Sheet1!$A$1:$J$1)) DynamicRanges.htm to consultancy. detail here in Issue 9Name Age Id# Sex