Sheet1 contains the results of worksheets on a daily basis. Sheet 1 cell A1 contains today' date and cells A7:I7 contain the daily results. This sheet will be cleared and rerun daily. My goal is to use a macro to capture this daily summary data and insert it by date into a summary sheet. The summary sheet should start with row 2 to allow for headers with the first date in A2 to start with the additional data in columns B:J row 2. Each day and only once per day the results will be copied from sheet 1 and inserted into the summary sheet. Each subsequent day will be placed under the previous day. If the date already exists in Column A, end macro. If the date does not exist in Column A copy date from Sheet1 cell A1 and values from Sheet1 cells A7:I7 and paste into the Summary Sheet. dates will not always be the next day since this will probably not be done during weekends. Results will be cleared from sheet1 and will be rerun the next workday with hew results to paste to the summary sheet. The summary sheet will allow me to see the trend by workday recorded in the summary sheet
Bookmarks