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

PLEASE HELP
 

Try the macro recorder.

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

PLEASE HELP
 

what's a macro recorder . . thanks again for your time . . .

"JLGWhiz" wrote:

Try the macro recorder.

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

PLEASE HELP
 

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

"MarthaSue" wrote:

what's a macro recorder . . thanks again for your time . . .

"JLGWhiz" wrote:

Try the macro recorder.

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