Hi all,
i created the macro like this:
Sheets("MRR_Log").Select
'Selection.AutoFilter Field:=7
Range("Q2").Select
Selection.AutoFilter Field:=18, Criteria1:="Open"
Range("A2:aj2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy Workbooks("Template MRR Log.xls").Sheets("Uncompleted Data").Cells(Rows.Count, _
1).End(xlUp).Offset(1, 0)
to copy some data with criteria "open" on it and paste it to sheets uncompleted data on the first blank row.
but that macro give me a big file when there's no data with "open" it will paste the blank data until row 65536 (so it just copying the format of the data).
How to avoid that and just to paste special value for any data with criteria "open" on it (the data contains some formula and lookup).
I hope it's clear enough.
thanks for your help!
ovie
i created the macro like this:
Sheets("MRR_Log").Select
'Selection.AutoFilter Field:=7
Range("Q2").Select
Selection.AutoFilter Field:=18, Criteria1:="Open"
Range("A2:aj2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy Workbooks("Template MRR Log.xls").Sheets("Uncompleted Data").Cells(Rows.Count, _
1).End(xlUp).Offset(1, 0)
to copy some data with criteria "open" on it and paste it to sheets uncompleted data on the first blank row.
but that macro give me a big file when there's no data with "open" it will paste the blank data until row 65536 (so it just copying the format of the data).
How to avoid that and just to paste special value for any data with criteria "open" on it (the data contains some formula and lookup).
I hope it's clear enough.
thanks for your help!
ovie