| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003-eliminating blank rows in target worksheet
I am moving some data from Worksheet 1 to Worksheet 2 based on 1 criteria.
So far it is a 1 to 1 transfer. However, if a row doesn't meet the criteria, a blank row results on the Worksheet 2. How can I eliminate the blank row on Worksheet 2? The formula I am using is: =if(Worksheet1!$A5="","",Worksheet!C5). I am putting this in Worksheet 2 and copying down. Thanks for your usual good help. -- Rich D Armstrong Custom Homes Redmond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Eliminating Blank Rows | Excel Discussion (Misc queries) | |||
| Eliminating rows in Excel worksheet | Excel Worksheet Functions | |||
| program excel worksheet to automatically not print blank rows | Excel Discussion (Misc queries) | |||
| program excel worksheet to automatically not print blank rows | Excel Worksheet Functions | |||
Linear Mode
