Hey Guys/Girls,

I'm trying to create a Macro that takes weekly data for a months tim
frame and creates averages for trend tracking. The end result would b
a graph for a visual presentation. The macro is almost complete
however, the macro I made has to adjust for future month "structures
(i.e. 4 or 5 weeks in a month). The macro built was based on a 5 wee
month, yet when I run the macro with a 4 weeks worth of data it get'
caught up on the 5th week because it's blank.

Is there a way to say if worksheet "x" is blank skip the followin
steps in the macro. The work sheet with data has been included and th
run funtion is (Ctrl+ E).

'Link' (http://www.iamhetero.com/fun/Monthly Average.xls)

Also, is there a way when copying information after it's bee
subtotalled to pasted it without the hidden information?

Thanks for all your help,

Kevi

--
Message posted from http://www.ExcelForum.com