column

  1. J

    VBA - filtering columns after inserting or deleting cells

    Good afternoon I'm looking for a way to make the field of an autofilter dynamic - for example: Range("a1:J" & LRow ).autofilter Field:=7, Criteria1:="" If someone were to add a column between B&C, the field would now need to be 8, but the code won't register this. I've thought about maybe...
  2. R

    How to find column with oldest date?

    I have a row containing formulas that will either show a date or a "". A B C D E F 6/5 6/4 6/3 6/2 Using VBA, I want to find the column where the oldest date is located in that row. So in the example above, I need to identify the column where 6/2 is located. How can I do this please?
  3. S

    Hide Scroll Bar in Sheet

    Hi, Hopefully this is possible. I'd like to hide the horizontal scroll bar in a specific worksheet. The code below does it generally for all tabs, would appreciate some help tailoring it to only apply for the "Results" worksheet Code - For All Sheets: Private Sub...
  4. W

    Requirement to show the hostname value / column heading when a cell is changed

    We keep a server list in Excel ready for any dinosaurs still lurking who want to read it. I'd like to show at the top of the spreadsheet (C2, D2, E2) corresponding column column header last modified cell (highlighted would be a nice touch)
  5. F

    SUMPRODUCT IF value equals

    Hello, could you please kindly help me with the below, to make it so that it'd only consider values for the calculation if the corresponding value in column 'A' = "XX", and instead of specifying the range, sums up all the matched values in a given column? Please also note that values start in...
  6. A

    Insert column dose not work

    Hi there I have an excel workbook and I can't insert any column in any worksheet. I will appreciate helping me on this. Here is the excel file .Excel file
  7. Emanuele

    Multiple Column and string extract

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that I found on Internet and that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and...
  8. N

    How to transpose without replacing

    I need help please. I need to transpose the emails without replacing the existing information in the columns where the information will be pasted. I need only 3 columns per person but several rows if the person has more than two emails Moderator edit: Images removed as probably genuine email...
  9. R

    Paste date from a Named Range to previous column - VBA excel

    Hello, I have named range "H1Range" (lets say H3:H16) and in each run I insert cells before the named range and copy/pastespecial H1Range data in it. Is there a way to string the column which is in the left of Named Range? Thank you in advance
  10. W

    VBA help to match column header from different workbooks

    Hi all, I am looking for some VBA code to help me with the problems, it would be great if one can help. I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding...
  11. L

    Find Column Header From Another Workbook and Populate Column Data

    I have two separate workbooks. I'm wanting to use an Array Formula to search through the external workbook, find the column header header "Si" and populate all external column data into my local workbook. Can I use Index/Match or Xlookup for this?
  12. A

    set range

    Hi, I have hit a wall trying to create a macro to set a range using the last column with data and column "C". Column "C" being the constant and the other column always changing. Thanks for any help, Tyler
  13. A

    Using offset to copy formula down a column

    Hi I am trying to apply a formula where I need to refer to a few cells to the left of the formula cell and a few cells to the up and apply the formula down the column for quite a few rows. I am trying to achieve the result by using offset function, but I am not getting the desired result...
  14. L

    Create column with conditional

    I everyone, im new in power bi / power query and I need to know how to create a column in a table IF the value of a specific column is between a range of one of two different column values. Something like: create a column 4 where the value is the same as the value in column 1 IF this value is +...
  15. D

    CONDITIONAL FORMATING LAST CELL IN COLUMN GREEN IF GREATER THAN ANOTHER CELL

    I want the last cell in column L that has a number to be green if it is a larger number than cell D11
  16. G

    Data best fit?

    Hi all, If I have a range of numbers to 2 decimal places in column A, for example from -2.52 to 3.84 with intervals that are not the same -2.52, -2.49, -2.48, -2,42, -2.42, -2.41, -2.38....... 3.65, 3.69, 3.70, 3.80. In column B the number in the cell adjacent to -2.52 is 20 The number is the...
  17. W

    Sum the entire column of named range except the first row

    Hi Folks, I have a question, is there a way (a formula) that i can put in a first cell of a named column and have the formula sum the entire column EXCEPT the first cell of that same named range? This formula "=sum(index("My Named Range",,11))" results in a circular error because its trying to...
  18. reasem

    Want conditional formatting to reset after column filters are used

    Using the formula=MOD(ROW(),2)=1 to have every other row have color to make it easier to use a large spreadsheet I have. When I change the column filters the rows are no longer colored every other row obviously. Can I alter the formula at all to have it reset when filters are added? somehow use...
  19. R

    Conditional Formula: Using 'If' 'And' and 'Or' - solution will save days of work!

    Goal: IF Column E is Blank AND Column M OR Column T are <0 True= "Review" False= Blank I can write the 'if/and' but when I include the 'or' my results are meaningless.:confused: Any help appreciated, as a solution will save me days of work.
  20. L

    VBA - copy new rows from different sheet, if condition is met

    Hi, I am VBA Excel coder since yesterday and I am stuck. Hopefully you can help me. I am managing sports team and want to follow players training progress. I have made google forms page and linked it's workbook to my computers excel file to update it automatically via Data - New Query - From...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top