add

  1. L

    Need to add multiplication to an array formula

    Hello forum friends, I am trying to add a multiplier to an existing array formula but it is giving me, not an error, but the wrong result. The formula as it exists is returning a result of 24. I want to multiply this result by 0.621371 but when I add *0.621371 to the end of the formula and do...
  2. K

    Add text in red with userForm

    Hi folks, For a worksheet I'm making a comment form. What it does is simply add some text to a cell the user selects. What I've been unable to figure out is how I make only the added text in red, while the rest stays the same (black). Right now it add's the text from a Textbox to a cell. It...
  3. S

    Lookup query

    Hi. In Sheet0 I have columns A to O populated with travel data. E contains email address I contains departure date L contains country B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value...
  4. G

    how to simplify nested if

    this is my formula for IF...
  5. N

    Add asterisk to string with number format

    Hello, Is it possible to add the asterisk sign to string of text with the custom number format ? i dont want to concatenate the string with the asterisk just format so in the formula bar the asterisk will not exist.
  6. E

    Limit Macro from Filling Past Row

    Hi, I am making a Name List where people can put their name in a cell, and click on a macro-recorded button to automatically add their name to a new row in an existing list. However, I am trying to add VBA to set a limit to the number of rows that can be filled in this list. So, if I want the...
  7. N

    Calculation issues.

    I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...
  8. D

    Adding a Minus Sign with a macros

    I need to add a minus sign in front of a number in cell G8 and one in H8. Thank you for your time
  9. M

    Getting cells to reflect/mirror changes made in another cell.

    Cells: B2, C2, and D2 are the cells. Values: 19, 7, and 12. If I add 1 to 19 and make it 20. I need 12 to change to 13. If I add 1 to 7 and make it 8. I need 12 to become 11. Possible? How?
  10. W

    need to add cell to this VBA code

    Need to add Cells D7, F7, H7, J7, L7, N7, P7, R7 can't get it to work. Private Sub Worksheet Calculate() If Target.Cells.Count <> 1 Then Exit Sub If Target.Address <> "$B$7" Then Exit Sub If (Target.Value >= 0) And (Target.Value < 0) Then Exit Sub Pictures("Picture 7").Visible =...
  11. M

    Add #, ignore text, in specific cells (not columns) plus percentages

    I have 11 cells to add that contain text and numbers. I only want to add the numbers, and if possible insert the sum into a cell that also contains text. My other problem is creating a percentage using those 11 cells divided by 11 corresponding cells with only numbers to get the percentage in...
  12. R

    Case Statement and For next loop

    Hello, My workbook has a tab for each month. When I’m in a specific month, I run the macro below to add a name to the Totals tab. It places the name on the first available row for that months chart. I created name rages for column A for each months chart on the totals tab. Example...
  13. S

    Macro Button for adding a column in a specific location

    Hi, I am very much a beginner with excel, but wanting to add a button on my spreadsheet to add a column after a specific column. The code I have put together is as follows: Sub AddColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter Column Letter where you want to add a...
  14. J

    Add formula to existing formula

    Totally new to this so I have this formula in the formula bar for a cell =+ALLDATA!BN6. I want to put an IF statement saying that if T6/220 >= 7.5 then BN6 else BM6. Also what is the exclamation point for
  15. G

    Split value in half and add

    <tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT
  16. E

    Formula to find new product and add to list

    I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each...
  17. P

    Averaging numbers

    I have a row of 10 numbers and each week i add numbers. What i want to do is have a formula that will average the last 4 numbers in that row of numbers when i add numbers to the row of numbers. So what im saying is i want to be able to always adverage the last 4 number that have been entered...
  18. B

    Pricing from homedepot.com

    I am an electrical contractor that uses excel to quote jobs. I am getting sick of looking on homedepot.com to check prices. I am looking for a way to have look up the price for me. I tried data from web and putting the website in there but I always get errors on the page and I cant add the...
  19. D

    VBA to bring columns in rows (except first column)

    Dear all, I'm struggling with a code to move columns values into rows, except the first column. Of course, it will be needed to add rows and populate the blanks in the first column. Probably, an example will make my exercise easier to understand: An important point is that the number of...
  20. L

    worksheets the collection

    Hi The + sign in the sheet tab that is used to add a new sheet, is it the Worksheets "Collection" object in VBA? Thank you.

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top