Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
packing slip
I need to make packing slips from an excel distribution list.
I would like to repeat the header rows on every sheet then copy or print 1 row at a time. Each row equals 1 packing slip's worth of information. I need to either just print 2 each with this configuration or make a separate sheet for every row in the list (including the header info each time of course) thank you -- jami |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
packing slip
If you have not already checked here, you might find some help at this site.
http://office.microsoft.com/en-us/te...CT101172761033 "jamiks" wrote: I need to make packing slips from an excel distribution list. I would like to repeat the header rows on every sheet then copy or print 1 row at a time. Each row equals 1 packing slip's worth of information. I need to either just print 2 each with this configuration or make a separate sheet for every row in the list (including the header info each time of course) thank you -- jami |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
packing slip
Go to Files - Page Setup - Sheet tab. Fill out where it says "Rows to
repeat at top". That is, enter the rows you want repeated at the top of each printed page, for instance 1:1. Then run a looping macro to print each row separately. Something like: Sub PrintRows() Dim TheRng As Range Dim i As Range Set TheRng = Range("A2", Range("A" & Rows.Count).End(xlUp)) For Each i In TheRng Range(Cells(i.Row, 1), Cells(i.Row, 5)).PrintOut Next i End Sub Note that this macro, as written, assumes the headers are in row 1 (the row to be repeated) and the rows you want printed start with row 2. The print range is from Column A to Column E. Change these as needed. HTH Otto "jamiks" wrote in message ... I need to make packing slips from an excel distribution list. I would like to repeat the header rows on every sheet then copy or print 1 row at a time. Each row equals 1 packing slip's worth of information. I need to either just print 2 each with this configuration or make a separate sheet for every row in the list (including the header info each time of course) thank you -- jami |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Packing Slip | Excel Worksheet Functions | |||
how do i make a packing slip with a drop down menu | Excel Worksheet Functions | |||
how do i make a packing slip with a drop down menu | Excel Worksheet Functions | |||
Using Packing Slip Template | Excel Worksheet Functions | |||
Anyone have a simple shipping log or packing slip in Excel? | Setting up and Configuration of Excel |