How do I get repeating part numbers (data) to auto fill data.
Sorry I am not very Excel savy but I was tasked with filling a spreadsheet with data of our part numbers, their description, the supplier we get them from, our assigned supplier numbers, and our suppliers part number for kits we make in our company, there are over 9000 but I have noticed that there are a lot of repeating part numbers so I was hoping there was a way so that I could have that data auto fill. I can post a link to the document it does not have any proprietary data that I can see. https://gpcompinc-my.sharepoint.com/:x:/g/personal/zachv_gpcompanies_com/IQAYSdPfHYQvRp6TRW4hg_xjAYh_4Jjl2Z_aCXX_64zMf50?e=MKDtrRVBA events stop working for one user when another user opens the shared workbook
Hi, I’m experiencing a strange issue with VBA in Excel. We use several Excel files as a CRM system, all with VBA (mainly worksheet events). The files are shared so that my employee and I can work on them. Recently, VBA events stopped working only on my computer in some of the files. Important observations: For my employee, everything works normally. Manual macros run correctly on my machine. Worksheet events (like Worksheet_Change) do not fire. Application.EnableEvents returns True. Macro security and Trusted Locations are already configured. The files are almost identical (same structure and VBA code). What makes it even stranger: A file that worked for me yesterday stopped working today immediately after my employee opened it. Since then, the VBA events no longer trigger on my computer in that file, while they still work perfectly for him. So it seems that when another user opens the shared workbook, VBA events stop working only on my machine. Has anyone seen something like this before? Thanks.
Filter Function or TAKE-DROP Function
Dear Experts, I have a Data like this:- Column A -> Has the File Names, and Column B,C,D have their corresponding data, In Column F I have the unique File Names and from G/H/I -> I need the start of the hfn/sfn/slot and in J/K/L the end of the hfn/sfn/slot for that File Name as populated , How to achieve this? Thanks & Regards Anupam Shrivastava
User input fields in power query
I have a power query table of employees from an employees worksheet in the current workbook. First Name Last Name Address Etc. Which I feed into Power Query. I want to generate other tables in the workbook using the first and last names from the above table as a starting point, but adding user input fields. I was able to do this initially by having power query generate the first two columns, and put another table next to it with the user input fields to "fake it" and combine everything in a subsequent query. I was wondering if there was a more elegant way of creating a new Excel table (and probably a new sheet to put it on) by using the two columns from the sheet I already have, plus any additional columns I need for users to fill in. Either using standard Excel or power query, if I can stop power query from zapping the user input fields on a refresh. Note: I don't know how to have Power Query add a column without assigning it an initial value like null. That is why my user input fields are getting zapped building the entire thing in Power Query at the start.Want to add a minus number, alongside the existing formula
Hi all, I have here a handicap calculator that's primarily used for tenpin bowling and I would like to add an enable / disable (with Yes or No) a Minus Handicap along with the existing formula for each cell (in columns B, E, H & K), plus the option to adjust the percentage to affect only the minus numbers. Hope it all makes sense. Thanks in advance.Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.Freezing multiple rows
I just need to freeze the top 3 rows in a spreadsheet. Easy: select the 4th row, click 'Freeze Panes' and choose the 'Freeze rows' option. Except that the option isn't there - the only option offered is to freeze the top row. I am using Office 365, so my Excel is a current version. And I am working in Normal View. So I don't understand why I cannot freeze multiple rows any more!
