Forum Widgets
Latest Discussions
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.DuncanFardonJun 21, 2025Copper Contributor46KViews0likes5Commentshow do I create formula in excel
I need to separate date and time into 2 columns 6/2/2025, 7:26 AM one column for date and one for timemdlarosa1Jun 21, 2025Occasional Reader21Views0likes1CommentFormula 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)”ray963Jun 20, 2025Occasional Reader35Views0likes1CommentHelp 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!!Marcus_BoothJun 20, 2025Copper Contributor40Views0likes7CommentsCreate table using LET based on column values
Hi all Hope you can help. I am trying to create an output table based on another tables column data. Example: Original Data Table: Task Target Group 1 Group 2 Group 3 Group 4 Task 1 10 5 10 Task 2 20 10 Task 3 10 5 15 16 Task 4 50 90 10 20 19 Output Table Desired: Tasks Team Result Task 1 Group 1 5 Task 1 Group 3 10 Task 2 Group 2 10 Task 3 Group 1 5 Task 3 Group 2 15 Task 3 Group 3 16 Task 4 Group 1 90 Task 4 Group 2 10 Task 4 Group 3 20 Task 4 Group 4 19 Any advice where to start please? ThanksMatt_PazJun 20, 2025Copper Contributor100Views0likes5CommentsVBA to hide set of columns is in conflict with protecting the sheet
Hello, i created VBA to hide a set of columns. But when i try to protect certain cells in sheet including the columns that will be hiden, i get the error message" Run time error1004, Unable to set the hidden property of the Range class". I am not sure how to fix it or if there is a better way to do it. Regards, SamSolvedSamFares40Jun 20, 2025Copper Contributor2.8KViews0likes4CommentsFormatting / Inputting Help Needed
Hello! I am trying to put together a spreadsheet detailing media I own (4k, Blu Ray, DVD, etc.). I would like to include the run time but I'm running into an issue with inputting and formatting. I can set the format of the column as hh:mm:ss but I'm forced to hard input the colon between the hh / mm and mm / ss. Is there any way I can format the cells / column where I don't have to use the colon and it will automatically input it. That is, a movie is 1 hour, 23 minutes and 45 seconds, and I want to just type in 012345 instead of having to manually type the colon between the 1 and 2, and between the 3 and 4. Thanks!SolvedMitochJun 20, 2025Copper Contributor36Views0likes3CommentsIssue with saving Macros Personal Macro Workbook in the startup folder must stay open for recording
Hi, I'm hoping one of the Excel gurus can assist me with this issue I am suddenly having with Macros. Suddenly all of the macros I had saved and have been using have dissappeared. I had these Macros set up in a tab and would just click the macro for the job I was running and it would format my document accordingly. As everyone knows, this saves a significant amount of time. Why this happened, I don't know. The only option now is to rebuild them. This is the process I'm doing to rebuild them: Developer tab Record Macro In Record Macro Box Name Macro Store macro in: Personal Macro Workbook Click: OK Error Message Returned: "Personal Macro Workbook in the startup folder must stay open for recording." I don't know how to get this Personal Macro Workbook to open. I thought that this workbook would automatically open at the start up of Excel. This glitch has caused me so much time and energy that it has actually put me behind in my work. I've checked the path and the "Personal.xlsb" file is in the XLSTART folder.Michael1105Jun 20, 2025Copper Contributor19KViews0likes4CommentsERRORE #VALORE!
Buongiorno, sto lavorando con più fogli e cartelle excel in sharepoint collegando le varie celle, ma in una mi porta #valore!. Nel particolare: nella cartella 1 foglio 32 nella cella A1 ho inserito il valore 11:00, nella cella B1 ho inserito la formula =(1:31!O4), nella cella C1 ho inserito l'operazione =(A1-B1) restituendomi un valore corretto. Poi decido di copiare il collegamento della cella C1 della cartella nella cartella 2 foglio 1 cella A1 mi porta errore #valore!. Come posso risolvere questo errore? Grazie per l'aiuto! P.S. le celle hanno tutte formati uguali TRANSLATION: ERROR #VALUE! Good morning, I am working with multiple sheets and excel workbooks in SharePoint linking the various cells, but in one of them it shows #VALUE!. Specifically: in workbook 1 sheet 32 in cell A1 I entered the value 11:00, in cell B1 I entered the formula =(1:31!O4), and in cell C1 I performed the operation =(A1-B1) which returns a correct value. Then I decide to copy the link of cell C1 from workbook 1 to workbook 2 sheet 1 cell A1 and it shows error #VALUE!. How can I resolve this error? Thank you for your help! P.S. all cells have the same formats.enzapJun 20, 2025Copper Contributor28Views0likes1Comment
Resources
Tags
- excel42,831 Topics
- Formulas and Functions24,854 Topics
- Macros and VBA6,441 Topics
- office 3656,083 Topics
- Excel on Mac2,666 Topics
- BI & Data Analysis2,399 Topics
- Excel for web1,938 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,655 Topics