| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to paste data over the hidden rows in a sheet with a filter | Excel Discussion (Misc queries) | |||
| Need to Search Column then Paste Data at end of Row? Advanced Filter? | Excel Programming | |||
| How can i copy and paste data when there is a filter in the worksheet.... | Excel Discussion (Misc queries) | |||
| Selecting data from 1 workbook to copy and paste to a 2nd workbook | Excel Programming | |||
| PLEASE HELP!sorting data using auto filter & paste the results onto seperate sheets? | Excel Programming | |||
Linear Mode
