Hi,
I am new in excel programming.I need a VBA code to pull only required data rows in to another sheet of same workbook with matching 2 conditions values, that are Colum C above 100 and Colum D above 10.
My data range is A1:F550
I cannot use Data Filter and copy paste bcoz my sheet updates every minutes, so I need a VBA code for this.Please help me.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Mumps..thanks for your help.This code is not working for me, its not creating Sheet2 with requested data.could you please rectify.
When I tried the code on some dummy data, it worked as you requested. Could you post a copy of your file? It would be easier to help I could see how your data is organized.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks