Dear Team,
I need help in copying data from one sheet to another sheet based on criteria
I have 2 worksheets and user form in my excel file, one is Master sheet and another one is Data sheet and user form is having Copy button
I have morethan 10000 rows in Master sheet and every month we will add more data to this Master sheet, I want to copy specific columns from Master sheet to Data sheet based on condition when i clicked on Copy button
In Master sheet I have more than 10 columns, in that I have Age (Column P), Days (Column S), Status (Column Y) columns. I want to copy where Age>=15 and Days>=365 and Status = Alive then copy columns S.No, Unique ID, Name, Age, Staus, ID to Data Sheet in first 5 columns only.
Whenever new data added to Master sheet, when we click the copy data button, it has to be check with above criteria and copy data to Data sheet. But in data sheet there wont be any duplicate Unique Ids. Whenever I click Copy button append only new Unique IDs with other respective columns
I am attaching sample file for your reference
Thanks in advance
Chava Nalini
Bookmarks