Excel problem
On Oct 26, 10:58 am, "michael.beckinsale"
wrote:
Hi Maureeze,
You didn't say whether you want to do this using VBA or manuallly but
since you have posted to this group l assume you want to use VBA.
Assuming the data is in culumns A,B,C
the process would be, filter column A, copy the range, paste to
another sheet, so the code would something like this (assuming no
other data is on the sheet)
Sheets("Sheet1").AutoFilter Field:=1, Criteria1:=myDate
Sheets("Sheet1").Cells.Copy Destination:=Sheets("Sheet2").Range("A1")
where the variable myDate is the date you want to filter. This could
be defined by using an input box. If the source sheet contains other
data you can use the .Range("A1:C10".CurrentRegion.Copy instead
of .Cells.Copy
Hope this helps
Regards
Michael Beckinsale
Do you know if it is possible without VBA and without advance
filtering?
|