| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summary sheet
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary sheet
No need to start a new thread - look at your previous posting.
Pete On Jul 23, 3:16 pm, thaenn wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary sheet
Sorry Pete, didn't realize the first one went through...Will check previous
posting. "Pete_UK" wrote: No need to start a new thread - look at your previous posting. Pete On Jul 23, 3:16 pm, thaenn wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
summary sheet
As Pete says, see your previous posting for responses.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "thaenn" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| Summary Sheet | Excel Worksheet Functions | |||
| Summary Sheet | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
| Summary sheet | New Users to Excel | |||
Linear Mode
