help in need!!

Hi, I have a sales table which shows how many sales have been made using a formula that Counts data from another report. Example: =COUNTIFS('Sales Report'!$D:$D,"upgrade paperwork sent",'Sales Report'!$K:$K,"Mrs Brown",'Sales Report'!$G:$G,"42838") 42838 being the raw data for the date I want...

Hello I was wondering if anyone could please help me put this formula into excel? I am very new to using excel and these complicated equations. Any help is greatly appreciated! 0.91 X2 - (2n + 2.25)X+ n2 = 0 0.84 X2 - (2n + 4)X + n2 = 0 X-unknown n - known number (lets say 2) (the forum...

Hey! I'm looking to generate some random numbers using decimals, like from 0.1570 to 0.1579 in that exact form. I've been trying for a while and beyond stuck!

The below listed macro auto sort (sorting each of my rows by reverse alphabetical order) was working just fine. Then I put in some conditional formatting to highlight upcoming, current, and past dates. Not my auto sort is not working. Is there a way to make them both work or is one interfering...

I have a data set with home listings, and I'm trying to answer the question, "For homes in inventory at the end of a given month, how many days have they been on the market on average?" Data specifics: Column A:Location Column W:List Date Column X: Close Date Column I need to average the days...

Hello Everyone, I have what I think is a fairly easy problem that I hope I can get some help with. What I would like to do is have a formula that will help me mark if an individual (distributed by rows [i.e. the names in the table below) have achieved a certain variable (distributed in...

I would like to write a program with the below function If Cell ("J" i) or Cell("L" i) or Cell("N" i) in Sheet1 is not empty where i equals to any integer Then cut Cell("B" i) to Cell("O" i) in Sheet 1 to Cell("B" i+25) to Cell("O" i+25) in Sheet2 where i equals to any integer However,my code...

Hey everyone, In column 'G' I have set up a 3 point colour scale based on the date. I want some of these cells to be excluded from this calculation based on the corresponding cell in column 'E'. So the rule I'm trying to create should go something like this: If E5 = "Action Taken" Exclude G5...

Hello all, I am slowly learning how to use VBA but I could use some help with my current project. I need a VBA code to insert a text box next to the active cell. I found the code below online but I am not sure how to edit the text box size and border color. Any assistance is greatly...

Please, I so need your help! The error appears when i do the set w thing! I am kind of a beginner so can you kindly help me? Sub Datas() Dim w As Range Dim t As Long Dim i As Long t = Sheets("Crono").Cells(Rows.Count, "A").End(xlUp).Row For i = 8 To t Set w = Sheets("Projetos...

Hi, After some help with excel to word macro, trying to populate letter templates from raw date pasted from another system. Word templates all <tbody> Title First_Name Surname Address_1 Address_2 Address_3 Town County Postcode </tbody> ---- Code im using Sub FindReplaceInWord()...

Hi all, I have some questions on my work but i don't know how to solve it through vba. Please offer help. for my case, from column A to AJ and row 1 to 10000. two column are pairs like AB, CD, EF, GH...... 1. They compare colors pairs by pairs like A10,B10, both of them are yellow, I want to...

I have an excel sheet that has numbers 1 - 20 in row 2 and various dollar amounts above them. I need a formula that if the number I put in cell D5 equals any of the numbers in row 2 it will return the dollar amount specified above it.

Good day! I would like to ask your help regarding the vba code that I need to enter in making my list automated. What I want is that whenever I select from the dropdown menu, the table will be automatically be filtered without including the blank ones. I was able to attain this, but, an error...

So I have a date formatted as MM/DD/YY and I need to determine the day of the week using the MOD function and a single IF Statement and I have no idea how to do this? Any help would be appreciated. Also the date I chose was 3/16/2016

Each day a receive an email containing an .xls link which has various tabs of data. What i would like to do is, when the email arrives, to automatically open and save the sheet to the hard drive, in a particular location with the date added on the end! ie: newfile010416.xls im very new to...

Hi everybody! I would like to seek for you help regarding my problem. I would like to use two codes for Private Sub Workbook_Open() but I do not know how to do it. My codes are the following: Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)" and Dim Edate As Date Edate =...

Ok, I have a scenario that I have searched and searched on and have not been able to come up with a good solution. I'm really hoping someone here can help me. I have two items, a macro-enabled excel workbook and a sharepoint site survey. What I want to be able to do is... 1. Create a...

Hi everybody, I have a userform with alot of checkboxes (thinking to change them to optionbuttons ) which must be checked to enter value into the sheet.I want that the checkboxes are always set to false (unchecked)when the userform opens. My first question :Can i save the checkboxes entry from...

I need to " Set the warning options for a range of cells" in cell C2:C194. It should not display alert and update automatic links.