| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to add rows to a range using input form
I have a named data range that is referenced in other worksheets within a
workbook. The master list of data needs to be expandable for the user which means that I need to have the data range expand as the user adds rows to the data range through an input form. Is this possible? The user is not computer knowledgeable. It would be ideal to have the user be able to add or remove data from the range of master data resulting in the size of the range adjusting AND automatically "re-sorting" according to original set criteria, which is simple (Text - A-Z in one of the 7 columns) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to add rows to a range using input form
You can create a dynamic named range using OFFSET() and COUNTA(). Check out
the below article http://support.microsoft.com/kb/830287 If this post helps click Yes --------------- Jacob Skaria "Vanya" wrote: I have a named data range that is referenced in other worksheets within a workbook. The master list of data needs to be expandable for the user which means that I need to have the data range expand as the user adds rows to the data range through an input form. Is this possible? The user is not computer knowledgeable. It would be ideal to have the user be able to add or remove data from the range of master data resulting in the size of the range adjusting AND automatically "re-sorting" according to original set criteria, which is simple (Text - A-Z in one of the 7 columns) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| First Input on a Form | Excel Worksheet Functions | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
| Input Form vba help | Excel Discussion (Misc queries) | |||
Linear Mode
