VBA: Input Box vs User Form Capabilities
Seeking advice on which of the title items seems like the most appropriate option for the criteria below. Preface also to say lots of folks on here have been incredibly helpful with all the VBA questions. Also, i'm quickly realizing as much as i enjoy trying to learn this stuff, it would probably be a full time job to learn just what i want to do... it's amazing what all can be done with these tools - so big thanks to everyone who has contributed, including HansVogelaar especially! This template has team overview tab ("User List") which houses basic info required for workbook operation. And, as the users have varying levels of skill with excel, I'm seeing the best method to keep this functioning as intended is probably to force some actions in a given path, as opposed to allowing users to update as desired - as that allows inconsistencies and errors result. So my hope is to accomplish the following: On Opening sheet: Q1: Ask user if any new users to the team? Yes - request Employee ID, User Name, Start Date. On completion - More new users? Yes - repeat New User Info intake. No - move to next Question No - move to next Question Q2: Are any users leaving your team this month? Yes - Departing User Info Required: User ID, End Date. On completion: More users leaving? Yes - repeat Leaving User info intake. No - move to next Question All information received from "yes" answers should be added to the table as a new row "User List". Shot for reference here: If the user answers No to both Q1 and Q2, then the intake method should cease, and user can move to whatever task they need to accomplish next. Is this flow more easily accomplished or more well suited to a User Form or a series of Input Boxes? Started tryin to develop both, and realized I should ask the experts before I chase either too far. -Joe
Field Parameter when used in filter pane not working for TOPN filters
Hi, I have created a visual as below: Now I want to filter this visual by bottom 10 worst performers Site Name by Variance parameter created. FYI the variance Field parameter table shown below: So I dragged that field parameter column into filter on this visual 'By value'. But its not showing top10 or bottom 10 instead it is showing all site name. Please advise! PFA file here Portfolio Performance - v2.15 (1) - Copy.pbix Thanks in advance Sir! SergeiBaklan
Use Form to update data
When the command button New Record is clicked the user enters a value into a Form which will then be entered into F7 (or the next available empty cell in F) When the user clicks OK E7 is then updated with Todays date Followed by Filldown formulas in I6 and J6 to the next row Followed by copy cell J2 and past in to K7 End I have included a sample sheet to help explain what I am wanting to do. All and any help will be greatly appreciated. Thanks Summary Form.xlsx
Spreadsheet Compare Highlight Function
Hello I would like to know if rows can be highlighted in the compared files using the Spreadsheet Compare program. I want the rows changed, rows deleted and the rows with entered values changed highlighted in different colors respectively on the compared sheets by the Spreadsheet Compare program itself. Is it possible? Basically, the Spreadsheet Compare program takes in two spreadsheets - Old Data and New Data. I want the added rows detected in the new data sheet to be highlighted green, the changed rows should be highlighted yellow in the new data sheet and the deleted rows should be highlighted red in the old data sheet. I would like to know if there's any way to accomplish this using Spreadsheet Compare or any external method. I'd greatly appreciate any help! Thanks!Adding COUNTIF formula to cell by VBA code
Morning all, need some assistance. Attempting to insert a new formula by VBA with an already working Macro. All the other references unhighlighted below work perfectly, but I am missing something with the syntax around a countif function. The countif currently works on the excel sheet itself, however adding it into the VBA is generating the typical "Compile error: expected: end of statement" error indicating a syntax problem. Any advice?HELP! Consolidating data in spreadsheet without data loss
I have a dataset that I'm trying to consolidate into unique records without losing any data. Each observation has an SSID number, and there are duplicate entries in the SSID number column. I don't want to de-dupe the records using Excel's de-duplicate, because there is information across multiple rows/columns that I would like to consolidate. Here's an example (with fake IDs to preserve confidential information): My duplicate ID is highlighted with conditional formatting. I'd like one observation for student #1234, but that preserved both the grade in Column D, and the 'yes' in Column C that appears in the second row for student #1234. Using Excel's native de-duplicate or consolidate data functions means I lose either the grade in column D or the yes in column C. Any way to do this?Reset form (Check boxes) Excel
Hello, I am looking into an option to reset all check boxes excluding the one already checked as this will always be ticked with the press of a button (Reset Form). I've looked around and it seems possible but I've not been able to implement it correctly. The template of the excel sheet is attached and any help appreciated. Thank you
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, VipinCounting 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
