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 . . please let me know if this is possible . . i am able to email a
copy of the spreadsheet if needed . . .Thanks in advance for your time . . .

Yes, it is possible. However, the information you are providing is not
specific enough to develop any code that would be meaningful. Specifications
that are ambiguous are often ignored in the news group.

"MarthaSue" wrote:

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 . . please let me know if this is possible . . i am able to email a
copy of the spreadsheet if needed . . .Thanks in advance for your time . . .

Could you please let me know what information you are requiring, as i am not
trying to be ambiguous . . thanks i appreciate your time . .

"JLGWhiz" wrote:

Yes, it is possible. However, the information you are providing is not
specific enough to develop any code that would be meaningful. Specifications
that are ambiguous are often ignored in the news group.

"MarthaSue" wrote:

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 . . please let me know if this is possible . . i am able to email a
copy of the spreadsheet if needed . . .Thanks in advance for your time . . .

Could you please direct me to another post on this site that I could look at
.. . i am unfamiliar with the correct terminology . . thanks

"JLGWhiz" wrote:

Yes, it is possible. However, the information you are providing is not
specific enough to develop any code that would be meaningful. Specifications
that are ambiguous are often ignored in the news group.

"MarthaSue" wrote:

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 . . please let me know if this is possible . . i am able to email a
copy of the spreadsheet if needed . . .Thanks in advance for your time . . .

The selecting of a task from a list is quite simple using Data
ValidationAllowList.

The second part about "a different action needs to be completed" is also quite
easy using functions or VBA.

The part about "Insert a row and allow data to be entered" is the point where
you must supply more information.

Insert a row where?

What data to be entered and how? Manually by user or automatically by functions
or VBA code?


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 12:59:03 -0800, MarthaSue
wrote:

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 . . please let me know if this is possible . . i am able to email a
copy of the spreadsheet if needed . . .Thanks in advance for your time . . .

Hi Gord . . i appreciate the reply . . i have my list working already . . .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 . .

"Gord Dibben" wrote:

The selecting of a task from a list is quite simple using Data
ValidationAllowList.

The second part about "a different action needs to be completed" is also quite
easy using functions or VBA.

The part about "Insert a row and allow data to be entered" is the point where
you must supply more information.

Insert a row where?

What data to be entered and how? Manually by user or automatically by functions
or VBA code?


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 12:59:03 -0800, MarthaSue
wrote:

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 . . please let me know if this is possible . . i am able to email a
copy of the spreadsheet if needed . . .Thanks in advance for your time . . .