date changed

  1. D

    Date Change Only When New Data Is Entered

    I'm sure this has been asked a million times but I am in a time crush and have to figure this out ASAP! This board has been a great help in stumbling my way through Excel so I hope that someone can help me out with this conundrum! I have a spreadsheet that we use to keep track of quotes from...
  2. B

    changuing Date format

    Need some help with this... There is an sales management system in the company I work for, from were I have to get a report and export it to excel to manipulate. This report shows dates in cells with in the format YYYYMMDD (example cell A1 = 20100611). I want to know if there is a formula or...
  3. P

    Last Changed Date for a given sheet

    Hi, I've created a workbook for the CEO with multiple sheets. Each sheet is for a seperate department. The CEO has a summary sheet that pulls through data from the department sheets. So far so good. The CEO now wants to know when each sheet was last updated, so that he can see if all the...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top