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

T

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
 
T

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
 
R

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.
Click to expand...

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

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?
 
R

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.
 
Top