Ok..I have 10 rows and 31 columns(represents a month), each column is totalled as is each row. I would like the total at the end of the month(last column)to be transfered to wksheet 2 to the corresponding months column.
How does it know what month and how can the data remain when entering the next months data.
How does it know what month and how can the data remain when entering the next months data.