I have dates (mm/dd/yyyy) running from cell A1 down that column to about A543, those dates all have data that correspond to each day in columns b through x, what i would like to do is to create a macro that go to the last date on column A and update the calcuations on the columns that have caclulations, every time i update the excel sheet i get more data in each column and so i have to go and individually drag and drop the calculations i want to be preformed on the columns up to the new date. How can I automate this task? THank you!!!!!