Automatic transfer of row info to another worksheet
KC's code should not leave any blank rows in Vendor's List.
First Master sheet c.row with an "x" will be in row 2 of Vendor's List
The rest will be in contiguous rows from there down.
BTW..............I added the missing paren in this line.
Range(Cells(c.Row, "B"), Cells(c.Row, "H")).Copy
Also add this line just before End Sub
Application.CutCopyMode = False
Gord Dibben MS Excel MVP
On Tue, 26 May 2009 14:26:52 +0100, Jack Wood
wrote:
Worked good for transferring the information from the Master List
Worksheet to the Vendor List worksheet, but now the Vendor List
worksheet displays blank rows where a vendor was not selected from the
Master List. How can I get the Vendor List not to display blank rows.
|