variable column

Intro: I have a lot of data in columns in Excel. I can already use: Select Case Range ("A1").value to give me the value of A1 and use that to do various things with. For instance, if I wanted to return a message based on the data in A1: Select Case Range ("A1").value Case "" Case "Yes" MsgBox...

Hi there, I was wondering if anyone had any ideas on how to accomplish this. Currently, I have customer reports that I am creating macros for that analyzes the data on the report. The problem is the format of the report changes depending on which columns the customer wants to display...

Hello I have this formula for conditional formatting to highlight a row: =AND(OR(COUNTIF($D$5:$F$8,$D5:$F5)>=2),$G5<>0) If any of the values on the row is reapeatead in the range and another condition is true then highlight the row, the thing is I only know where the range begins, the end...

Hi All, Just wondering if anyone knows if there is a better way of finding the last used row when the column is variable? So normally I would just use the below code to find the last row; Range("A" & Rows.Count).End(xlUp).Row But in the code I've done I am finding the column via it's number...

Hello, I've searched everywhere and cannot find a solution to my situation. Many thanks in advance for any guidance. I have a macro that conditionally formats a column of variable row length to certain conditions based on the values found in an adjacent column, for which I used the following...

Hey! In my macro I want to check if a cell is empty or not before writing it over, but with my code it always thinks the cell is empty, what am I doing wrong? Sub Macro 1 Dim r As Integer r = Application.Match(Sheets("Sheet1").Range("A1"), Sheets("Sheet2").Range("A1:ZZ1"), 0) If...

Using Excel 2010 on a Windows 7 machine. Trying to create code to allow a user to hit a button and have the data remove duplicates for the data selected. For example, if the columns are WBS, Labor Category, and Name, the user can select any combination of those three to produce a listing of the...

I'm trying to automate several daily reports, and have run into a snag on my 1st go at it :confused:... I used the Macro Recorder to lay the groundwork, and then consolidated the repetitive steps in a For Each/Next loop. It begins with 1 sheet that needs to be cut and pasted across up to 5...

Hi. I have an Excel 2007 workbook and on one worksheet it includes a formula all the way down Column H as follows: {=MAX(IF(NOT(ISBLANK('ReferencedSheet'!F$2:F$62)),ROW('ReferencedSheet'!F$2:F$62),0))-1} The worksheet it is on is not 'ReferencedSheet' but BaseSheet. I have tested it and it...

I am looking to place a formula which will look like this: =min("A2:?2"), where ? depends on "number of columns". If number of columns is 4, then it should be D, E or Z. Number of columns is specified as an integer in range("B2"). I do not want to do it in a macro, want to do it in the...

SOLVED! Hello I have data in a matrix, I want to count values in 1 particular column of this matrix (say the second column, or the third column). The column is variable so I need a formula like : COUNT (Range, Column, Criteria) This formula does not exist. Could you please tell me a walk...

I have a file with multiple worksheets. The worksheets are labeled Jan, Feb, etc. Each worksheet has the exact same text with variable numbers (it is questions on a survey with the subsequent data). Following the worksheets (12 for 12 months) is an additional worksheet that acts as a data funnel...

OK, so I recorded the following formula in excel but I need to change it so that it uses a variable for the column instead of a fixed column Currently I have: ActiveCell.FormulaR1C1 = "=SUM('Inbound Calls Handled'!C[-1])" I need something like: ActiveCell.FormulaR1C1 = "=SUM('Inbound...

Was wondering if someone could help me with defining a range from data in excel. I have a lot of data in excel that varies both by rows and columns. I need to define this array in VBA, but want it to change if more columns or rows are added e.g array may be from C6:k100 but then change to...

Hi all, Here is my issue: I have few columns (let's say 10). In the first row of eacj column I have the name of a category (e.g. Cat A, Cat B, Cat C, etc) and below I have a bunch of numbers. I would like to create a summary sheet where I add the numbers for each category. The category only...