idea

Hello! I'm trying to enter an if statement within VBA ... ActiveCell.FormulaR1C1 = _ "=IFERROR(IF((OR(RC[-1]=""Active Client - TOA"",OR(RC[-1]=""Past Client"")),""Yes"",""No""),""No"")" If the cell to the left is either "Active Client - TOA" or "Pats Client" ... Return "Yes", if not...

Hey, guys, I'm using a macro do to some basic tasks. However, it keeps ignoring some of the worksheets. Any idea why? Sub Macro1() Dim w as worksheet Application.ScreenUpdating = False For Each w In Worksheets ActiveWindow.DisplayGridlines = False ActiveWindow.Zoom = 85...

I have to write the code such that when the button is pressed the next integer is appended to the end of thetable and its square (n^2) and root (SQR(n)) are calculated and displayed in the table. https://gyazo.com/79ad9088bdf3893edc4fa0165df1c2b5 Could anyone help me get started i have no idea...

Hello I want to ask some have an idea..? how can i split these numbers automatically from the picture? with a script or no other idea .. The idea is not to remove them manually one by one. The idea is not to manually pull them out one by one, that sometimes there are a lot of accounts, and I...

Hi, I am new to this forum but have been following it behind-the-scenes for a while. I have an idea that I need help executing my only challenge is that I am not an excel wizard, at least not yet. But without going too deep into the idea itself, what would be the most efficient way to remove...

Is there a windows API call to use the windows 8 ( not sure if its used in other versions of windows) circular loading symbol that occurs when clicking on a file or copying, etc in a userform. I want to initiate this to show there is loading taking place in the userform event. Another idea was...

Hi, I need to do a lookup on 2 values, a variable name and date then populate with a value, any idea how I go this please? Table is currently like this <colgroup><col width="63" span="6" style="width:48pt"> </colgroup><tbody> 201701 201702 201703 201704 201705 A 2...

Hi I have one computer. I want to learn how to Share/Track changes in excel. I want to see how 2 or more users can share a workbook and make changes and then track changes. Any idea how to simulate that? I am thinking to save a file in Google drive but how can I create 2 different dummy users...

Hi all, I'm trying to set the print area using VBA and I'm getting an object error.. any idea why? CTRp.Sheets("MDR").PageSetup.PrintArea = CTRp.Sheets("MDR").Range("A1:N" & CTRp.Sheets("MDR").Cells(10000, 2).End(xlUp).Row)

I am writing a large programme - far too big to post - and, after it runs through two or three reiterations, it starts to put a standard "Go To" Dropbox up. I have no idea what is causing it - there is nothing in my code calling for that to happen. Please can anyone suggest what might be happening?

Good Afternoon, I have a project that requires a grading score based on several criteria. I have to return a "A", "B", "C" or "D" if certain conditions are met. I have no idea what the syntax should be? There are 3 criteria's and 4 grades that can be applied. Criteria 1...

Hi I am reading the article below and the author is using Combo chat. I am using excel 2010 and I do not see combo chart? any idea why please? Thank you. http://www.guru99.com/creating-advanced-charts-in-excel.html

I have a excel 2007 file that has dropdown list in cells. We recently got excel 2016 and now the dropdowns do not show in the file. Does anyone have an idea why and what to do? Thank you

Hi All I am trying to set up an "if()" equation where I did like to controle the number to insert based on a cell with or without "x" I have got to the following equation, but it does not work. =if(AN16="x",BE16=AH16,BE16=Z16) So the idea is of course that if AN16 has the value x then...

Hi, I'm an Excel newbie and in a bit of a pickle. I'm trying to find the sum of a range of cells (A1:C12) for numbers between 20 to 80, but only ones that are even numbers. I'd normally do this with a SUMIFS function easily, but I have no idea how to narrow it down to just the even numbers...

Hi The link below shows all functions and attribution of Worksheets object. However I do not see "range" in the list? Any idea why? Thanks http://www.excel-spreadsheet.com/vba/objectbrowser.htm

I want to compose a COUNTIF statement where I'm counting how many things are NOT equal to a certain cell Example A1 = 12/1/17 =COUNTIFS(Table1101[Previously],NOT(A1)) I know I can do =COUNTIFS(Table1101[Previously],"<>43070") and it'll work, but I want the date to change it doesn't work...

following is the part of formula which returns wrong result... SUMPRODUCT(IF(MOD(ROW(1:1),2)=0,-1,1)) result is 1 which is correct SUMPRODUCT(IF(MOD(ROW(2:2),2)=0,-1,1)) result is -1 which is correct SUMPRODUCT(IF(MOD(ROW(1:2),2)=0,-1,1)) result is 1, should be zero why returns wrong...

Hi Under formula tab, there is a command called "use in formula" then inside that there are 3 options: address, name and paste names. Any idea how to use these option and for what they are there? Thank you.