users

I have an extremely large table (4.8MM records) that is the result of users importing excels with the same format into this table. From what I can tell, there are a significant number of duplicates within this population (likely from users importing the same excel twice). The tricky part is that...

Hi All, I have a list of users in a table. The appropriate User is found by using a For Each loop (this is working). Now, once the User is found, I have the row (that the User is in). I now need to find the first available/emply cell to the right, in this row. I need to search for the next...

Can someone help me out "sharing" a workbook without Office 365? If all four users have the desktop version of Excel 2016 and the file is on our network server, when the file is shared, can the users see the active cell of each of the other users? I believe I saw this in a demo of Office 365...

Hello! I have been asked to create a Sunburst Chart in Excel that does not total the values and show the values as a part of the total. For example if I am comparing Licensed Users and Activated Users and I have 50 Licensed users and 20 of those are activated users. When I generate the...

I have a report that I generate weekly. Our users (about 15 or 16) go into the report and add accounting details. Over the last few months, data has been damaged by users dragging their data down and sometimes over the data entered by other users. I would like to create an AutoOpen macro that...

Hi all, I'm finishing up on a project and applying "Security" I'm using Application.Undo in many shapes and forms to create a log and to not allow the users to change the layout, but allow them to edit the data.. Question 1: I have an admin sheet (Sheet1) with something like 20 look up...

Hello, I need help transferring results from one sheet to the master sheet. The users are only listed once on the master sheet, but some users have multiple results. Vlookup only returns the first value so I need help getting each thousands of users results in one cell in the results column...

Hello, I need help from the experts. I'm creating an inventory file for all users and I have the main sheet called "Users" where I have a table with the names of the users in the column A, starting in the cell A1 and goes to A200. I need to create a new sheet using the sheet called "Template"...

Having a very annoying problem for users which does not happen to me. I run code when the workbook is opened that automatically connects to a SQL Server and brings back data for users depending on their role. The connections work without issue for me, but at times they throw errors for other...

Hi everyone! In my database I have implemented a number of login features to protect the database. Every 60 days users are forced to update their password, and if they have not logged in for 90 days they are prevented from logging in until an administrator restores their privileges. In order to...

I have a macro that works on my pc perfectly. When I try to run on other users pc I get the same error. Section below in red font is my issue. When I have other users run I get a DEBUG error and the red font highlights in Yellow. (Sorry I couldn't figure out how to hightlight in this website to...

I have sheet that is designed for end users to only be able to put information in unlocked cells. I want them to then be able to click the corresponding the button that puts this information into a master sheet. THEY ARE NOT TO BE ABLE to edit any sheets or any buttons. I have around 200...

Good day, Excelsiors, I am using Power Query to run an API call to our service provider, in order to pull through our platform users and their attendant data. The idea is that we would like to keep a "real time" register, rather than keeping a separate, manually updated register which is...

So I have come across a very peculiar situation -- I've developed an Access 2016 DB for my team -- there are about 10 end users -- each of them have their own executable on their respective desktops. The DB is Split -- the executable is the front end, and there is a separate MS Access back...

This code will prevents users from right-clicking ON THE TAB itself: Application.CommandBars("Ply").Enabled = False but it only works if the user tries to right-click a SINGLE tab. If they select more than one tab and right-click, they are still able to do so. Is there some code...

I really need help on this. So the idea is that I'm running a calculation of top-ups to an eWallet, so I have a. Average top up amount ($47.50, b7) b. Average top up frequency (once every X months, b8) c. Number of new users (varies each month, row19) d. Attrition rate (varies each month) e...

I have to show RAG status for the following in a 200 row document. How do I set up my formual Green - no users exceed 95% of 1GB limit Amber - Site does not have users that exceed 1GB, but does have users over 95% of 1GB Red - Site does have users who presently exceed the 1GB...

I am creating workbook containing VBA procedures which will be distributed to many users on different sites. I have password protected the code to prevent people seeing/altering/stealing it but this is causing me problems supporting the workbook. I have covered foreseeable errors with...

I'm somehow failing to Google my way out of this... I have 2 named ranges, Items, and Users. As I have a lot of Items with Users of ""/0 I want to populate a side list containing only Items with Users >0. My first Item starts on row 10 and I have created (stolen) the following array formula...

Hello All, I have this issue have been trying to solve for a while now and cant seem to find any solution. I'm hoping someone here can help me. Here is the issues. I have data that comes to me in this format and it have a few more columns and rows. Dept Users Finance I...