About Us

Guru Prasath[_2_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to paste data over the hidden rows in a sheet with a filter	hezemeftez	Excel Discussion (Misc queries)	2	August 2nd 06 03:29 PM
Need to Search Column then Paste Data at end of Row? Advanced Filter?	[email protected]	Excel Programming	1	May 13th 06 12:11 AM
How can i copy and paste data when there is a filter in the worksheet....	dalipsinghbisht	Excel Discussion (Misc queries)	5	March 18th 06 12:38 PM
Selecting data from 1 workbook to copy and paste to a 2nd workbook	JackSpam	Excel Programming	2	July 20th 05 02:33 AM
PLEASE HELP!sorting data using auto filter & paste the results onto seperate sheets?	Jay3	Excel Programming	1	November 12th 04 09:36 AM

Menu

About Us