working

Hello all, I am working on an addition to the massive dBase I have, a query that compares two different tables, linked by a name field in each, and performing a datediff function. For the most part I have this working. The datediff is operational, but the slight issue and question I have is...

I'm a bit stumped trying to remove some characters from a string with VBA. I can sort of get it working with a formula using =Left... but I can only get one side working, but I'd prefer to use a command button to set it up, so I'd like to accomplish it in vba. In range AJ1:AJ200 I have a...

Hi There - I need a working day calculation - but with a twist. Here is my example: A1 = 5/17/19 B1 = 8/1/19 C1 = _________ Part A: I need day #1 to be the first working day after 5/18/19. And then I need the last working day to be the day of B1. And I need to exclude a list of...

Hi there I'm working on excel template where column E formula would be =IFS(F8<$Q$3,F8*$P$3*$O$3,AND(F8>$Q$3,F8<$Q$4),F8*$P$3*$O$4,F8>$Q$4,F8*$P$3*$O$5) this is working fine, but when column F is blank it shows #VALUE !, how can fix this to show blank. also is there a way we can update...

hi all.. <tbody> data1 data2 data3 (Hidden) data4 data5 10 5 20 12 15 </tbody> how to use average formula with data hidden column.. i have use average or subtotal but not working. i'm use ms office 2010.. how to figure out this? I want can work for 2 condition, visible column or in hidden...

Hello, I have a workbook with several worksheets and several advanced filters that was working very well, but with unknown reason the advanced filters stop working Below is a link for a test sheet from my workbook that shows how I did the advanced filter Can someone please check it and let me...

I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why? Thanks, Trent

I have been using the following code to open a workbook to a specific sheet and going to the next available row for data entry. It had been working fine. Then in the course of testing, It stopped working and I would get a "ws = nothing" error... Private Sub Workbook_Open() Dim ws As...

I'm trying to do a calculation where time can be added but only adds within working hours & days. I found this calculation...

I have created some buttons via Form Control and assigned macros to them. I just noticed that many of them literally disappeared. I closed Excel and then reopened the file, and now the buttons show up. I am glad they are working again, but any idea why they would disappear to begin with?

Hello, Trying to use time to figure out if a machines down time falls into the weekend or non working hours. Down time date stamps we have for a certain machine Start Date/Time: 9/13/19 10:00 (this is a Friday) End Date/Time: 9/14/19 9:00 (this is a Saturday) Non Working time: TBD If the non...

Have data that is being extracted from another source. I need to make it usable by a variety of people (hence idiot proof) so they can just create the data and copy, than open excel and single keystroke to paste etc. as below. User opens excel, Ctrl+Shift+R; •Paste copied data - working...

Hello Mr. Excel Users! Scenario Excel sheet1 is protected with pw Row 2:2 is in autofilter before being protected below code isn't working: ActiveSheet.Range("$A$2:$L$3000").AutoFilter Field:=12, Criteria1:="FALSE" Can someone help me please. :)

I have three data tables (see below). The first one (A1:H12) shows the employee name and whether they are in work on a given day The second one (J1:P12) shows what job role they are working on a given day The third one (R1:X12) shows what line they are working on What I...

Work Start: 8:00 am Work End :5:00 pm Break Start: 12:00 pm Break End:1:00pm I am trying to compute the working hours with raw data like 08/30/2019 4:00pm - 09/02/2019 9:00am. The result in this one should be 2 hrs only. But if the raw data is 09/02/2019 8:00 am - 09/02/2019 9:00am result...

Hi all, I am trying to get VBA to autofill a formula to the last active cell in the row. I have the below code, which works fine in other macros I've got running but not in this one I'm now working on. It just debugs. ActiveCell.AutoFill Range(ActiveCell, ActiveCell.Offset(0...

I am trying to create a report where working hrs. is computed. Ex. 8/30/2019 4:00 PM - 09/02/2019 9:00 AM Working hrs. 8 am - 5 pm I want to have a result of 2 hrs. Since worked it done in 8/30/19 4-5pm and 9/2/19 8-9am only. 8/31/19 & 9/1/19 are weekends. Also I want to exclude hrs in night...

I'm trying to use a sumproduct formula but it's not working because of date formatting. I know it's date related because I was able to make it work on made up dates. So if I was to type in smth like "7/5" without the quotes Excel would read that as July 5 2019 and display it as "05-Jul". If I...

Hi Guys, I recently got some great advice on here regarding a function I wanted to get working. I added some code to the vb module, referenced it back in the worksheet and all worked great for a couple of days. Im now opening the *xlsm and none of the calculations are working, just #NAME ...

Hi all, I am after a macro that when a button is clicked it changes the colour of a shape to say if the statement is complete, working towards or incomplete. I then need a cell to be linked to the cell so that if it is complete the cell shows 3, working towards 2, incomplete 1. I have a macro...