Solved: Print Data into Form

[parttime_guy]

Hi Guz-n-Galz,

Picture This - Data in Rows (Sheet1) - Format/Form (Sheet2)

What would be the best approach to print all data that are in rows (Sheet1) into the Format/Form (Sheet2) - one after another till all existing rows are complete.

Anything would be acceptable - views/ideas/formats/links.

Thx-n-BR

[parttime_guy]

Hi Everybody,

After searching the net and mixing code together I have tried to solve the printing Form query, but I have hit another

The code works fine if the header is in the first row and the data follows.

But...

How do I change the code if the heading is in row 6 data starts from row 7 ???

Can anybody help me to amend the code below.

[VBA]Public Sub ProcessData()
Dim LastRow As Long
Dim i As Long
With Worksheets("Master")
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = 2 To LastRow
Sheets("Summary").Select
Worksheets("Summary").PrintOut
.Rows(2).Copy .Rows(LastRow + 1)
.Rows(3).Resize(LastRow - 2).Copy .Range("A2")
.Rows(LastRow).Delete
Next i
End With
MsgBox "Finished Processing"
End Sub
[/VBA]

Thx-n-BR

[Aussiebear]

Try changing the line
[VBA]For i = 2 to LastRow[/VBA]
to
[VBA]For i = 7 to LastRow [/VBA]
and see what happens

[parttime_guy]

I tried doing that...

The code runs ok for the first time

But...

The information in the Master flap automatically changes - and goes for a toss.

Kindly view file.

Thx-n-BR

[Kenneth Hobs]

I don't have time to test this right now.

[VBA]Public Sub ProcessData()
Dim LastRow As Long, startDataRow As Long
Dim i As Long

With Worksheets("Master")
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
startDataRow = Range("A" & Rows.Count).End(xlUp).Row
startDataRow = Range("A" & startDataRow).End(xlUp).Row - 1
If startDataRow > LastRow Then Exit Sub

For i = startDataRow To LastRow

Sheets("Summary").Select

Worksheets("Summary").PrintOut
.Rows(startDataRow).Copy .Rows(LastRow + 1)
.Rows(startDataRow + 1).Resize(LastRow - startDataRow).Copy .Range("A" & startDataRow)
.Rows(LastRow).Delete
Next i
End With

MsgBox "Finished Processing"

End Sub[/VBA]

A better approach might be to use the method that John Walkenbach used in his ElephantsRus. He used Indirect() to fill the form cells based on a row cell. To print, you then just iterate the rows from the start row to the end row.

[parttime_guy]

Thx Kenneth for ur reply - it works like a charm (...except there are 2 extra pages that get printed - but I'll live with that).

But the data in in the Master file remains intact that's what really matters.

I have downloaded John Walkenbach "ElephantsRus" will take a look at it.



Best regards