| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reomove blanks in list
am using two sheets one with info typed into it and another in reference to
info in the first sheet info is type and some cells left blank in one column second sheet refers back to the info typed need the second sheet to constantly sort out the blanks and move all info to the top of page in the order it was typed my goal is to have the second sheet locked out so no can edit it but it constantly sorts out all the blanks without anyone having to do anything to the second page but print it -- storm.mcdonald |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
reomove blanks in list
If you are not averse to using a mcro something like this should do the
trick... Sub RemoveBlanks() On Error Resume Next Sheets("Sheet1").Columns("A").SpecialCells(xlCellT ypeBlanks).EntireRow.Delete On Error GoTo 0 End Sub -- HTH... Jim Thomlinson "storm.mcdonald" wrote: am using two sheets one with info typed into it and another in reference to info in the first sheet info is type and some cells left blank in one column second sheet refers back to the info typed need the second sheet to constantly sort out the blanks and move all info to the top of page in the order it was typed my goal is to have the second sheet locked out so no can edit it but it constantly sorts out all the blanks without anyone having to do anything to the second page but print it -- storm.mcdonald |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
reomove blanks in list
tried this in vb and it was not able to remove te cells that were blank
-- storm.mcdonald "Jim Thomlinson" wrote: If you are not averse to using a mcro something like this should do the trick... Sub RemoveBlanks() On Error Resume Next Sheets("Sheet1").Columns("A").SpecialCells(xlCellT ypeBlanks).EntireRow.Delete On Error GoTo 0 End Sub -- HTH... Jim Thomlinson "storm.mcdonald" wrote: am using two sheets one with info typed into it and another in reference to info in the first sheet info is type and some cells left blank in one column second sheet refers back to the info typed need the second sheet to constantly sort out the blanks and move all info to the top of page in the order it was typed my goal is to have the second sheet locked out so no can edit it but it constantly sorts out all the blanks without anyone having to do anything to the second page but print it -- storm.mcdonald |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with sorting blanks out of a list | Excel Discussion (Misc queries) | |||
| Condense out blanks in a list | Excel Discussion (Misc queries) | |||
| copy a list and skipping blanks | Excel Worksheet Functions | |||
| How do I sort a list that contains blanks that I want to keep? | Excel Discussion (Misc queries) | |||
| validation list blanks | Excel Worksheet Functions | |||
Linear Mode
