Hi everyone! I'm very new to most Excel functions and 1000% new to macros. Please keep this in mind when answering and make things as fool-proof as possible. ;)

I receive an Excel spreadsheet every week which is continously being updated with new data. I perform a few simple calculations, pull out some averages, and put everything on a lovely chart to prove we're doing well as a department. The more data we add, the longer this process takes, the more mistakes happen, and the more I really really want to learn how to create macros. So far, I've created a practice workbook, created a few lines of code with the Record Macro feature, and everything has worked out. However, next week... it won't... b/c I will have more data in my spreadsheet and so my ranges will be off, true?

I read about The Do...Loop function and using the While condition. I think it would be best to tell Excel to Do mymacro While cells in my column do not equal a blank cell.

Do While cells(x,1).value<>""

Is there an easy way to edit the macros I have already recorded and add the Do Loop function?

If so, many many more questions will follow!

:)

Thanks for your help!