PLEASE HELP!!
 

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 . . .

PLEASE HELP!!
 

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 . . .

PLEASE HELP!!
 

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 . . .

PLEASE HELP!!
 

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 . . .

PLEASE HELP!!
 

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 . . .

PLEASE HELP!!
 

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 . . .

PLEASE HELP!!
 

I am looking for direction for what command to use in VBA . . thanks again . .

"MarthaSue" wrote:

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 . . .

PLEASE HELP!!
 

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 . .
"MarthaSue" wrote:

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 . . .