Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003-eliminate blank rows in target worksheet using =IF
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003-additional code using =IF
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003-additional code using =IF
You say "code".
All I see in your original post is a formula which presumably is entered somewhere on a target sheet. You cannot delete blank rows based on a formula. I an confused by your description of what you want. You can delete blank rows using VBA or simply using F5SpecialBlanksOK EditDeleteEntire Row Gord Dibben MS Excel MVP 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. On Sat, 12 Jan 2008 12:56:01 -0800, Rich D wrote: Not getting any response... I need additional code to eliminate the blank rows when I move data to another worksheet based on IF statement. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003-additional code using =IF
Sorry, I'm new to all this jargon. I think what I'm looking for is code as
there are a lot of blank rows to deal with. -- Rich D Armstrong Custom Homes Redmond "Gord Dibben" wrote: You say "code". All I see in your original post is a formula which presumably is entered somewhere on a target sheet. You cannot delete blank rows based on a formula. I an confused by your description of what you want. You can delete blank rows using VBA or simply using F5SpecialBlanksOK EditDeleteEntire Row Gord Dibben MS Excel MVP 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. On Sat, 12 Jan 2008 12:56:01 -0800, Rich D wrote: Not getting any response... I need additional code to eliminate the blank rows when I move data to another worksheet based on IF statement. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003-eliminating blank rows in target worksheet | Excel Discussion (Misc queries) | |||
Excel (Eliminate blank rows) | Excel Worksheet Functions | |||
How to eliminate empty rows in Excel 2002 worksheet ? | Excel Discussion (Misc queries) | |||
How do I specify an end to a worksheet to eliminate empty rows? | Excel Discussion (Misc queries) | |||
program excel worksheet to automatically not print blank rows | Excel Worksheet Functions |