I have Win Vista and Office 2010. I have an Excel Workbook that has several worksheets. These worksheets have several cells that are linked to each other. I have one cell that needs to be YTD. The operator of this worksheet "zeros" out the main data at the end of each month. New data is entered in the new month, but the YTD data is wiped out because it is linked to the previous months worksheet. I know I can copy, Paste Special and Paste Values. This saves the YTD number and can be carried forward to the next month.
I would like to be able to have this Copy, Paste Special, Paste Values to be performed automatically. Can you tell me how I can do this?
I would like to be able to have this Copy, Paste Special, Paste Values to be performed automatically. Can you tell me how I can do this?