Hello,
I would like to ask some help in that how to extract the data of the last same rows (and summarize cells if match with the criteria) to another sheet. I am working on more days but now I completly stucked in.
I have attached the sample file with the expected result of macro run, please see it!
Thank you in advance!
Could somebody help me?
need some more clarification
as per your provided data last three rows (12,13,14) (date,mode,customer) same so we consider that as last row this is fine here,
however if 12 & 14 same then what the output u want
if 12 & 13 same then what the output u want
if 13 & 14 same then what the output u want
if 12 , 13 ,14 not same then what ...?
Last edited by Naveed Raza; 07-02-2014 at 01:35 AM.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Pl see attached file with macro.
There are lots of online free tools that help you to extracting new data save from virus what ever.
Try the attached
Hello,
kvsrinivasamurthy, Jindon I would like to say thank you for your help. Both solutions are perfect!
@kvsrinivasamurthy
Your idea is that what I find. Please, receive my reputation!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks