Hi There, I have a excel sheet which is a report, which I run in a SAP application. Now I have so many fields, below is the example of the report:
User_iD Action Info_type Sub_Info_Type Date_of_Action
12345 Start 1 4 20/09/2010
ABCDE Start 1 5 21/09/2010
12345 Start 1 4 20/09/2010
12345 Start 1 6 21/09/2010
12345 Start 1 4 20/09/2010
12345 Start 1 4 20/09/2010
So in the above table we have User_id,Action, Info_type,Sub_I nfo_Type,Date_o f_Action. When I run a macro, a form should PoP up having four text box that is : User id,Info_type,Su b_Info_Type and Date_of_Action.
When I enter the below data in the form in relevant text box as:
User_id: 12345
Info_type: 1
Sub_Info_type:4
Date_of_Action : 20/09/2010.
And a command button at the below as Ok. When I click Ok
It should give only the records where all the four fields are matching. How do I do this. Point to be noted is we can not link the excel sheet to access database because everytime the report is pulled it gets saved in different names. can we do this in excel or Access. Some help please
User_iD Action Info_type Sub_Info_Type Date_of_Action
12345 Start 1 4 20/09/2010
ABCDE Start 1 5 21/09/2010
12345 Start 1 4 20/09/2010
12345 Start 1 6 21/09/2010
12345 Start 1 4 20/09/2010
12345 Start 1 4 20/09/2010
So in the above table we have User_id,Action, Info_type,Sub_I nfo_Type,Date_o f_Action. When I run a macro, a form should PoP up having four text box that is : User id,Info_type,Su b_Info_Type and Date_of_Action.
When I enter the below data in the form in relevant text box as:
User_id: 12345
Info_type: 1
Sub_Info_type:4
Date_of_Action : 20/09/2010.
And a command button at the below as Ok. When I click Ok
It should give only the records where all the four fields are matching. How do I do this. Point to be noted is we can not link the excel sheet to access database because everytime the report is pulled it gets saved in different names. can we do this in excel or Access. Some help please