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

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

--
Message posted from http://www.ExcelForum.com

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

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"tvtrav " wrote in message ...
Hi,

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

I have two worksheets , Sheet1 is the working copy that is changed
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 Sheet
1 and place it in Sheet 2...After each print.

Can this be done?

Trav.


---
Message posted from http://www.ExcelForum.com/

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

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

--
Message posted from http://www.ExcelForum.com

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

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"tvtrav " wrote in message ...
Ron,

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

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.

Thanks in advance!

Trav.


---
Message posted from http://www.ExcelForum.com/

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

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?


---
Message posted from http://www.ExcelForum.com/

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

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.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tvtrav " wrote in message ...
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?


---
Message posted from http://www.ExcelForum.com/

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

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

It works great!

Thanks for all the help!

Travis

--
Message posted from http://www.ExcelForum.com