Is it possible to add rows to a range using input form

V

Vanya

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Creating a Search using a combo box and then creating a report. 4
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Define a Range based on Cell Values 2
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Userform to update rows of data 4
Go To a Named Range (2nd posting) 5
Add another value to a named range 0

Top