Prev: I have something similar
Next: random selection of rows
From: Bradly on 23 Mar 2010 21:31
I have a spreadsheet of application data for 69 clients; therefore, there are
69 rows plus the top row of column headings. There are 41 columns. The
problem I am having is trying to print just one row of application data at a
time to distribute to our workers. If I filter the list, I see just one row,
but when it prints, it is 5 pages long, and we are trying to reduce our cost
of supplies. I tried to transpose the list, switching the rows and columns,
but I can't figure out how to print the headings and just one column at a
time (i.e. the heading column A + column B, A + C, etc.).

Is there an efficient way to do this?
Thanks.

From: Otto Moehrbach on 23 Mar 2010 21:47
I think the easiest way to do this is to have a macro and a button on the
sheet to run the macro. The macro would operate on the active row. You
would simply click on any cell in the row you want printed, click on the
button, and the macro will print that row in any format you want. If this
sounds like what you want, post back and provide details about the layout of
your data and the layout you want for the print job. HTH Otto

"Bradly" <Bradly(a)discussions.microsoft.com> wrote in message
news:70D992A3-7791-415B-83C0-DEFF2E67A86B(a)microsoft.com...
> I have a spreadsheet of application data for 69 clients; therefore, there
> are
> 69 rows plus the top row of column headings. There are 41 columns. The
> problem I am having is trying to print just one row of application data at
> a
> time to distribute to our workers. If I filter the list, I see just one
> row,
> but when it prints, it is 5 pages long, and we are trying to reduce our
> cost
> of supplies. I tried to transpose the list, switching the rows and
> columns,
> but I can't figure out how to print the headings and just one column at a
> time (i.e. the heading column A + column B, A + C, etc.).
>
> Is there an efficient way to do this?
> Thanks.
>
 | 
Pages: 1
Prev: I have something similar
Next: random selection of rows