Not getting any response... I need additional code to eliminate the blank
rows when I move data to another worksheet based on IF statement.
--
Rich D
Armstrong Custom Homes
Redmond


"Rich D" wrote:

I have a Change Order Ledger worksheet with change Orders pertaining to
different jobs. Using =IF('[Change Order
Ledger.xls]Ledger'!$K$4="","",IF('[Change Order
Ledger.xls]Ledger'!$B4=Profile!$D$4,'[Change Order
Ledger.xls]Ledger'!$B4,"")) to move information into a worksheet specific to
that job (Profile$D$4), it is a straight row to row transfer, leaving blank
rows in my target worksheet. How can I put those rows relevant to the
specific job in Rows 1,2,3, etc removing the balnk rows? Help is
appreciated. Thanks.
--
Rich D
Armstrong Custom Homes
Redmond