Filter range and copy selected column visible data and paste other sheet
Hi
With sheets(summarty) have range g4: z500
I want to filter field 4 > criteria=">0" and copy
Range G4:G, I4:I, J4:J And K4:K till last visible row and paste them to sheets("sid")
Range A:A, B2:b, C2:C And D2:D TO Paste Data Below the Last Used Row
Thank you
Last edited by HaroonSid; 06-19-2017 at 10:32 AM.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Maybe:
Please Login or Register to view this content.
Thank you John
Is any other metod to do this with faster then this
Because this ode is copy pasting range two time and this process is taking long time with lots of data
Can you attach a sample with some dummy data. Normally using a filter method is faster than looping, and should produce a satisfactory result. Perhaps you have something else going on there.
For future
Please Login or Register to view this content.
Hi, John
Ok will post sample workbook tomorrow
Now i am on phone
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks