I am trying to create a simple macro that will copy specific fields from a detail page to a summary page. Each day on the detail page, we will add various revenues, & I want that to be copied to the summary page which will also included monthly totals. On the detail page, I have created a grid that allows for input of the current date, revenues & margins. At the bottom of the page, I have each column totaling the daily entries. Since the monthly totals are update each day, it is simple to have this total to transfer to the summary page, but not the daily. In lotus, I could write a macro that would go to the end of each column, then up to the latest entry & then copy that entry, but I can't get this to work in excel '97. Any help would be appreciated.