PLEASE HELP!!

M

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

JLGWhiz

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

MarthaSue

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

MarthaSue

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

Gord Dibben

The selecting of a task from a list is quite simple using Data
Validation>Allow>List.

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

 
M

MarthaSue

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

MarthaSue

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

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

Top