So lets say i have an ongoing database in excel, mostly composed of values entered on a daily basis. Now lets say that the daily values are sometimes skipped randomly to the effect that certain days have no values.

I would like to make another worksheet in excel that pools the information from the days that only have values. Does anybody know how to do this? I don't think it can be done outside of writting some code in VBA.



i'm basically trying to eliminate the rows that with blanks while keeping the original database intact.

thanks

8/4/2006 2:47:08 PM

use a filter

[Edited on August 4, 2006 at 3:20 PM. Reason : what are you trying to do with the pooled info?]

8/4/2006 3:17:19 PM

Pivot?

8/4/2006 5:12:07 PM