D
drvortex
Ok. I"m going to try and re-explain this. I haven't gotten much hel
so far and not familiar w/ the programming aspect of Excel. Anyways
here we go.
1. I have 31 identical sheets in a workbook representing Days of th
month.
2. Each cell is filled w/ the same type of data but not value.
3. I would like to take all the data and put into ONE master sheet.
4. However, I only want to copy the cells that contains data and leav
the blank cells alone.
For example, cells B5:M5 are temperatures. I would like to take AL
filled in cells from B5:M5 and copy to another worksheet. If the cel
is blank or doesn't contain a numeric value I would like to skip it.
Therefore, I can do my bias calculations from the compiled dataset o
the new worksheet.
Hope this is better explained. This is only for temperatures so I wil
be doing this for many other parameters. Thanks for your help.
Jaso
so far and not familiar w/ the programming aspect of Excel. Anyways
here we go.
1. I have 31 identical sheets in a workbook representing Days of th
month.
2. Each cell is filled w/ the same type of data but not value.
3. I would like to take all the data and put into ONE master sheet.
4. However, I only want to copy the cells that contains data and leav
the blank cells alone.
For example, cells B5:M5 are temperatures. I would like to take AL
filled in cells from B5:M5 and copy to another worksheet. If the cel
is blank or doesn't contain a numeric value I would like to skip it.
Therefore, I can do my bias calculations from the compiled dataset o
the new worksheet.
Hope this is better explained. This is only for temperatures so I wil
be doing this for many other parameters. Thanks for your help.
Jaso