Excel Data Alignment and Cleaning Macro

Excel Cleaning Tool The scope is to "align" an incomplete set of data with a complete set and fill in missing data following a set of rules. The input data is minute by minute historical trading records, which contain gaps when compared to a file containing all minutes in the same period. The attached "Sample" is a short version where I have tried to explain what I am looking for. The criteria to fix the input will then be as follows: 1. A date and minute in the Input not in the Template shall be removed. 2. Missing minutes (rows) at the end or beginning of the Input shall be created with the last and first respectively "Quote" value appearing. 3. Gaps in the minutes (rows) in the Input compared with the Template shall be created with the average between the last and the first Quote making the gap. The attached "Import 20" is an example of an actual workbook that shall be processed by the macro. The results (values only) shall be placed in the "Output" sheet with "Quote" in column A and "Record#" in column B starting in row 1 (without column titles). Note: the Quote shall be rounded to a whole number (values only). Additional info -The name and content of the workbook will be different for each time I will run the macro. -I will be running the macro on a Mac with Excel ver.16.111.3 - Can I have a clickable "button" in the Output sheet to run the macro? ...and a popup message when finished.