making

Hello I am in need of some help when adding the overall grade as well as grade weights. Right now I have N/A's (Column P-R) defaulting to 1 if there is no grade.I am afraid this is still not correct. I think the grade is being over inflated with N/A's making the supplier's grade look better...

I admit I am a bit stupid on this subject... I have a table with 7 different colums I need on colum H to retrieve the lowest value from colum G - as long as this is the lowest amongst the relevant rows Coloms A, B & C are the filtering colums, they all have to match I tried making colum H my...

Hello, We have a form that our buyers use to fill in data that we then save a .csv and import it into indesign and create a sign based off the entered criteria, everything goes to where it should yada yada. I want to know if its possible based on the entered criteria to show a sample sign to...

Hi! I am trying to make an advanced bold making macro, but something is wrong. What I want: Column A: apple by the way meet me Column B: I eat an apple. By the way, you are pretty. Meet me halfway. Output (column B, just making bold some words): I eat an apple. By the way, you are pretty...

Attached is an example file. I have about 100 tables of data I need to sumproduct. All are formatted the same but in the same vertical formation as shown in the sheet. I have been cutting and pasting, making them horizontal, but it is tedious to do for each month. Does anyone know of a way to...

Range("a2:a1000").Select For Each r In Selection If r.Value >0 Then r.Offset(0, 3) = Now() End If Next r I know theres probably a way without selecting, these sometimes run slow when making changes to a lot of cells

I want to make the cell in (Before) A191:F191 merge like the (After) A207:F207 and making H191 look like H207 Color properties in H207 is

Hi all Question relating to Comments using Excel 2010. I have a sheet that contains a huge amount of comments making the sheet itself very difficult to read. Is there anyway of making the comment indicator transparent? Or This there anyway of not displaying the comment indicator but the...

Hello, I am in a situation where I am making a sql query by using the columns in excel, out of which 1 column contains date time as 2017-06-13 13:18:18 PM and whenever I used this column in formula it reflects as 42899.554375. ="INSERT INTO ORDERS("&A1&","&B1&","&C1&","&D1&","&E1&") VALUES...

Hi! I know that there are a lot of mistakes, but I would like to solve this problem by using my current knowledge. And it seems to me that there is just one row in my code that is missing... I can't finish it, making bold what i want. Can you help me? Have a nice day https://imgur.com/a/AKIrdM8...

Basically I am trying to see if this is even possible. Taking an email and dragging it over some userform object such that when the user lets go it captures information from the email such as a unique ID of some sort and the attachments ( I am going to extract these and save in another...

I'm using =INDEX(Jan!$2:$2,(ROW(E2)-1)*5+36) to pull the date from Column 41, Row 2. When I add a new column it still pulls from the 41st although the data I want moved to the 42nd... I am making/formatting a sheet and the number of columns keeps changing. Getting to be a pain updating the 36...

Hello, I had this produced for me a week ago or so, but it has stopped working and i am not sure whether it is the forumla or excel itself. It is checking column A and finding the first 2 numbers of that cell, and if it matches what is in G, then is making a total of the sum in Column N...

Hello, I am basically self taught with VBA and I am making more and more complex macros. I am finding that my variables are all over the place and I was wondering what the professionals do in regards to variables. Do you declare all variables or just the significant ones? With the...

Good Day all, I'm trying to convert a formula into a data validation dropdown, but I am having little success. The code works fine if I drag it down, but I want it in a validation list due to space restraints. I've tried making it a named formula but I can't get it to "LIST" all the names and...

Hi all, For reasons beyond my manipulation, I am making - or trying to make, a forum type solution to be used on a LAN with MS Access. I do know many web solutions exist, and I have utilized quite a few, but those cannot be used in my current project so please don't tell me about all the...

Just out of curiosity, is there an easier way to do this equation? Meaning, can I simplify this equation to any degree? The order of the columns must stay the same, sorry...

Hi again guys. Need a bit of help regarding an inventory list I'm making. I would like to manually input the number of items on hand and have Excel ask if it got sold or other if number is less OR ask if it was received or other if greater. The answers to the questions would make a separate...

I am trying to create an IF formula as follows: =IF(A1>0,b1>0,A1+B1, "") So I want if to return anything above 0, and then add the two columns if there are numbers, but exclude blanks. I hope I am making sense. Not sure if the brackets are correct. Any help would be great.

I have a dynamic search function in my excel sheet that returns only the strings containing the value im searching, but it fails to one major thing, i have 980 options to search, if i type: "ab" and be left with 40 options it will still search all 980 of the possible options when i type "abc"...