MAcro to extract rows matching a criteria and paste in another sheet

Hi all

I have an excel that is a ledger of data, i need to be able to extract only specific rows and paste them in another sheet.
For eg, in the below get rid of all italicized text and paste only the rows in bold header a new excel/tab. These Rows can occur anywhere in the excel. Pls help as priority!!


Subledger Accounting Account Analysis Report Report Date 27-Feb-12
LPL Ledger Date From 2012-01-01T00:00:00.000-06:00 Date To 2012-01-31T00:00:00.000-06:00 Page 1 of 1


Ledger / Ledger Set LPL Ledger
Period From 12-Jan
Period To 12-Jan
Accounting Flexfield From 101.0000.511210.0000.000000.000.0000
Accounting Flexfield To 101.9999.511210.9999.ZZZZZZ.999.9999
Balance Type Actual
Encumbrance Type / Budget Name
Include Zero Amount Lines No
Include User Transaction Identifiers No
Include Statistical Amount Lines No
Include Accounts With No Activity No



Subledger Accounting Account Analysis Report Report Date 27-Feb-12
LPL Ledger Date From 2012-01-01T00:00:00.000-06:00 Date To 2012-01-31T00:00:00.000-06:00 Page 1 of 1


Ledger Name LPL Ledger Ledger Currency USD Balance Type Actual


Account 101.1101.511210.0000.000000.000.0000 Description LPL Financial.Corporate.Insured Cash Account.Default.General.Default.Default

Beginning Balance for Period 12-Jan 0 0


Source Category GL Date Event Class Transaction Number Line Description Debit Credit Sponsor Name / Supplier Name Accrual Period Check Account Descrption
STANDARD Bank Statements(1) 31-Jan-12 ICA LPL Fee _Jan 12 11,015,157.52 101.1101.511210.0000.000000.000.0000
STANDARD Reclass 31-Jan-12 Reclass AXA MMKT and ICA fee 748,125.17 101.1101.511210.0000.000000.000.0000
STANDARD Allocation 31-Jan-12 Re-allocate January 10,267,032.35 101.1101.511210.0000.000000.000.0000
Period Total 11,015,157.52 11,015,157.52

Excel 1 after macro execution should result in excel2

works like a charm!!! Thank you very much!

Excel experts

ran into a runtime error...attaching the sample sheet i used...

Kiran

I tried this, however it does not seem to work with the attached sheet...brins.xlsm. It seems to work only for one specific type of format/order of data

pls help

Rgds
Vandana