move data from a master sheet to multiple tag sheets for printing

[steve400243]

Hello, I'm trying to create an easy way to move data from a master sheet "CFS Sheet", to printable freight tags. There can be as many as 25 HBL rows of data to move to 25 different tags. Please see my example attached, and let me know if you need more information as i may not have explained it good enough. Can this be done aeasily?

Thanks for any and all help!!

 

[Nebu]

Hi:
The following macro will loop through all the HBL# and printout the Freight tags.

Sub test()
For i& = 11 To Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
With Sheet2
.Range("A7") = Sheet1.Range("A" & i)
.Range("D7") = Sheet1.Range("C" & i)
.Range("G7") = Sheet1.Range("D" & i)
.Range("A10") = Sheet1.Range("E" & i)
.Range("D10") = Sheet1.Range("F" & i)
.Range("G10") = Sheet1.Range("B" & i)
'Change Printprview to Print for printing Out
.Range("A1:I20").PrintPreview
End With

Next

End Sub

Note: You will have to change the code line
.Range("A1:I20").PrintPreview
to
.Range("A1:I20").Print
to get the printouts.

Thanks

 

[steve400243]

You are a great help Nebu, Works great! Thank you again.

 

[steve400243]

Hi Again Nubu, I'm getting an "object doesn't support this property or method" error after changing from print preview?

 

[Nebu]

Sorry my bad it should be Printout not print.

 

[steve400243]

Works just like I needed it to! Thanks.