Macro for copying data to a new worksheet

Closed
johnsource Posts 1 Registration date Monday August 9, 2010 Status Member Last seen August 9, 2010 - Aug 9, 2010 at 12:49 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 9, 2010 at 02:20 PM
Hello,

I need a Macro to copy data to a new worksheet the condition is IF any data is same in "F"column then the entire subsequent rows should be copied into new worksheet also all the sheets should contain the same headings in the masterfile.


I am placing a example:


A B C D E F

Deal Nos Rated Issuer t Issue core ID Issuer


Abbey National Treasury Services plc
865857 Rated -- N 26-Mar-10 Abbey National Treasury Services plc
862877 Rated N 11-Mar-10 Abbey National Treasury Services plc
858825 N 9-Mar-10 Acea SpA


over here first 3 records are matching through Issuer name in column "F" so the entire rows should be copied to new worksheet(New Excel workbook and not only sheets in one workbook) and the name of the sheet should be the Issuers name.




1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 9, 2010 at 02:20 PM
Hard to see your sample data here

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0