Comments not displaying on hover
Hi, So I just got back from a stretch of leave to find that comments now only show the 'reply' option, but don't show the original comment or thread ... any idea how to fix this? Going to the menu option (review>show comments) and bringing up a sidebar is ridiculously cumbersome, especially for something that used to work. I have hundreds of comments in my tracker, so this is fairly annoying, and I'm hoping there's an option to have it display again.
Formula Required if possible
Hi All, Can the following be accomplished… Help with a formula…. Sheet1 C8 and Sheet2 F7 Three alternative texts to choose from…. Sheet1 C8 – text entered “CASH” then Sheet2 F7 shows “CASH”. OR Sheet1 C8 – text entered “NIL” then Sheet2 F7 shows “NO PAYMENT”. OR Sheet1 C8 – text entered “EFT” then Sheet2 F7 shows “ELECTRONIC FUNDS TRANSFER (EFT)”Help with Excel report creation for review results from multiple worksheets...
Windows 11 MS Office 365 Cloud Accessed from Citrix desktop I've been working on this project for a while and have a tracking spreadsheet for several review categories, each on its own worksheet tab. I have a results page that gives me the data I need. The table on the RESULTS tab contains the results for the reviews and marks them as either having 'Not Met', 'Met' or 'Exceeded' the goal for each category. The final piece of the project is giving us problems. I received a great deal of help with it from @HansVodelaar here on the forum and he got very close to solving it. I've included the spreadsheet with the final attempted 'Result' tab. Here is what I'm trying to do now... Automatically generate a simple report Based on the generated date on 'RESULTS' for the selected Rep That lists all records, Labeled by review category (see review tabs), From the designated start date to designated end date, Only for the categories with scores designating them as either 'Not Met' or 'Exceeding' the goal. So far, the 'Report' tab works to list the records. However, there are a couple of problems with it. I can't seem to successfully copy the formula to the master workbook, which holds the same structure, but is not redacted. The returned data, as is, only separates the categories by a blank line, but does not identify to which review tabs (categories) the results belong. Any help offered is greatly appreciated. Hans suggested that the solution may require use of Power Query. So, if anyone has an idea of how I can accomplish this report without having to go into each tab to filter, sort, format and print, it would be totally awesome!!
