Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CREATING LABELS FROM 1 RANGE OF DATA
I have a data range like the one here but with hundreds of columns and rows
and I would like to be able to print the relevant items for each person onto a label so they can be order picked and packed for that person and the their label stuck on their clothing bag something like below, P Smith J Jones C Henderson Polo shirt 2 lge 3 medium 3 small sweatshirt 1 lge 5 medium 4 small boots size 10 size 8 trousers 32 regular 36 short 40 tall P SMITH Polo Shirt 2 lge Sweatshirt 1 lge boots size 10 trousers 32 regular |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CREATING LABELS FROM 1 RANGE OF DATA
Hide all columns but the first column and the column you want to print, then
print, go to the next column and repeat. -- Regards, Tom Ogilvy "John Boland" <John wrote in message ... I have a data range like the one here but with hundreds of columns and rows and I would like to be able to print the relevant items for each person onto a label so they can be order picked and packed for that person and the their label stuck on their clothing bag something like below, P Smith J Jones C Henderson Polo shirt 2 lge 3 medium 3 small sweatshirt 1 lge 5 medium 4 small boots size 10 size 8 trousers 32 regular 36 short 40 tall P SMITH Polo Shirt 2 lge Sweatshirt 1 lge boots size 10 trousers 32 regular |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CREATING LABELS FROM 1 RANGE OF DATA
Which you can easily do in a macro such as
Sub PrintSelected() Dim rng As Range On Error Resume Next Set rng = Application.InputBox("Select the column to print", Type:=8) On Error GoTo 0 If Not rng Is Nothing Then Columns("B:AZ").Hidden = True rng.EntireColumn.Hidden = False ActiveSheet.PrintPreview Columns("B:AZ").Hidden = False End If End Sub You just select the cell with the name you want to print when prompted, and then the macro takes care of hiding and unhiding. -- HTH RP (remove nothere from the email address if mailing direct) "Tom Ogilvy" wrote in message ... Hide all columns but the first column and the column you want to print, then print, go to the next column and repeat. -- Regards, Tom Ogilvy "John Boland" <John wrote in message ... I have a data range like the one here but with hundreds of columns and rows and I would like to be able to print the relevant items for each person onto a label so they can be order picked and packed for that person and the their label stuck on their clothing bag something like below, P Smith J Jones C Henderson Polo shirt 2 lge 3 medium 3 small sweatshirt 1 lge 5 medium 4 small boots size 10 size 8 trousers 32 regular 36 short 40 tall P SMITH Polo Shirt 2 lge Sweatshirt 1 lge boots size 10 trousers 32 regular |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Linked Data Labels Adapt for an Expanded Range | Charts and Charting in Excel | |||
insert data labels from range not used in chart | Charts and Charting in Excel | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Excel charts should let me select a range for data labels. | Charts and Charting in Excel | |||
Is there a way of attaching data labels from a text range to dat. | Charts and Charting in Excel |