Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










COUNTIF: 2 Criteria: Date Range Column & Text Column


Col C = Text and Col F = dates
I would like to count the # of times a value occurs in Col C based on a date
range in Col F.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
COUNTIF Formula (to Count How Many Item In A Column That Meet Certain Criteria)
I am trying to use COUNTIF formula to count how many item in a column that meet certain criteria, say between 10 and 20...

=COUNTIF(G1:G100,"AND(>10,<20)")

View Replies!   View Related
Trying To Find Max Date In 1 Column For Selected Text In Another Column
I have 2 columns: Locations (Column A) & Dates (Column B).

I want to find the most recent date for a selected Location (stored in $G$1).

currently I have in C2: =If($A2=$G$1,$B2,"") copied down the column to the end of data (currently C153). Then in C1: =Max(C$2:C$153).

I also have in D2: =If($C2<$C$1,$C2,"") copied down to D153, and in D1: =Max(D$2:D$153) to find the 2nd most recent date.

Is there some way to condense this into just 2 cells?

See attached file for example (note the columns are currently sorted by date, but that is not always the case).

View Replies!   View Related
VBA To Enter Text In Column After Date Entered In Other Column
I have the following code that fills a range of cells (starting at the active cell) with the date a user selects from a calendar control.


Private Sub Calendar1_Click()
ActiveCell.Value = Calendar1.Value
Selection.Copy Destination:=Sheets("Audit_Results_Data_Collection").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
Selection.Copy Destination:=Sheets("Audit_Results_Data_Collection").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
Selection.Copy Destination:=Sheets("Audit_Results_Data_Collection").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)....................


View Replies!   View Related
Formula To Check Column A For Date Range And Count Column B
I have a formula that counts if a date range is present. However I need to change it to count another column only if that date range is present. For example a17 a50000 the user will enter the date of the order. and in column B has the order number. I want the formula to count the order numbers for a data range in column A.
Here is what I have but it is counting the dates in col A not the order numbers in B?

View Replies!   View Related
If (Column A) Within Date Range Then Add Number In Column C
I'm still confused regarding a complex formula - rather n00b. Using Office 2007 with XP. Can't figure out with help or previous questions.

The following is what I would like this formula to accomplish. Picture included below.

Take all the values of column of C and add them together if and only if the corresponding date value in column A is during the month of January (and February, March, and so forth).

Event DateNameTotal Amount2/21/2009$4,5002/22/2009$04/3/2009$04/25/2009$9,0004/30/2009$8,3005/2/2009$9,0005/7/2009$5,5005/9/2009$9,0005/12/2009$3,000

View Replies!   View Related
Sum Range Based On 1 Criteria Of Column & 2 Criteria Of Another
i m trying to use the sumproduct formula, and OR but i cannot seem to get this right! =Sumproduct(--(A1:A10="Yes"),--(OR(B1:B10="Yes",B1:B10="Mayby")),C1:C10)

I have also tried Array Formula as follows; {=SUM(IF(A1:A10="Yes",IF(OR(B1:B10="Yes",B1:B10="Mayby"),C1:C10)))}

I have also used UDF to for the sumproduct, but cannot make that work! keep giving me value message

Function
Function Customer(Service as Range, Outcome as String, Service2 as Range, Outcome2 as String)

Customer = Sumproduct(--(Service = Outcome),--(Service2 = Outcome2), Result)

-Didnt get thru this bit to start building on the Function! keep giving me #Value!

View Replies!   View Related
Summing With Date Criteria In A Column
I would like to sum G column (in my sample) that will meet a date criteria in C (like from 10/9/2009 to 11/9/2009) or similar. I tried it already with a formula =IF(c2=DATEVALUE("10/9/2009")=<("11/9/2009"),G2,0) could not make it work but its okay without the =<, or a single entry date (a sample in AB column), with this formula its being transferred to another column and being summed, what am trying to figure out is to make a formula or function that it can be incorporated in a sum at the bottom of G column if possible, I would be able to check how much cash collected in a week, days or month....

View Replies!   View Related
Count Between Date Range & Text Criteria
I have an excel file with 1000 of records for eg.

Date INITIALS CATEGORYACATEGORYB
31-Dec-07MTSVIN
01-Jan-08MSSVDI
04-Jan-08MORSKH
31-Jan-08MPSVHI
02-Feb-08MPRSIN
03-Feb-08MPVSIN
02-Jan-08MSRSIN
03-Mar-08MSKSKI


i want to count the datas

1) SELECTING IN THE SPECIFIED DATE RANGE (e.g from 1st jan to 31st Jan)
2) SELECTING MULTIPLE CRITERIA IN B COLUMN (MP & MS)
3) SELECTING MULTIPLE CRITERIA IN C COLUMN (SV & RS)
4) SELECTING MULTIPLE CRITERIA IN D COLUMN (IN & HI)

My colleagues tried countifs in excel 2007 but i have 2003. i want to specify all the four criteria in a single function to achieve my result (IN EACH MULTIPLE CRITERIA)

View Replies!   View Related
Sum Range Using 1 Column Of Named Range As Criteria
how to use SUM Formula a column from within a Named Ranges or Dynamic Named Range?
For example, if the range name "MyData" refers to the address: A1:G10, how could I sum all the numbers in column G of that range where column A meets certain criteria.

Eg., Column A holds fruit names:
Apple
Orange
Banana
Apple

and column G holds quantities of the particular fruit. I'd like to sum column G (quantity) for only those quantities that match "Apple" in column A.

View Replies!   View Related
REcord That Fall Within Date Range, AND Meet Text Criteria
I have a large database that is updated daily. From within the database I need to:

1. Select all records where date field A is 14 days or less than date field B

AND

2. Where a field C matches a text criteria, i.e., =DOGGIE

AND

3. Append KITTY to field D of all records that match criteria 1 and 2

Finally

4. SAVE results as a text file.

View Replies!   View Related
Countif Formula: Count The Number Of Incidents In Column BB That Are >0 But Only IF The Value In Column E Is "Abbeywood"
I'm trying to count the number of incidents in column BB that are >0 but only IF the value in column E is "Abbeywood". i.e. how many times there's a figure greater than 0 for Abbeywood. I can't seem to get count if to do this!

View Replies!   View Related
SUM X Column Range Based On Criteria In Cell
Im trying to do a sumif reading the name in column N (either "Business" or "Procurement"), and suming all values in the range AW:AY.

this is what I have come up with....

sumif(N10:N49, "Business", AW10:AY49)

but it returns incorrect values and not the whole range????

Any ideas? Auto Merged Post Until 24 Hrs Passes;here is an example of what im trying to do...

H2 and H3 are my attempted formulas

View Replies!   View Related
Countif And 2 Criteria (date AND Nonblank)
So I have my countif if past a certain date, which works fine:

=COUNTIF(J89:J128,">="&Sheet1!$A$2)

but what I need is this...

How do I count... but only if a date is past a certain range AND the cell next to it is nonblank?

View Replies!   View Related
Serach One Column And Enter Text In A Differnt Colunm If Criteria Is Met.
In worksheet "Details" search down column "A" looking for any text/numbers. If there is something entered in the cell then look at column "M" for the same row and if that cell is empty inset "0%" in the cell.

Example:
Cell "A1" contains 12345. Cell "M1" is blank. The macro would inset 0% in "M1".

Cell "A2" contains 54321. Cell "M2" contain 40%. The Macro does not modify that row.

Cell "A3" is blank. The macro does not modify that row.

Cell "A4" contain 65478. Cell "M4" is blank. The macro would inset 0% in "M4".


View Replies!   View Related
Date Result From Text To Column
As part of a larger macro, the code below is supposed to start the separation of data into 4 columns. It doesn't work perfectly though and I have to manually inspect data and correct. The problem is that 22: 8- 3- 3 becomes 8- 3- 3 in the second column, which is what I want. However 60:12- 7-10 becomes 7/12/2010. Excel appears to recognise it as a date, when the extra number is in the second column.

View Replies!   View Related
Count Where Text Value In 1 Column & Month Of Dates Meet Condition/Criteria
need a formula to calculate the total number of x's in one column (column B, C, E are training types= x) where the corresponding column date falls within a date range. Itís to total each type of training done for each month. I have 3 training type columns and a cell that calculates the total number of trainings for the each month:=COUNTIF(F2:F100,">="&DATE(2008,2,1))-COUNTIF(F3:F200,">="&DATE(2008,2,31)).
So now I just need it broken down by training type per month. How many x's in each column for February as an example.

View Replies!   View Related
Return Value From 2nd Column When Value In 1st Column Matches Given Criteria
I have a column containing text values eg M1, T2, M3, A4 etc. and I am trying to return the value (numeric) in a second column to a cell when the text value in the first column is matched.

View Replies!   View Related
Is Date Betwen 2 Column Date Range
I am trying to create an array formula which confirms whether a specific date falls within a list of date ranges. I have a list of start dates in column A and end dates in column B. Each row represents a date range. How can I write an array formula to check if a date falls within any of these data sets (i.e. date ranges)? I have attached a sample spreadsheet to show

View Replies!   View Related
Average From One Column Based Upon Criteria From An Adjacent Column
I am trying to get an average from one column based upon criteria from an adjacent column. The number of days to close a case for race columns Black and White are listed in B5:C16 and E5:F16 and H5:I16. I need a formula to calculate the average days taken to close cases for Males and then the same for Females. Sample below: ...

View Replies!   View Related
Wanting To Sum All Amounts In One Column, From Criteria In Another Column
I have attached a work book, with worksheet Attendance which I am trying to calculate the sum of amounts in column N with the criteria from column C and E.
e.g Criteria Column C Jul-01 to Jul-31 or Sep-01 to Sep-30, Column E Alicia or Amelia.

View Replies!   View Related
Copy Cells In One Column Based On Criteria In Another Column
I have an personnel file with employee info, and I want to create a macro that will look in the "Master" worksheet at the Department column ("I") for anyone in Benefits, and then copy their name from the Name column ("D") into the "Benefits" worksheet. The names should begin pasting in cell "D3" but will recognize if a cell already has a name in it and then paste in the cell below that.

Here is what I have:

Option Explicit

Public Sub RatingbyDept()
Dim Dept As Range

With Sheets("Master")
For Each Dept In .Range("I2:I1000")
With Dept

I keep getting error 92 - "For loop not initialized".

View Replies!   View Related
Custom Sorting A Column By Date....and Text
I need to custom sort a column. I have 3 different types of data in the column. First - multiple dates, Second - "TBA", and Third - "ASAP". What I need is when the column is sorted the "ASAP" rows will be first, the dates (sorted) will be next and finally the "TBA"s. I have been trying to use a custom list.

View Replies!   View Related
Converting Date Column To Text Formatting
I have column A set up to display dates in the following format: 03/04/2009. While the "look" is fine for the values in the column, I cannot get it to stay in that format when it is moved to a text file. It simply converts the display back to 39876.

I would like a macro that 1) looks at all values in column A and 2) converts each cell in the column to text format but leaves the contents so they are dates 03/04/2009 (mm,dd,yyyy).

View Replies!   View Related
COUNTIF With Multiple Range And Criteria
I need to add all cells within multiple ranges where the characters "A", "S" and "D" occur.

=SUMPRODUCT(COUNTIF(INDIRECT({"C22:C25","C28:C32"}),{"A","S","D"}))

View Replies!   View Related
Summing Column Within Date Range
I'm working on a worksheet that has dates in one column (column A), and numbers in another column (column B). What I'm looking to do, is look through all of column A, find all entries between a certain date (ie Nov 1 07 - Nov 30 07), and sum all the values in column B that correspond those fields, as long as the value is greater than zero or not blank.

So, for example,

A B
Nov 1 1
Nov 6 -5
Nov 3 6
Dec 6 5
Jan 1 2

I would need the formula to return 7


View Replies!   View Related
If Statement Showing Text Based On Date Value In A Column
I have a worksheet with a range of dates in column E. What I would like is a formula that states If any of those dates is less than or equal to 10 (days) from today and column H text is not "Yes" then show text "Email outstanding Actions" else show nothing?

View Replies!   View Related
Sum Up Column Based On Text & Date In 2 Others
I'm trying to create a SUMIF-style formula which is able to test for more than one condition. i.e if the values in column C meet a certain criteria and if the values in column E satisfy another criteria then add all the corresponding values in column D. In my particular spreadsheet, column C contains a date value. So, for all the dates in column C which are later than 01/01/2008 and for all the cells in column E which contain the word "oustanding", I need to add up all the corresponding values in column D.

View Replies!   View Related
Date Stamp Updated Range In Another Column
I am trying to add some functionality to a spreadsheet that I manage. Basically i have a small team, and each week I ask them to update a spreadsheet to show what they have been working on in that week. In order to monitor who is going in and updating their entry I would like to add a column that shows me when the last update was for each team member. I have seen this example but it only returns a date based on one cell as opposed to the whole row (or range of cells)
Auto populate the date and time a cell was updated. I have attached an example.

View Replies!   View Related
COUNTing Values In Column Two On Criteria In Column One
I have a workbook where I am trying to COUNT the values greater than zero in column "J" based on a selective criteria of column "B".

In other words, if the date in a column "B" cell (B3:B78) is greater than the date in A86, I want to count the number of cells whose corresponding value in the "J" column is greater than "0". And then I want to take this selective COUNT and divide it by a COUNT of all the cells in the range "J3:J78".

So, what I am trying to do is:

FORMULA /COUNT(J3:J78)

View Replies!   View Related
Min And Max Date In Column As X-axis Range
I am plotting an excel scatter plot with x-axis as the date. What I have done is created a macro that automatically does this but what I would like to incorporate is the ability to choose the lowest date and highest date as the min x and max x for my graph automatically.

View Replies!   View Related
Dynamic Named Range Based On Last Date In Column
I want to define a dynamic named range based on the last date in a range (AE4 down). Unfortunately there are gaps in this range where no date is in a cell.

View Replies!   View Related
Enter Sth In Column A Then The Date And Time Automaticaly Entered In Column B E.g
I want to enter any thing in column (A) and then the date & time automaticaly put in column (B)
enter any thing in (A1), the date & time entered in (B1) automaticaly
enter any thing in (A2), the date & time entered in (B2) automaticaly

and so on ...

View Replies!   View Related
Date Column (insert In The First Column Dates Starting From 01/01/2000 All The Way Up To Today)
I'm trying to create an excel worksheet as follows:

Column1 Column2 Column3 Column4 Column5
Date Time In Time Out Hours Worked Pay
01/03/2000
01/04/2000
01/05/2000
.
.
11/11/2008

I want to insert in the first column (Column1) dates starting from 01/01/2000 all the way up to today, 11/11/2008. So I would end up with a unique date on each row.
To accomplish this manually would be a daunting task. I'm a newbie to excel and don't know how to use any in-built functions.

View Replies!   View Related
Configuring Dates: Enter A Date In One Column, Another Column Will Automatically Populate With The 1st Of The Next Month
how to make a certain type of date automate. It's kind of hard to explain, but basically, I'd like to make it so that when I enter a date in one column, another column will automatically populate with the 1st of the next month. For example:

If I enter 4/26/2009 in the 1st column, column 2 will read: 5/1/2009
If I enter 1/19/2008 .................................................. 2/1/2008

Also, it's very important that if the FIRST date is already the first of the month, then the second column will read the same. For instance: If I enter 3/1/2009 in the first colum, the second column will ALSO read 3/1/2009.

View Replies!   View Related
Count Filled Cells In One Column Based On Date In Another Column
I think I am working all around this in Excel 2003 and feel like I am in the neighborhood, but can't seem to quite get there. On sheet1 I have 2 columns of 100s of rows. All of the cells in column A will be filled in with a date as time goes by (1-May-09 for example). Several of them may be 1-May-09 as a matter of fact. In column B, some of the cells will have a number in them and some of them will be empty. On sheet2, I want to construct a formula that returns a count of cells in column B that have a number in them based on a specific date in column A. For example:

AB
1-May
1-May777
1-May
1-May
1-May
2-May999
3-May
2-May
1-May
2-May111
1-May

If I could get the formula right, it would return an answer of 1 for 1-May in the example, because only 1 of the 1-May entries in column A has a number in the adjacent cell in column B. A formula for 2-May would return an answer of 2 since only 2 of the 2-May entries in column A have numbers in the adjacent cell in column B, and so on for the month. If I understand things right, there are too many arguments for COUNTIF. It seems that SUMPRODUCT should work, but I can't make it so.

View Replies!   View Related
Fill Month And Year Column Using Data From Date Column
I have 4 columns

Column A is "Customer Number"
Column B is "Date Can Opened"
Column C is "Month" (currently blank except header row)
Column D is "Year" (currently blank except header row)

I would like a macro to do 2 things here....

1. Extract the Month part of the "Date Can Opened" column and put it in column C.

2. Extract the Year part of the "Date Can Opened" column and put it in column D.

Currently, the "Date Can Opened" column is formatted as a date like */14/01 taken from the Number tab in the Format Cells dialog box) ...

View Replies!   View Related
Multiple Date Column To Single Column & Sort
I'm looking for a way to sort dates from several columns into a new single column (perhaps multiple columns if the entry columns become too numerous). I've included an example. There are currently only 4 columns, but there may be as many as 20 in the future, each with 20 dates under each heading. Any blank cells would be eliminated. If I filled a blank with a new date, that date would be placed into the chronological column. So basically, this would take the date from several different categories and create a single calendar of events.

View Replies!   View Related
VBA Loop Through Worksheet And Format Each Column As Text, Or Date Based On Header
I am trying to figure out a way to condense my code (improve my code) Right now I am using a Macro in Excel to go through a workbook by selecting each column individually and if there is something in the header then formatting that column as text. The problem with the way I am currently doing it, is that due to size limitations on the VBA code, I can only select columns A to Z, and if there is more data in the worksheet it is not formatted. Also I would like the code to check the header and if the word date is in there, format it as a date instead. Also if there is a way to delete any invalid ranges in the workbook

Sub Format()
Dim VarFileName As String
Dim VarPath As String
Dim VarSavein As String
Dim wsheet As Worksheet
VarSavein = Sheets("sheet1").Range("C2").Value
VarFileName = Sheets("sheet1").Range("A2").Value
VarPath = Sheets("sheet1").Range("B2").Value
Workbooks.Open VarPath & VarFileName
For Each wsheet In ActiveWorkbook.Worksheets
Sheets(wsheet.Name).Select
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:= Array(1, 2), TrailingMinusNumbers:=True..........................................

View Replies!   View Related
Match Text In Column Of Another Workbook & Return Nth Column Same Row
I have two excel files.
File #1 is a varying length and has 4 columns with ID #s in Column A.
File #2 is a two column file that contains a list of ID #s in column A AND modified ID#s in column B.

I need to match the ID #s in column A from file# 1 to the list in column A of file#2 then replace ALL instances of the matching ID #s in column A of file#1, with the values found in column B of file #2.

I've tried using the substitute function but I could only replace one found ID at a time.

View Replies!   View Related
Macro Optimization And Moving Text From One Column To Another And Deleting Previous Column
I am running Win XP and Excel 2003.

I have a macro I found here on the boards written by Lenze to delete an entire row based on what is found in column A. I would like to delete any row where Col. B contains 10 or less characters and I have modified it to do so (or at least I think it does). My problem is that it takes about 12 minutes to run the macro (I have about 50k lines to run through). I was wondering if this is the fastest method or if it examines things other than just column B.

Sub Test()
Dim i As Long
LR = Cells(Rows.Count, "B").End(xlUp).Row
For i = LR To 2 Step -1
If Len(Cells(i, "B")) < 11 Then Cells(i, "B").EntireRow.Delete
Next i
End Sub
After this runs, I am left with Columns A to somewhere around AH. The columns are generally in the format of text followed by a numeric column. An individual text column has the same name through all of the rows. The numeric columns have varied values whether negative or positive.
Ideally what I would like: If a given cell (ie. C2) in Row 2 is numeric, then copy the cell to the left (ie. B2) into (ie. C1) and then delete Column B. I need this to work for multiple columns from B to C, skip D and E, and then from F to AG (and maybe beyond).

View Replies!   View Related
Macro - If Cell In Column Is Blank Then Input Text Into Same Row In Another Column
I am looking for a Macro that will search a column for blank cells, and when one is found will add text to the same row in another column. For example: The below is a spreadsheet. I am trying to find something that will search through column "C" in this case and add text (of my choice) to Column "A" if the cell is Blank. So Since cell C1 is Blank then Type "ERROR" is cell A1.

A B C D E
1 X X X X
2 X X X X
3 X X X X X
4 X X X X
5 X X X X

View Replies!   View Related
VBA Formula; Sum Up Part Of A Column Based On A Date Range
I am trying to write a formula with some variables passed into it. i want to sum up part of a column based on a date range (i've got the range already).

View Replies!   View Related
Extract Unique Values From Column B Between Date Range Textbox1 And Textbox2
Sheet1 has following two columns

----A----------B
01-07-2007---10
01-07-2007---20
02-07-2007---30
02-07-2007---40
02-07-2007---40
03-07-2007---60
03-07-2007---70
03-07-2007---70
03-07-2007---90
04-07-2007---100
04-07-2007---110

Sheet2 has following three cotrols

Textbox1=02-07-2007
Textbox2=03-07-2007
combobox=?

I want to Extract Unique values from column B between date range textbox1 and textbox2 and finally how to add these unique records in combox1

View Replies!   View Related
Sum Numbers In Column If Date In Other Column Matches
I have a spreadsheet which will be completed by numerous users, with a worksheet reserved for each area. The spreadsheet is to record the number of days lost to training etc on a weekly basis.

Each worksheet has 3 columns Ė column A DESCRIPTION, column B WEEK COMMENCING DATE and column C DAYS LOST.

The table will be completed by the managerís as the info becomes available to them.

I will be collating the data on another worksheet and need a formula that will look in column B for all instances of 01/10/07 and then sum the corresponding cells in column C, then do the same for 08/10/07 and so on.

I have attached an example of a page.

I thought it may be VLookup or Sumif, but I donít know how to go about it.

View Replies!   View Related
COUNTIF Between Date Range
I am trying to take a large spreadsheet with 2000+ rows of data each with its on unique date associated with each row (its a dump of invoices that need to get paid). I need to count how many invoices are each of the seperate 52 weeks of the last year using I believe a Countif function. My problem is I cannot seem to get the criteria written correctly. For example I want to count out of the 2000+ rows of data, how many invoice dates fall between say, Jan 1 and Jan 7. I would think it would be as easy as using the Countif function and then writing the criteria as a forumula to count invoices that have a date that is greater than or equal to Jan 1 BUT less than or equal to Jan 7. It is that precise formula that is giving me much frustration.

I have a similar Sumif forumula problem as I need to total the $ of the invoices but I think if I get the criteria to work for Countif it will work for Sumif.

View Replies!   View Related
Add Text To Visible Cells In Column Of Filtered Range
Need macro that changes the text in a particular field. Previously, the column to change was column 46 (AT), but now the column is column 1 (A). If I adjust the last line and run the macro, I get this error message: "Compile error: Invalid or unqualified reference".

. AutoFilter Field:=1, Criteria1:="To be capped" 'TYPE
. AutoFilter Field:=29, Criteria1:="OPEN" 'STATUS
.columns(1).Offset(1,0).Resize(rng.Rows.Count - 1,1).SpecialCells(xlCellTypeVisible).Value = "Capitalised"

View Replies!   View Related
Setup A Macro To Copy Text From A Column Of Cells To Another Column
I have been working with a few people on here to setup a macro to copy text from a column of cells to another column and then print this in to a text document but it seams to have got stuck in a loop ....

View Replies!   View Related
Countif Column Has Value A
I want to use the countif function on the below. I want to countif col A has ĎAí and col b has Ďliví

BMAN
AMAN
ALIV
ALIV

View Replies!   View Related
Countif Into Column
I have a column (o) that contains the letters ar and i need to count them into column (o 28 ) i am aware that i can use the count if formula.

COUNTIF(010:O27,"*AR")


View Replies!   View Related
VBA Code To Set Unknown Range Based On Current Date In 1 Column
i have a sheet for monitoring sickness. i have used a macro before which automatically selects a range and emails it to recipients when i press a button. what i would like to do is have excel automatically choose the range for me based on today's day. in the attached example i would like column "A" copied along with the 5 columns before today's date, today's date column and also the 5 columns after today's date. paste the lot into an email and send. (i have highlghted the parts i would like copied and pasted into an email based on today's date (21st july).

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved