last modified

Hi All, I've looked around but I can't seem to find a working code that does ALL of the bits I need. I have seen some with parts of it and others that seem to have it all but for whatever reason (likely my fault) I cant get it to work. So I'm looking for a VBA code that will look through a...

We keep a server list in Excel ready for any dinosaurs still lurking who want to read it. I'd like to show at the top of the spreadsheet (C2, D2, E2) corresponding column column header last modified cell (highlighted would be a nice touch)

Hi I have two problems. I need my spreadsheet to automatically make a backup copy of itself each day, with the file name to include the date. Is that even possible? Also, when any cell in a row is changed, I would like a cell at the end of that row to show the now() date, time and the user...

Is there a way to use data from a file that has been updated with a different name on the server? Location stays the same, but the name changes somehow. for example: location: G:\...\Quality\data\brackets_26-04-2016.xlsx after _ :date will be changed So there is a possibility there are...

So I want to import data from one spreadsheet into another. simple right? No, The excel file source I want to pull has a variable file name therefore I want to pull from the most recently saved file in that specific folder. The file I am importing into is in another folder altogether (if that...