Excel 2003 Macro - Finding rows with data to copy

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

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.
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top