Dear sirs,
In Sheet A i have 3 column data as under
A B C
Raju 100 50
Sameer 0 0
Sathyan 588 26
Nileesh 0 0
shyam 300 548
i wanted to copy this data to Sheet B with a formula in the same order without the zero holded rows ( ie. Sameer, sathyan)
I hope somebody will help in this matter
thanks and regards
nowfal
Make sure row 1 has column headers, like "Name", "Data", etc.
Click on Data > Filter > AutoFilter
Click on the drop down arrow for column B and select Custom
Select Greater than: 0
You don't have to copy this to another sheet since you can now seen and work with the filtered data, but you CAN copy it. IF you highlight everything left visible and copy to another sheet, all the hidden rows will be excluded.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Sir,
can u help me to put a line of code with the if statement, like if any of the b colomn is zero remove that particular row and all.
[Sub ABD()
'
' ABD Macro
' Macro recorded 31/08/2009 by user
'
'
Range("A1:C5").Select
Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste
End Sub]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks