Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating and copying data into new sheet
Hi, by change (or report) I meant that I might only want to report on a particular string or date and would like the macro to only look at those rows where the value was, eg: "New York". Thanks for your help and time, much appreciated. -- scottwilsonx ------------------------------------------------------------------------ scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128 View this thread: http://www.excelforum.com/showthread...hreadid=263823 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating and copying data into new sheet
Scott,
In code, you would change the If CLng(myCell(1, 2).Value) = CLng(DateValue("12/1/2003")) Then to If myCell(1, 5).Value = "New York" Then Otherwise, for more flexibility, try autofilter. That will just hide the values you don't want to see, and show those that you do.... HTH, Bernie MS Excel MVP "scottwilsonx" wrote in message ... Hi, by change (or report) I meant that I might only want to report on a particular string or date and would like the macro to only look at those rows where the value was, eg: "New York". Thanks for your help and time, much appreciated. -- scottwilsonx ------------------------------------------------------------------------ scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128 View this thread: http://www.excelforum.com/showthread...hreadid=263823 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Calculating and copying data into new sheet | Excel Programming | |||
Calculating and copying data into new sheet | Excel Programming |