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)...
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.
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)
For i = 1 To .UsedRange.Columns.count
If Cells(1, i).value = name Then...
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...
' 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.
In column A (List of passages),
A1: The red fox jumped over the red...
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...
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...
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...
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...
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...
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...
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 "".
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?
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:
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)
last modified cell (highlighted would be a nice touch)
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...
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...