Macro for copying data to a new worksheet

[Closed]
Report
Posts
1
Registration date
Monday August 9, 2010
Status
Member
Last seen
August 9, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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