Copying Data from several Worksheets to One
 

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

--
drvorte
-----------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...fo&userid=1589
View this thread: http://www.excelforum.com/showthread.php?threadid=56533

Copying Data from several Worksheets to One
 

Bump for some help.


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=565332

Copying Data from several Worksheets to One
 

Bump for some help.


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=565332