Assistance Required for Excel Co-Authoring Sync Issue
Dear Microsoft Support Team, We are encountering an issue with Excel's co-authoring feature and would appreciate your assistance in resolving it. Problem Statement: We are using an Excel file with co-authoring enabled, allowing multiple users to work on the same file stored in OneDrive simultaneously. However, we have noticed a data syncing issue where two users working on the file are seeing different data. This discrepancy appears to stem from the syncing process. Could you please help us investigate and resolve this issue? If there are any recommended steps or troubleshooting methods we should follow, kindly share those as well. We look forward to your support. Best Regards, Vipin
Counting keystrokes instantly
Howdy, This is a long question, so here's a bit of context: My colleagues often conduct detailed counts using an archaic mechanical counter. I'm trying to digitize it and also speed up the data processing bit. Goal: My vision is to assign specific keys to cells ("a" corresponds with A1, "b" with A2) so that when pushing a key, the keystroke is recorded as a count instantly. For example, if a colleague pushes "a", "a", "b", "a", the value in A1 will be 3 and the value in A2 will be 1. The big catch, is I need each cell to update instantly based on the keystroke, and I also need the option to quickly edit a cell's count in the event of an error. Initially I was working with spin buttons as I figured this would be the easiest solution. Is there any way to change the input from a mouse click to a keystroke? If not, is there an easy way to link the value in some cells to a keystroke? As I mentioned before, I need the cells to update instantly, which is why the spin buttons work well - clicking once updates the count, total count, and proportion (see picture). Thank you very much! Appreciate it! Picture description: -Total count is the total number of strokes counted (sum of the cells below) -Proportion is number of specific keystrokes over total keystrokes
Error when recording a macro (argument is invalid or missing or has an incorrect format)
I'm trying to automate a set of operations in Excel and recorded a macro. The macro gives the following error: Line 56: Range setFormulaLocal: The argument is invalid or missing or has an incorrect format. This is what's on the script on line 56: selectedSheet.getRange("J2").setFormulaLocal("=IF(F2=\"\",\"\",VLOOKUP(IF(VLOOKUP(F2,R2C1:R1400C9,4,FALSE)=0,VLOOKUP(F2,R2C1:R1400C9,6,FALSE),F2),R2C1:R1400C9,9,FALSE))"); When recording the macro I entered this formula on the cell J2: =IF(F2="","",VLOOKUP(IF(VLOOKUP(F2,$A$2:$I$1400,4,FALSE)=0,VLOOKUP(F2,$A$2:$I$1400,6,FALSE),F2),$A$2:$I$1400,9,FALSE)) The formula worked fine while I was recording it. Anybody has any idea what could I have done wrong?
Trying to format a cell to highlight if it hasn't been checked off in 7 days.
Hi, I have a excel sheet that lists tasks as Daily, Weekly, and Monthly. I want a cell to turn yellow if it hasn't been checked off, "X", within the past 7 entries. I want the cell to change after the person has entered their initials and put "X" in all the daily tasks, to remind them to perform the weekly task. Any help would be appreciated.
need a formula
I have data in a cell that forms two columns: "|sku#1 | header: data data data,header2: data2 data2 data2,header3: data3 data3 data3,header4: data4 data4 data4|" it looks like this on the webpage: header: data data data header2: data2 data2 data2 header3: data3 data3 data3 header4: data4 data4 data4 ------------------------------------------------------- to replicate this on the new webpage i need to upload it to a different server in a different format. Each header has to become a column Attribute with the data in the rows of that column | sku | header: | header:2 | header:3 | header:4 | | sku#1|data data data| data2 data2 data2 | data3 data3 data3 | data4 data4 data4 | It will look the same on the new webpage: header: data data data header2: data2 data2 data2 header3: data3 data3 data3 header4: data4 data4 data4 I have fought all night with the Microsoft formatting throwing errors so i have simplified this as much as i can. i am ok with VBA but do not understand Piviot tables so please do not suggest them. I would like a simple excel formula(s) so i can build into into my sheet but i do not think it possible even with multiple steps. i will look at everything - thanks in advance - ask questions if you need real examples or clarification. Make it so each header becomes an attribute / column header with the data below it in the column aligned with the corresponding sku
Multiple unique cells copied to separate workbook
Hello, I am trying to create a macro or button that will take data or text from multiple cells (example C4,E6,G6) and copy that data to another workbook, this would not be so difficult normally however the data needs to be copied to certain areas and biased on the date (which will be in the first worksheet C5). for example C4 needs to be copied to workbook "Data arc" in the first available row in column "A" and worksheet "Jan" if the date is 1/xx/2025 or in worksheet "Feb" if the date is 2/xx/2025. E6 would need to be copied to first available row in column "M" with the same date criteria. this is a small example of what i need but if anyone can show me how to do this i should be able to figure the rest out.
Comparing work sheets in two files
I am a novice when it comes to programing and this forum. I am trying to compare two parts list to see what still needs to be ordered. File A is the parts ordered list and file B is the parts needed. Column B is the Material & column E is the Quantity Is there a way see if the material in file A:A1 match B:A1 if it does, add A:A1 to B:H1. If doesn't move on to the next device in file B until it gets a match If there no match create a worksheet that has the non-match material item with the quantity Thanks
