 <p>You can record a macro as you do it manually one time. Then assign that macro to a button. Then click the button anytime you need the sheet updated.</p> <p>Steps:</p> <ol> <li><p>Start on a sheet other than the one with the data. Explanation in #3 below.</p></li> <li><p>Start recording your macro by going to View > Macros > Record Macro. In the bottom left you'll now see a square stop button for when you want to stop recording.</p></li> <li><p>Select the sheet with the data. This way the macro will always remember to select the right sheet regardless of where you are.</p></li> <li><p>Select the two-column range of cells that has your data, then continue selecting a few hundred rows down, or at least well beyond where you think your data will eventually go down to.</p></li> <li><p>Copy</p></li> <li><p>Select the sheet where you want to have the summarized data.</p></li> <li><p>Paste</p></li> <li><p>Sort by name (ascending) and date (descending) all at once (rather than two operations). Do this by going to the Data tab in the ribbon and selecting the white and blue sort button that has two A's and two Z's and says "Sort".</p></li> <li><p>With this pasted and sorted range still selected, remove duplicates in the name column. To do this, do not change the selection. Go to the Data tab and select Remove Duplicates.</p></li> <li><p>Now your items will appear once and the date will be the most recent date.</p></li> <li><p>Click the "stop recording" square blue button in the bottom left to stop recording your Macro.</p></li> <li><p>You can assign this macro to a button or to a shortcut. To add a button you need to show the developer tab and then draw the button using one of the options on the developer tab. I can't remember offhand how to show the developer tab. Once you have a button, right click and assign the macro to the button.</p></li> </ol> <p>13A. If you want to customize the macro, click ALT+F11 to get to the visual basic editor. Double click on one of the things named something like "module" on the left and you can edit your the range in your macro, for example if your data suddenly goes down 100 more rows than what you planned and you want the macro to cover it. Save with CTRL+S. The next time you run your macro, it will reflect these changes.</p> <p>13B. View > Macros to edit your macro if you want to assign a shortcut key to it instead of adding a button.</p> <p>Try all this with a copy of your spreadsheet so that you don't delete data by accident.</p> <p>Does it work for you?</p>