Macro - performing simple calc. on ever-changing data
Posted by Jeff on January 09, 2002 3:44 PM
Hi. I've decided to take the plunge and start using a macro to do some of my daily tasks. I'm importing a daily text report, sorting it to columns, calculating an average on one of the columns and calculating a sum on another. The problem is that the final cells change daily. For example, my average today might include J1:J200, but tomorrow I would need the average for J1:j250. Right now, Excel is just using the cell ranges from the sheet in which I record the macro instead of changing the range to fit the new data.
Thanks a lot,