I have limited VBA knowledge but willing to learn!
I have a nominal ledger download that lists the following in columns A + B (along with lots of other data in columns C to P which will need to be copied but will not be a driver), what I would like to do is to use VBA to run through the data and copy the rows each time that column A has the text "Ledger account" for all rows until "ledger account" appears again and paste to a new sheet for each ledger code.
Date Voucher
Ledger account 71110
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/12/2010 1DGL000415
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000746
28/02/2011 1DGL000957
28/02/2011 1DGL000957
28/02/2011 1DGL000957
28/02/2011 1DGL000957
Ledger account 71110
Ledger account 71170
12/11/2010 1DGL000160
30/11/2010 1DAJ000002
04/01/2011 1DGL000579
31/01/2011 1DGL000657
Ledger account 71170
Ledger account 71210
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000746
28/02/2011 1DGL000957
28/02/2011 1DGL000957
Ledger account 71210
I have a nominal ledger download that lists the following in columns A + B (along with lots of other data in columns C to P which will need to be copied but will not be a driver), what I would like to do is to use VBA to run through the data and copy the rows each time that column A has the text "Ledger account" for all rows until "ledger account" appears again and paste to a new sheet for each ledger code.
Date Voucher
Ledger account 71110
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/12/2010 1DGL000415
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000746
28/02/2011 1DGL000957
28/02/2011 1DGL000957
28/02/2011 1DGL000957
28/02/2011 1DGL000957
Ledger account 71110
Ledger account 71170
12/11/2010 1DGL000160
30/11/2010 1DAJ000002
04/01/2011 1DGL000579
31/01/2011 1DGL000657
Ledger account 71170
Ledger account 71210
31/12/2010 1DGL000411
31/12/2010 1DGL000411
31/01/2011 1DGL000707
31/01/2011 1DGL000707
31/01/2011 1DGL000746
28/02/2011 1DGL000957
28/02/2011 1DGL000957
Ledger account 71210