Is thereany way to filter / copy nonblank values toanother sheet.
considering followng example.
ID NAME
1
2 BBB
3 CCC
4
5
6
7 DDD
8 FFF
9 EE
ID NAME
1
2 BBB
3 CCC
7 DDD
8 FFF
9 EE
thanks in
$$ filter of nonblank cell
Is thereany way to filter / copy nonblank values toanother sheet.
considering followng example.
ID NAME
1
2 BBB
3 CCC
4
5
6
7 DDD
8 FFF
9 EE
ID NAME
1
2 BBB
3 CCC
7 DDD
8 FFF
9 EE
[mailto:excel-macros@googlegroups.com]
On Behalf Of vickey
Sent: Monday, July 25, 2011 7:42 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ filter of nonblank cell
Is thereany way to filter / copy nonblank values toanother sheet.
considering followng example.
ID NAME
1
[mailto:excel-macros@googlegroups.com]
On Behalf Of vickey
Sent: Monday, July 25, 2011 8:13 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ filter of nonblank cell
thanks but nonblank data is not being copied in data sheet.
On Jul 25, 7:29 pm, Rajan_Verma rajanverma1...@gmail.com wrote
Hi
find attach as per your requirement.
try :
Sub test()
Sheet1.UsedRange.Copy
Sheet2.Select
Sheet2.Range(A1).PasteSpecial Paste:=xlPasteValues
On Error Resume Next
Columns(B).SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
On Error GoTo 0
End Sub
On Mon, Jul 25, 2011 at 7:42
use filter and select non blank then select data press alt+; then copy and
paste
On Mon, Jul 25, 2011 at 7:42 PM, vickey vikasda...@gmail.com wrote:
Is thereany way to filter / copy nonblank values toanother sheet.
considering followng example.
ID NAME
1
2 BBB
3