| 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 |
| 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 | |||
Threaded Mode
