Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill in Database problem
Hi All,
I have an Excel database with data entry user form. In the database there are 12 columns. One of fields is multiline and can be entered with1 to 15 database rows, while the rest of the fields are singleline. I am asking if someone can please tell me how to autofill each entry the data for the rest of the lines. i have problem to define the varied range in the autofill function. Thanks in advance Eli |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill in Database problem
I have found this handy doing filldowns in one column to the last row of
another column: Range("B2", Range("A2").End(xlDown)).Offset(0, 1).FillDown In this case, I have headers, so I start from row 2. Column A has the data rows that I want to filldown to in column B. If column A has data to row 20, and the word "Hello" is in B2, then the code will fill "Hello" down to B20. Mike F "???" wrote in message ... Hi All, I have an Excel database with data entry user form. In the database there are 12 columns. One of fields is multiline and can be entered with1 to 15 database rows, while the rest of the fields are singleline. I am asking if someone can please tell me how to autofill each entry the data for the rest of the lines. i have problem to define the varied range in the autofill function. Thanks in advance Eli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database autofill | Excel Worksheet Functions | |||
Autofill Problem | Excel Discussion (Misc queries) | |||
Autofill problem | Excel Discussion (Misc queries) | |||
Autofill to last row in a database | Excel Discussion (Misc queries) | |||
Database-Query and AutoFill?????? | Excel Discussion (Misc queries) |