I have an ongoing project in Excel. I take a monthly report and combine it into a new column on a sheet with previous months data. Only problem is the new report has fewer entries than that of the previous months and in order to combine them properly and make sure data is intact in the proper rows and column, I have to manually go through and compare the new sheet (sheet1) with the existing sheet (Monthly) and move each enter from column DQ (ISO Profit) on sheet1 into a new column in the Monthly sheet into the proper rows. For this months report if I copy column DQ over to the Monthly sheet it is 49 rows less data than the previous months. I am attaching the workbook for you. So I was wondering if there was a way to automate this moving the data from column DQ in Sheet1 and put the data into the proper matching row in a new column in the Monthly sheet. Thank you in advance for your taking a look at this.