morning

Morning all, Apologies for the second Index/Match query this morning... wasn't sure if piggy-backing onto that thread was allowed! I would like the formula to look at two separate cells in one worksheet, compare them to columns A and C in a second sheet and return the value in column E... I...

Morning all, Looking for assistance on setting up a Macro to update at a set time every evening. Currently our team has excel sets that perform data pulls every morning using a macro called "Update". I was wondering if I can enter a code into this Macro to run at 3am daily? Can anyone advise...

Hi good morning, I have the code below which is in my textbox, but it doesn't auto update,can you help me please? Private Sub TextBox10_GotFocus() If Me.TextBox10.Value = "" Then Me.TextBox10.Value = Format(Date, "dd/mm/yyyy") End If End Sub

Hello, I have a sheet I download daily with among other data a time in colA. This does not have am or pm. So examples are below. This is for a sporting event and the times start in the mid morning.There would not be any late night times such a 12:00 midnight or 12:30 (AM) in the...

good morning, I have a spreadsheet with circa 10K of rows. one of the cells contains data which needs to be stripped out to only leave the required readable data. The field currently contains a lot unnecessary data "We're coming to fit your property tomorrow morning. Your appointment slot is...

Good morning! It's a balmy 11 degrees F here in NH this morning. I have a workbook consisting of 23 worksheets containing background info and calculations, and one worksheet that is the input sheet for user supplied information. I inherited the format and it isn't a straight worksheet with...

Good morning, I'm struggling to get my formula to work. I know it should look something like this but it doesn't seem to like me =SUMIF(INDIRECT("'"&$D$5&" Patients'!V2:V3,"<>#N/A")

Hi, Hope this is placed in the right category. I'm struggling to make a conditional format for the following: If the person on de "Evening shift" is the same as the person the following day in de morning (the first of the 2 persons), I want to put the name in red and bold. I have uploaded a...

Morning all I am looking for VBA to enable me to search my spreadsheet where the 'Grade' column is equal to 'APP' I have the autofilter as Sub check3() Range("A:1:X1").Autofilter6,"=APP" I know I may not need this, but want to leave it in, to let users see it has worked. What I am looking...

Good morning. I have multiple workbooks in my Excel sheet. Is it possible for the default cell on each workbook to be cell E1 instead of A1? Thanks

Morning folks...well its morning here :) I have this code that was kindly produced for me on here. It does the following: Replaces all the formulas in a row with the value when the text and also replaces any blank cells with a dash (-) It does this whenever you manually enter the text...

Greetings, I had been working on trying to get this idea to work and I woke up this morning and my computer crashed and I lost the file and the website I was looking at to learn how to do it, so I'm comping here for advice. Each morning I run a report and it lists all the accounts owed and...

Hello All, I'm trying to map who is present based off of login data. I'd like to be able to plug in a range & Have Excel spit out a number of how many people were logged in during a certain time period. (Say each hour, or 0:00 in the morning to 6:00 in the morning etc.) A dataset sample...

Good Morning: I am trying to utilize the following If And formula but it doesn't seem to be working. =IF(AND(O8>="95",<="100","25",IF(AND(08>="85",<="94","20",IF(AND(O8>="70",<="84","15",IF(AND(O8>="50",<="69","10",IF(AND(O8>="30",<="49","5",IF(O<="29","0","null"))))))))))) I am trying to...

Good morning! I am trying to create a rule that achieves the following: If Column C says "Yes" and/or Column D says "Yes" then say "Yes" in column E. This is what I was using but it is erroring out on me, and I am not sure what else I need to use. Thanks...

Hi, Good Morning! Need you assistance to tweak this formula to work. Formula in CELL B8...

Good morning, I used to enter my SQL by going into Excel --> Data --> Connections and then add new connection. The tab now has a label called "Queries & Connections" and I can't see where I can add new connections, I've clicked on the new label, but there's nowhere I can see to add a new...

I have a workbook with 7 worksheets (2 are data connections). Worksheet = TSA Daily Worksheet = TSA Support (Data Connection) I need on TSA Daily in cell A23 to search through the Associate column on TSA Support on the date on TSA Daily cell B1 and if the associates name appears more than...

Hi all, I got into work this morning and now faced with a complete mystery. I have a Excel 2013 file which contains queries from another Excel file. It's been in use for the past 10 months and worked flawlessly up until this morning. The part numbers we use mostly have letters and numbers eg...

Morning all, I've designed a program to open a workbook on a memory stick however currently it has to be plugged into the E: is there any way for the program to detect which port the memory stick is in? Any help would be appreciated, Thanks in advance