Forum Widgets
Latest Discussions
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!!
Create 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? Thanks
Issue 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.
ERRORE #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.
Getting updated data from a Microsoft Form's SharePoint Excel Repository using VBA.
I want to grab data from an Excel file in SharePoint that is synced to a Microsoft Form and put it into a different file using a VBA macro, but I don't get the updated data. I have to manually access the Excel file that is a repository of the Microsoft Form Responses and let it sync to update. Then I can run the VBA. But I want to cut that manual step out. How can I do this?? I've tried many things (Power Automate, VBA updates, etc.), but no luck so far. I saw that I may have to use forms inserted through Excel online to get a file that refreshes immediately after each Microsoft Form submission, but that would mean I have to rewrite the Form and the VBA I currently have.
