Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to autofill from 300+ names
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to autofill from 300+ names
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "jerminski73" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to autofill from 300+ names
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" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to autofill from 300+ names
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Autofill Worksheet names | Setting up and Configuration of Excel | |||
Autofill Sheet names? | Excel Discussion (Misc queries) |