Hello everyone and thanks ahead for your help! I am using Excel 2016 and in my spreadsheet, in column A starting in cell A1 I have sorted numbers from 1 to 1000, no duplicates and no blank cells and no data beyond last number. There are however missing numbers. I would like Excel to when I press an activate combo keys to find those missing numbers and paste them in Column C starting in cell C1. I had this macro or code, I think, many years ago using Excel 2000 but it has long since been lost to me and I would like to use again. Thanks again for you help. Johnny1r
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
