column

Hello, I am trying to highlight the value "0" with conditional formating in consecutives cells (in the table) in the same row and in the same colunm like I done manualy in picture b3a. The first value in the table is in cell B3. I have this formula...

As seen in the image example.. (I am a total VBA noob as evidenced from my continuous requests for assistance in this forum, apologies. I tried doing it myself but ended up always failing after hours of effort.. :( I require assistance in a macro code that helps me to copy over from MasterCopy...

Hello, Can someone help me with creating a macro which turns a non-continuous range to a column? I have figured out how to select it I just need to copy it to a single column on a different sheet. Thank you

I have a Excel table in the form below that was extracted from a separate sheet: Level1 Level1-Level2 Level2 Level2-Level3 Level3 Level3-Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild...

I have a excel table in the form below: Level1 Level1- Level2 Level2 Level2- Level3 Level3 Level3- Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on... Level1-Level2 is...

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)...

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...

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...

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...

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")...

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...

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 .

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...

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...

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...

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...

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...

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...

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...

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?