M Mr.Karr Member Apr 7, 2015 #1 Hello Can anyone please help provide a code snippet to filter data from sheets and paste in another sheet. In detail: I have 5 sheets where I need to filter by criteria if "New/modified/Deleted" and paste them in another sheet. Please help. Many thanks in advance Karthik Attachments Sample file.xlsx 25.8 KB · Views: 0
Hello Can anyone please help provide a code snippet to filter data from sheets and paste in another sheet. In detail: I have 5 sheets where I need to filter by criteria if "New/modified/Deleted" and paste them in another sheet. Please help. Many thanks in advance Karthik
MaunishP Member Apr 7, 2015 #2 Hi Karthik, Do you want compile all data into Consolidated sheet? If filtering by than what do you want to filter and compile data ? Regards, Maunish Patel
Hi Karthik, Do you want compile all data into Consolidated sheet? If filtering by than what do you want to filter and compile data ? Regards, Maunish Patel
M Mr.Karr Member Apr 7, 2015 #3 MaunishP said: Hi Karthik, Do you want compile all data into Consolidated sheet? If filtering by than what do you want to filter and compile data ? Regards, Maunish Patel Click to expand... Hi @MaunishP : yes, I would like to see the filtered data in "Consolidated" sheet. Filter by criteria if "New/modified/Deleted" which is avaiable at last column. Hope this helps
MaunishP said: Hi Karthik, Do you want compile all data into Consolidated sheet? If filtering by than what do you want to filter and compile data ? Regards, Maunish Patel Click to expand... Hi @MaunishP : yes, I would like to see the filtered data in "Consolidated" sheet. Filter by criteria if "New/modified/Deleted" which is avaiable at last column. Hope this helps
M Mr.Karr Member Apr 7, 2015 #4 @Ninjas, Please look into this & see if you can help. Much appreciated
