VBA Macro

[MarthaSue]

I am looking for a VBA Command for the following situation . . . . 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 . . Please let me know if
you require more information .. . i am a rookie when it come to this sort of
thing . . . thanks for your time . . . . The list is a Data Validation list .
.. it is on the current workbook. . . .The user would click on an action item
from the list . . .The list does not consists of entries from Row 1, the
list is part of Row 1, it would be in Column L . . .please let me know if you
require more information . . .

 

[Otto Moehrbach]

Martha
You have several responses in your earlier thread. Otto

 

[MarthaSue]

Yes i have had other responses but i am still requiring more information, so
i'm trying to post on two locations.

. . .there are about 20 choices in the Data Validation List, not just
the two . . .each choice . . will cause a different event . . should i use
an event macro . . i was reading up on it . . .Columns 1-7 in Row A1 will
contain information that will have to repeat into the next row that is being
inserted . . .each choice can cause a different amount of rows to be
inserted, some choices will require no rows . . . Basically i don't want the
user to have to type in the repeating information (to save time) . . can i
still use the one you gave me and modify it a little . . . i would also like
to note that there is data after the column containing the validation list .
.. .the remaining columns in the row contain dates and formulas based on the
action item choosen as well . . the user enters the date the task was
completed in the next column after the validation list . . and then the
remaining columns are set with formulas to change accordingly (basically due
dates for actions that need to be completed based on the action that is
choosen) . . .can i send you a copy . . it's so hard to explain . . would
make more sense if you could just see it . . .thanks again . . i truly
appreciate all the time you given me . .

 

[MarthaSue]

I would appreciate any help . . in a bit of a panic . . i know isn't
everybody . . .

 

[michael.beckinsale]

Hi Martha,

Deborah Dagleish has plenty of tips / examples on her site with this
sort of thing.

Look under Data Validation

Link:
http://www.contextures.com/tiptech.html

Regards

Michael

 

[MarthaSue]

Thanks Michael . . it is a great site . . i however was unable to find what i
was looking for .. could you please direct me to the area you think might
solve my problem . .

 

[MarthaSue]

. . .there are about 20 choices in the Data Validation List, not just

 

[MarthaSue]

Reposting . . since i've had no responses

.. . .there are about 20 choices in the Data Validation List, not just

 

[michael.beckinsale]

Hi MarthaSue,

As you say its pretty difficult to get a handle on exactly what you
need or want to do but if it can be done with Data Validation then
Deborahs site is the best reference l can suggest.

It seems to me that you probably need to look at:

1) Dependent Dropdowns from a sorted list
2) Under data validation 'Tips & Quirks' look at Data validation
dropdowns & Change events.

Effectively picking a selection in the 1st list will require picking a
selection from a 2nd list, making that selection will trigger an event
(macro) depending on the choice. This macro could be the insertion of
rows.

I do not know what level of Excel / VBA you have but l guess you could
describe the above as being intermediate / advanced.

Hope this helps

Regards

Michael.