Below is a recorded macro to copy data to another worksheet.

Range("V7").Select
Selection.AutoFilter Field:=20, Criteria1:="<"
Range("V7:AI7").Select
Range(Selection, Selection.End(xlToRight)).Select
Range("V7:AS350").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Combined Upload File").Select
Range("A3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

What I really need to do is find the first row that has data in column V (do
not want to include the headers) and go to the last row that has data, copy
and paste into another worksheet. There is a formula in column V that will
provide results if the criteria is met. The current range where there is a
possiblity of data is from V7-V350. I could have data populated in V7 but
not necessarily. I originally was filtering by "non blanks" to get the data
I wanted to copy but realized that it is not dynamic and will not change each
day based on what rows will have data or not.
--
Debbie Sherman