On my main work sheet I will be entering various levels of information.
After the information is entered, it automatically transfers over to a
"Summary" sheet. There are times when specific levels of data will not be
entered on the main sheet. In this case the "Summary" sheet displays a blank
cell. Is there any way for it move the next level of data up so that when
the summary sheet is opened/printed, it only shows the data and eliminates
the blanks? Thank for your help!
thaenn