want to autofill from 300+ names

[jerminski73]

I have a customer list of over 300 names that I want to autofill from a
selected data entry range. I would prefer to go 30 rows by 10 columns if
possible but will take whatever I can get. Thanks in advance!

 

[Don Guillett]

More info or
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

 

[Max]

Assume your source names running in A1 down
In say, B1: =OFFSET($A$1,ROWS($1:1)*10-10+COLUMNS($A:A)-1,)
Copy B1 across by 10 cols to K1, fill down as far as required to exhaust the
source data (until zeros appear).

Adapt the expression easily to suit:
a. $A$1 is the anchor cell = the top cell in the source range
b. The "10" is the number of cols that you want to fill across
(The above expression is left intentionally unsimplified to show the pattern)

Success? Celebrate it, hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[jerminski73]

I have a customer list of over 300 names that I want to have "hidden" off the
page that autofill into the viewable area based upon the entry being made.
Similar to the normal autofill where I type something and then the next time
I start to type the same things it will autofill.

A1 has the first value down to A311 (Column A is hidden off the viewable
screen thru Freeze pane). When I type in cells D25 thru D50 I want it to
grab the names I already typed in column A. Hope this helps