filter the data and paste in another workbook
 

I have all the transaction data in a worksheet. Every time i am filtering the
data and copy paste in Journal Template for preparing Jrnl. I am preparing
journals based on the "number of the journal" as specified in the below
example. I want to create a macro for this. I want to paste the data into
different work book - Journal Template.

Can anybody help me for this?

Acct Dept Prod Cust USD Journal
1200 12 88 45 12500 1
1202 15 92 50 13750 1
1204 18 96 55 15125 2
1206 21 100 60 16638 6
1208 24 104 65 18301 5
1210 27 108 70 20131 3
1212 30 112 75 22145 4
1214 33 116 80 24359 1
1216 36 120 85 26795 2
1218 39 124 90 29474 3
1220 42 128 95 32422 4
1222 45 132 100 35664 5
1224 48 136 105 39230 6

filter the data and paste in another workbook
 

Hi Guru Prasath

See
http://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Guru Prasath" <Guru wrote in message ...
I have all the transaction data in a worksheet. Every time i am filtering the
data and copy paste in Journal Template for preparing Jrnl. I am preparing
journals based on the "number of the journal" as specified in the below
example. I want to create a macro for this. I want to paste the data into
different work book - Journal Template.

Can anybody help me for this?

Acct Dept Prod Cust USD Journal
1200 12 88 45 12500 1
1202 15 92 50 13750 1
1204 18 96 55 15125 2
1206 21 100 60 16638 6
1208 24 104 65 18301 5
1210 27 108 70 20131 3
1212 30 112 75 22145 4
1214 33 116 80 24359 1
1216 36 120 85 26795 2
1218 39 124 90 29474 3
1220 42 128 95 32422 4
1222 45 132 100 35664 5
1224 48 136 105 39230 6

filter the data and paste in another workbook
 

Many Thanks Ron



"Ron de Bruin" wrote:

Hi Guru Prasath

See
http://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Guru Prasath" <Guru wrote in message ...
I have all the transaction data in a worksheet. Every time i am filtering the
data and copy paste in Journal Template for preparing Jrnl. I am preparing
journals based on the "number of the journal" as specified in the below
example. I want to create a macro for this. I want to paste the data into
different work book - Journal Template.

Can anybody help me for this?

Acct Dept Prod Cust USD Journal
1200 12 88 45 12500 1
1202 15 92 50 13750 1
1204 18 96 55 15125 2
1206 21 100 60 16638 6
1208 24 104 65 18301 5
1210 27 108 70 20131 3
1212 30 112 75 22145 4
1214 33 116 80 24359 1
1216 36 120 85 26795 2
1218 39 124 90 29474 3
1220 42 128 95 32422 4
1222 45 132 100 35664 5
1224 48 136 105 39230 6