I am new to VBA and created a user form to enter data in Worksheet.
So as soon as I click on a cell the user form should load with the info from worksheet.
So it's a give and take relation between worksheet and user form.
I get huge data in which we have rating from 1 to 4
I will put the data in Raw sheet and I want that it should automatically filter 1 and 2 ratings rows and copy it in the main sheet
There should be no duplicate in Main sheet.
So everytime I put the data in raw sheet, I want it to filter the new one and add it to Main sheet
In main sheet there is a column named Audits.
I want the userform to start when any row in column Audit has been clicked.
User form should display info like name, I'd, manager, customer number based on the row user has clicked.
Once the form is filled I want Audit column to be as Yes.
Please check attachment
So as soon as I click on a cell the user form should load with the info from worksheet.
So it's a give and take relation between worksheet and user form.
I get huge data in which we have rating from 1 to 4
I will put the data in Raw sheet and I want that it should automatically filter 1 and 2 ratings rows and copy it in the main sheet
There should be no duplicate in Main sheet.
So everytime I put the data in raw sheet, I want it to filter the new one and add it to Main sheet
In main sheet there is a column named Audits.
I want the userform to start when any row in column Audit has been clicked.
User form should display info like name, I'd, manager, customer number based on the row user has clicked.
Once the form is filled I want Audit column to be as Yes.
Please check attachment