system

Hi All Can anyone point me in the right direction with this one? I am capturing time data in a vba form. The data is being entered as number of hours and to make it easier the number of days is also captured. I am then using add to functionality to post into an upload sheet for a secondary...

Hi All New to the forum but hopeful someone can help. This is a wok project I have been tasked with but it has me beat. We process payroll weekly but during overtime season it becomes a bit of a pain as our T&A system doesn't deduct a break when employees have done the required amount of...

Hi I have the text below, where in the middle of it I want it to input the range (F8) but get an error can help please In day today there was an additional " & Worksheets("Handover").Range("F8").Value & " jobsraised in the system by myself to try and fill the guys up- escalations/sitesbrought...

I am trying to create a table and graph that illustrates the age of my equipment in a percentage value. Specifically, I want to show: 1) That I have 29 Pieces of equipment that is between 30 and 40 years old as a percentage. 2) That I have 19 Pieces of Equipment that is between 20 and 29 Years...

Hi, I have a problem. I would like to lock my shared workbook so people wont be able to delete the added formulas, however they still need to add new rows and columns. It's a financial forecasting system. If there is a way to protect the formulas in the workbook would be a great help as...

Hi, I am looking to utilize conditional formatting to color code a set of totals compared between 2 payroll systems. The one payroll system pays by the minute and will have the format 37:47 for example to show 37 hours and 47 minutes worked that week. The other payroll system rounds to the...

Good Afternoon, My data is constantly updated (new rows) and i'd like to be able to average the last 3 scores (SCORE) for each Student (STUDENT) - in the example below Student A would show an average of 91, 71, 74. The issue arises when I add new data, I need this to update on the fly. This is...

Hi there! So I am doing comparison reviews between a system calc and also using VBA to calc % based on criteria. Column T contains tenure. Our system rounds 4.9986 to 5.0, but 4.9900 would round down to 4.0. Is there any way to properly round up / down to nearest whole # based on the above? Ty!!

Hi, I'm trying to reinvigorate my classroom incentive system. I've created a few versions but I'd really like it more streamlined but my Excel knowledge is limited. Basically, the students earn money for tasks and good behaviour, which they use to purchase rewards (sit in teacher's chair for the...

My client's accounting system has an Excel link to upload transactions using OLE. Generally works well, but I have one really annoying issue!! The concept is that a cell (eg B1) has a custom formula in it which contains the entries to be transferred across. Typing "Yes" in upload cell A1...

I would like a macro to read a txt file and compare the list of names on it against the system user. If the user appears on the list open the file and if not exit the file. I am able to readt the system user and open a file but i am lost as to how to actually compare the data. Can any one help?

Hi, My excel file calculation takes too long, I've been told to change to different formulas in order to use less system resources, thus, calculation will take much less time to run. Which of the following formulas uses less/more system resources...

I came into work yesterday, and noticed my computer acting really slow. I'm not sure if there was maintenance being done on the server, or what was going on. But in my code I manipulate IE, and use IE.Quit at the end of each sub that uses it. Well, I kept getting an error saying a system...

Hi, I am unable to upload image .jpg to AWS S3 bucket using vba from my local system to S3. Please do help me. Thanks.

Openpyxl had the brilliant idea of now making all workbooks default to the 1900 system. This is a huge blow to how I do my spreadsheets. In any case, I now need to program VBA to change the date system otherwise I will continually have to do it manually. I can't figure out how to do it. Does...

Is ther anyway I cn automate a spredsheet to unprotect based on teh profile name of the system user so there is no actual user interaction?

I have been using Smart Indenter for years and have recently upgraded to excel 2016. can't use it any longer. I see that there is a possible work around involving deleting and reinstalling the MSADDNDR.DLL file. What will that actually do to my computer? what is the difference between that file...

I am trying to find a formula that, for each row, will display the value of the cell which is closest to 0. In order to use negative time values I have had to use the 1904 date system which I believe is disrupting the results when Excel calculates the minimum value. I have currently tried...

Hi All, I have messed about with this for hours with zero progress so I'm going to open this up to the room in hopes somebody can be a lifesaver. I've taken on a project of updating IP ranges. I have close to about 2 million of these to work through and our system has generated the IP's in a...

I was working on a sheet to compare actual vs expected times (0-60 minutes) when I ran into a problem with negative time differences. If the difference between the expected and actual items was positive (non-negative), no problem, but if it was negative, the cell, which was formatted as...