Hi All,
I need your help to develop a macro for the below problem statement.
In attached excel, sheet 1 is my input. So I have to take data from sheet one and filtered it out in sheet 2. Then copy the filtered result and paste it in new workbook/sheet. Take the 2nd input and do all the filtering and paste it in the next blank row of previously created workbook/sheet. I tried so many ways to achieve it but failed to do so. So far I have completed it till filtering using loops and all and paste data for first input only. Any help is very much appreciated.
Thank You.
I need your help to develop a macro for the below problem statement.
In attached excel, sheet 1 is my input. So I have to take data from sheet one and filtered it out in sheet 2. Then copy the filtered result and paste it in new workbook/sheet. Take the 2nd input and do all the filtering and paste it in the next blank row of previously created workbook/sheet. I tried so many ways to achieve it but failed to do so. So far I have completed it till filtering using loops and all and paste data for first input only. Any help is very much appreciated.
Thank You.