1. MrExcel

    Sending Effective Bug Reports to the Excel Team

    I recently had a conversation with several members of the Excel team about how they process submissions that are sent in through the Feedback icon that appeared on the Help tab in Excel. There is a specific set of steps you can use that will make sure a human reads your bug report. 1. After...
  2. B

    Date & Time Formula

    I'm looking for a simple excel formula that will populate a cell with the date and time when the file is opened. I appreciate the feedback. Brian
  3. S

    Comment section of next step list, capture date, feedback at the current date and change the revision of the next step

    Good day, I have a next step list where each next step listed has a comment section in column G, the comment section is usually only one cell with the text. Every meeting the feedback must be captured with today's date then feedback from the project manager and then if next step is not...
  4. S

    IFS query (I think)

    I really hope that someone could help me with this one as I have tried to study videos and still have no idea how to do what I'm looking to achieve, an I apologise if I'm not explaining properly. I have master table of data that I'm looking to develop a report from: <colgroup><col...
  5. E

    Feedback on this code to learn more efficient programming

    Hello Mr. Excel forum! In the past month and a half I have designed a macro at work, that after much sweat and many tears, finally does what I intended it to do. It was the second time that I made a macro with the last time many years ago. Since I had to google a lot to figure out how to write...
  6. B

    Finance Excel Practise

    Hi, Was wondering if anyone could take 5 minutes to review one of my spreadsheets. I have completed it to a good standard but was wondering if any one could provide feedback? It's not very complex so doesn't require a genius, although any help would be great! Thanks,
  7. C

    Replicating formulas from different rows

    Hi everyone, First post. Be kind. Not sure the title makes sense or does my question any justice. Basically, I have a team tracker for my business and want it to feed directly into a feedback form I've created. It does that nicely using a simple vlookup formula. Perfect. However, I need it...
  8. D

    Insert chart in comment

    Hello all, Does anyone know a way of inserting a chart into a comment associated with a cell, and at a push being able to change the values of this chart by dragging points which would then feed back? It would be great if someone could tell me. Thanks!
  9. P

    VBA Case Query

    Hi All, Hope you can help. I'm designing a frontend for users to enter specific details about a customer which will be referenced against a watchlist and i'm having trouble getting the desired response for two reasons. a) my first case query is fine when the Case is true however the CaseElse...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...