Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Macro - Finding rows with data to copy
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding row, then copy paste (macro) | Excel Discussion (Misc queries) | |||
Finding Duplicate Rows (Macro) | Excel Discussion (Misc queries) | |||
macro to select and copy rows only containing data | Excel Discussion (Misc queries) | |||
Excel 2003: Copy rows from one workbook into another without losinginterleaved data | New Users to Excel | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions |