Dear Sir, please help to resolve the issue.
S sambit Member Apr 27, 2019 #1 Dear Sir, please help to resolve the issue. Attachments Example.xlsx 12.4 KB · Views: 7
Belleke Well-Known Member Apr 27, 2019 #3 Like this? Rename your destination sheets. Attachments Chandoo sample.xlsm 25.6 KB · Views: 10
Marc L Excel Ninja Apr 27, 2019 #4 Using an Excel basics like an advanced filter,« Copy and Paste the data to another sheet with based on condition » just needs a single VBA codeline ‼As you can see in the Chandoo courses, the VBA inner help, the so many samples within this VBA forum !So there is no issue, it's just about learning & using an Excel basics …The advanced filter criteria range needs the header cell above the criteria cellso for example for the Output1 just fill first the header in cell D1 then you can use this single codeline :Sheets(1).[B4].CurrentRegion.AdvancedFilter xlFilterCopy, Sheets(2).[D1:D2], Sheets(2).[C4:F4]Do you like it ? So thanks to click on bottom right Like !
Using an Excel basics like an advanced filter,« Copy and Paste the data to another sheet with based on condition » just needs a single VBA codeline ‼As you can see in the Chandoo courses, the VBA inner help, the so many samples within this VBA forum !So there is no issue, it's just about learning & using an Excel basics …The advanced filter criteria range needs the header cell above the criteria cellso for example for the Output1 just fill first the header in cell D1 then you can use this single codeline :Sheets(1).[B4].CurrentRegion.AdvancedFilter xlFilterCopy, Sheets(2).[D1:D2], Sheets(2).[C4:F4]Do you like it ? So thanks to click on bottom right Like !
S sambit Member May 6, 2019 #5 Belleke Sir, Thanks for the resolve the issue. But some point to be noted given below. While we click on GO Bottom, the data must be the shift to UP and MP Sheet without deleting in Main Datasheet. (i.e, copy paste not cut-paste). Some data may be added in the Main Data sheet later on. After a few data added in the Main data sheet, it must go to UP and MP Sheet. (i.e, like refresh)
Belleke Sir, Thanks for the resolve the issue. But some point to be noted given below. While we click on GO Bottom, the data must be the shift to UP and MP Sheet without deleting in Main Datasheet. (i.e, copy paste not cut-paste). Some data may be added in the Main Data sheet later on. After a few data added in the Main data sheet, it must go to UP and MP Sheet. (i.e, like refresh)