1. G

    Making certain columns contain bold texts dynamically

    Hello there, I am a new member in this forum (just joined now). I am in my Excel learning journey and I hope that I can make contributions to this forum soon i.e., hoping to be active. Greetings aside, here is my problem. I wish to make a row of dates (not in columns which is usually the case)...
  2. A

    Populate Column based on date range

    Hi all, I'm wondering if anyone is able to help me. This is driving me crazy! I have multiple charts which contain environmental monitoring data: These are based upon data pulled from colums containing dates sampling took place and then adjacent columns containing microbial colony counts. for...
  3. A

    Copy column to range

    Hello. I would like to copy a column to another worksheet when the header matches a string input. I have the code below: Sub find_col(name As String) Sheets("name").Range("A:A").Clear With Sheets("lot") .Activate For i = 1 To .UsedRange.Columns.count If Cells(1, i).value = name Then...
  4. D

    Dynamic column range based on dropdown menu

    Hi there, I'm looking for help with a problem in regards to using a dropdown menu for a dynamic summation of periods. I have a drop down menu with P1-P12 in it. Here is the report that I have to use for the information. Right now I have been working on by just using SumProduct to get the...
  5. Jasen79

    VBA Add Pictures assigned to column range

    Sub InsertirPictures() ' Help from YKY & RoryA ' Personal Note: Below file path needs to be changed to where the IR phots are located!!! ' Const fPath = "C:\Users\576186\Pictures\" Dim a As Variant, cel As Range, picPath As String For Each a In Array("A38", "F38", "A54", "F54")...
  6. E

    Count each Value from a List of Values in a Column

    I have a list of passages in one column and a list of words or phrases in another column. Then I have a third column reserved for how many times each word or phrase appears in the column with the list of passages. For example: In column A (List of passages), A1: The red fox jumped over the red...
  7. H

    vba delete red column in entireworkbook at print area

    hi dear in excel 2019 , Is it possible to have a macro that in my entire workbook in any cell in print area , if red color font used , then delete entire columns . i have not use conditional formating font . please help me .
  8. E

    Delete words in a column based off a list in another column

    How do you delete specific words in one column that's based off a list of words in another column? For example, let's say in column A I have: A1: Carrots are orange. A2: Green peas go great with garlic butter. A3: Watermelons are red on the inside and green on the outside. And in column C are...
  9. M

    Lookup column header of minimum value

    Hi All, I'm trying to find a way for my sheet to return the column header of where a minimum value is found in a table that also contains blanks. Below is a screenshot of what i currently have. I already have the minimum value from using a simple =MIN(X) formula as you can see in cell B6. In...
  10. A

    Search for texts in adjacent cells and highlight

    Hello all, I'm quite new to VBA searching for guidance. I was wondering if anyone had an idea how to write an excel VBA script that would do the following: 1. Search column B for a cell containing "Checker Plate". 2. And if the adjacent cell (Column A) contains a "6" or a "9" then highlight...
  11. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  12. C

    ExcelSum Column Containing numeric and alpha text

    Hi, I am trying to create a sum formula that will sum a column which contains a mixture of numeric and numeric an text entries. I am using Excel 2016 and I have a column of financial figures, which I know I can use the =sum function to calculate the total of these figures, however, some of the...
  13. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  14. 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...
  15. 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?
  16. 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...
  17. 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)
  18. 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...
  19. 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
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back