after each print, copy data from sheet 1 to sheet 2

[tvtrav]

Hi,

I'm printing pallet tags for products in a warehouse. I print up t
200 a day.

I have two worksheets , Sheet1 is the working copy that is change
often and then printed, Sheet2 will be a ledger that records that info
each time I print the info in Sheet 1.

If possible, I would like to use a macro to record the data from Shee
1 and place it in Sheet 2...After each print.

Can this be done?

Trav

 

[Ron de Bruin]

Hi

Maybe this will help you to copy the data to
a database sheet after you print
http://www.rondebruin.nl/copy1.htm

Post back if you need help

 

[tvtrav]

Ron,

Thanks!....Great link. I got it to work, but only when I run th
macro (Alt-F8). I've tried to get it to work each time I print, but n
luck. Any Ideas?

Also, how would I get the data that is copied to Sheet2, in a ro
instead of a column. Basically, copy to row B, then Row C, then Ro
D...etc.

Thanks in advance!

Trav

 

[Ron de Bruin]

Hi

The best you can do is add a button on your sheet that print and copy the data
Assign this macro to the button

Sub test()
ActiveSheet.PrintOut
yourcopymacroname
End Sub

Also, how would I get the data that is copied to Sheet2, in a row
instead of a column. Basically, copy to row B, then Row C, then Row
D...etc.

I don't know what you mean with this?
You can find a example on the page for copy a row

 

[tvtrav]

Ron,

I got button to work...Looks great.

I don't blame you for not understanding what I meant regarding the
second part....I screwed up.

I want to get the data that is copied to Sheet2, in a row instead of a
column. Basically, copy to Row 1, then Row 2, then Row 3...etc. Not
coping it to Column A vertically, copy it to Row 1 Horizontally...Does
this make sense?

 

[Ron de Bruin]

You can use the second Macro of each example (Paste Special)

Read this text on the page

2 :The second one use PasteSpecial to copy only the values.
See help for more information about the options for PasteSpecial.
The PasteSpecial macro's can also be used to transpose the range that you copy,
change the last argument to True if you want that.

 

[tvtrav]

Ron....You're the Man!!

It works great!

Thanks for all the help!

Travis