I would like pointing in the right direction as I am not familiar with Excel
apart from normal use. I have experience of Access and VBA in Access just to
give some background.

I want to look up error codes and get the actions that the department needs
to do to correct the errors for audit purposes. so I have

Person_id, list of errors, error count.

I want to lookup the error code in another worksheet where they are listed
with their actions and dynamically add them to x number of rows of course
number of actions depends on person_id x errors.

I get:
ex 1234 has 3 errors
1234 (personid) "fill in sheet data" (action)
1234 "log off correctly"
1234 "send paperwork"
1257 "contact hub"

and so on.

In this example I need to return the rows from a lookup to dynamically fill
in the 3 rows for 1234 and then go to next unused row and fill in action for
1257.

Can this occurr as the user fills in the error codes on input (similar to I
guess an update event in access)or does a macro need to run via a button
separately once all data is filled in.

regards
Peter




--
Kind regards in advance