MACRO to FILTER data then copy the data to another SHEET.
HEY!.....
im a newbie in macros....
and i need help......
i want to filter the "COMPARISON" sheet by it's column "CpK" with condition CpK<1.67.......
afterwards, i need to copy the whole data(all columns) to the "CpK" sheet...
then with the same process but the condition is Cp<10 copy, then paste to the "Cp" sheet.......
i hope it will be solved.....
*im sorry i couldn't attach the file due to it size
Please Login or Register to view this content.
Perhaps this will get closer:
Please Login or Register to view this content.
_________________
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!)
wow!!!!!
THANKS!
AHAHAHAHAHAH,........
dont need for another week......
ehehehehehehehe.......
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
is this may be applicable to all my datas?....
because my datas range varies.....
Your question is unclear.
i mean......is this "code" will be applicable if my data varies?.....
---------- Post added at 05:20 PM ---------- Previous post was at 05:19 PM ----------
in range.....
---------- Post added at 05:26 PM ---------- Previous post was at 05:20 PM ----------
ok thanks!....i just need this data to be summarized asap....and you're a great help!.....i'll just post another thread regarding this matter......THANKS AGAIN AND GOD BLESS!
The code is yours to edit regarding any changes to the layout of your data. Test it, tweak it, own it, baby.
thank you again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks