adds

Hi there, I've racked my brain, and exhausted google searches so hoping someone can help me. I have a bunch of data in a spreadsheet that I do not want to manually update when the quarter turns over. So I'm wondering if there is a way to do a conditional formula (and I know there has to be)...

Hello, I have searched for an answer but I am probably asking the wrong question. What I am looking to do is a create a cell that will start with a value of zero and every Thursday it adds a 2 to the number already there. I'm sure it's possible but I can't seem to find anything. I thank you in...

Hello! In my day to day job, we have goals set (for each month) that can be either positive or negative "net adds", and I can reach negative or positive actual net adds by the end of the month. I am having issues getting excel to populate my percent to goal under the following parameters: My...

Hi, I use the same bit of opening code on just about everything I ever work on (I know there are a lot of different ways of doing this): 'Finds last row of data on the Altos billing Nov 18 calls Sheets("Altos billing Nov 18 calls").Select LastRowWithValueAltos = Columns("A").Find("*", ...

<tbody> Custody 50 Transaction 70 Revenue 1000 Custody/Txn ? </tbody> I'm trying to modify one of my formulas. Essentially I want to write a SUMIF statement where anytime it sees either Custody or Transactions it adds them up. I think it'd be something similar to this...

Let's say I select a control to add. I click on the form and it adds it. Now I want to add another control of the same kind. I have to go back to the toolbox and select the same control again, every time I add it. This is the default. There have been times when it adds that same control...

Hi all, quick one I hope. I'm copying 4 tabs from one workbook into a new workbook, only copying the values, formatting and column widths along with the tab name and colour. I've done this by recording a macro, but have ran into a problem. When the Macro gets to Workbook.Add, it adds a new...

Hello So I have a macro that adds a sheet, formats it, adds the formula, and adds buttons (calling other macros). There are 7 buttons made for each sheet made- so I'd like to know how to hide two of the buttons when the sheet is first made (I presume for the button itself, when it's made I just...

I'm attempting to enter data by hand into a worksheet. I have selected cells and formatted it to text only. When entering -7.82 dB it adds = and some other nonsense ahead of what I have typed. And I can't remove it. Attempting to has highlighted a Cell blue and Hung me on something as R-click...

Trying to fix bug in sheet when time auto populates in the proper cell, the cell before it adds the date 01/01/1900 + the previous time, messing up the average handle time.

I have the code below that adds a line above the active A cell. Is there a way to change this so it adds the line below the active A cell? Sub insertRevBetween() ActiveSheet.Unprotect Dim iCountRows As Integer Dim Rng As Range iCountRows = 1 'Error Handling If iCountRows...

I have a depth sensor with an output from 0-60 I would like to add a value of 1 to another cell each time the value exceeds 5, but only once. when the value falls below 5 the cell does not change value and waits for the value to increase above the 5 threshold. I have tried a vba code which adds...

I'm have trouble getting this to work properly. Would anyone be able to help? I can't seem to get it working :( Thank you! Sub Save_Workbook() 'Save current file in current location ThisWorkbook.Save 'Always automatically replace existing file with same name...

Hi all, I am trying to create a macro that adds a new row to the bottom of a table and keeps the conditional formatting and functions of the row above it. My knowledge of these types of macros is VERY limited so please be patient when asking questions. I currently have the following macro but...

In cell E4 I have the formula =IFERROR(A4+TIME(0,D4,0),("")). Where A4 = time and D4 = a number. The formula adds the number to increase the time. Problem: Sometimes the number in column D is a negative but I still want to increase the time by that number, as in treat it like a positive. So I...

Hi, I have table ranging from A1 to J5. A1 to J1 are headers. A6 to J6 are totals. I need a button that adds new last row to table. For example first I need to add row 6 and push totals to row 7 and so on. Thank you

Hi, Is there a way to do a LIFO calc that reduces the older invoice and adds in the newest invoice? Making the average number of days outstanding change?

I have a macro that adds records to a table if another table has a new row added. It works fine and doesn't produce errors. There are times however when it adds records when no new row was added to the feeder table. Is there something in the code that makes it run anyway? Private Sub...

Hi all, hope someone can assist. I have a blank template which I add to the workbook as a new event is created. I have now noticed there are three other circumstances which require different templates. So I will have Blank1, Blank2, Blank3 and Blank4 templates. Currently i just have a piece...

=SUMIFS('[ABQCSR_TEMPLATE.xlsm]TABLE (4)'!$B:$B,'[ABQCSR_TEMPLATE.xlsm]TABLE (4)'!$A:$A,$C15) This is only supposed to find R12 IN THE C15 cell and look for it in TABLE (4)'!$A:$A. Then it adds up what sin the B column. Unfortunaly it adds the R21 & the R12 mixed up and adds them both.