VBA or Function Required . . .

[MarthaSue]

I want a user to be able to chose from a list of task to be completed . . .ie
Sample, Inspect, Mix. . .when the user choses a task a different action needs
to be completed . . i want EXCEL to insert another row and allow data to be
entered . .. . i am able to email a copy of the spreadsheet if needed . ..is
it possible that when a user choses an action from that list that rows can be
inserted and new data entered . . If User chooses "Sample" . .from the list
in Row 1 . . . can i create a function that will insert one row when Sample
is chosen (Insert Row 2) . . but if User chooses Inspect . . .from the list
in Row 1 . . .can the "function" insert three row (Insert Row 2, 3, & 4) . .
..Currently Row 1 contains several columns of data describing a particular
location and the work that has been currently completed on the site . .one
location can be used once or can be used multiple times. . . . each location
is unique . .none the same . . .i want to be able to not have to write all
the info. over and over again . . . Row 2 would contain several columns of
information for a new location . . .i would like to create a function that
would allow the user to enter more data on location in Row 1 if need be .
..dependant on the work that might have to be completed . . .Sample, Inspect,
Mix . . . Is this possible . . please let me know if you require more
information . . Once again i appreciate your time . .

 

[David]

Inserting a row is not difficult, but it sounds like you want to insert a
different number of rows depending on the task. Then the questions becomes
are you on the row where you want to insert a row(s) or will they(it) be
below where you are located?

Using a "Case" for the choice might be the way to go, depending on the
number of Cases you have. I think you will have to be more specific, if you
want code. Exactly how many Cases do you have and how many rows do you want
in each and every case?

David

 

[MarthaSue]

Hi David . . i appreciate the help . . i want to insert a row below the row
that data is being entered. . . the workbook is going to be used as a
tracking sheet . . each row will have a different location on it . . .when
the location is initially entered on the sheet the user will choose what the
next action will be . . .when they do so another row will be inserted under
the location with same information as the first row . .only thing really
changing is the next action . . .i want this to continue to happen until
there is no longer any work left to do on the location . . could be a one
time site . . a user could return to the site more than 10 times. . .is this
possible . . .

I would aslo eventually like to make the worksheet protected so that the
formulas can't be deleted . . but i would like the user to be able to query
locations . . would that still be possible . . once again thanks for your
time . . .