filter the data and paste in another workbook

G

Guru Prasath

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Only Display records before and after a change in teh value of a f 4
Repayment Schedule for Loan 0
Help with this challenging VBA coding 3
Outlook connector crashes outlook 0
Outlook crashes with Outlook connector 2002 0

Top