Thread: after each print, copy data from sheet 1 to sheet 2
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
tvtrav[_2_] tvtrav[_2_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote