List Box Transfer

Document Sample
List Box Transfer Powered By Docstoc
					Name Anne H Bill G Erin H Fred H John L Mary K

Age 21 33 32 32 25 36

Id# kn129 kl556 kl521 km225 kn559 kl236

Sex Female Male Female Male Male Female

Range Name
MyRange

Refers to

=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.htm

,0,COUNTA(Sheet1!$A$2:$A$100),COUNTA(Sheet1!$A$1:$J$1))

Ranges.htm

to consultancy.

il here in Issue 9

Name

Age

Id#

Sex


				
DOCUMENT INFO
Shared By:
Stats:
views:339
posted:1/3/2008
language:English
pages:3
Jeff Sperry Jeff Sperry
About