Hi friends,
I have a report, from which i need only specific data. Not anything else. Rest of the report i dont need it.
I have attached sample report, in sheet1 i have highlited where the data is present. In sheet2 i specified 4 fields that i required. Pls help me. To set some vba code....
guys pls see both sheet1 and sheet2. i need output..no matter if its in same workbook or separate workbook. Both are fine.
Give this a try:
Please Login or Register to view this content.
Last edited by JBeaucaire; 06-09-2012 at 08:55 AM.
_________________
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!)
Hi Beaucaire,
This is really very quick and appreciatable help you have done. Also I need 3 conditions to be included as well in this code.
i.e., in column C , D & E. CODE - i need only D64, D69 , AMOUNT - i need only 3 amounts which is equal to eg. 250, 400, 580 only these three amounts & DATE in dd/mm/yyyy format.
So fileds code, amount & date. the codes which is equal to d64 & d69, which is having amount of 250, 400 & 580 amounts. Date should fall in with dd/mm/yyy format.
i hope i said clear enough. This would be my last help i request.
The macro collects all the data pretty quickly. Certainly you can apply an Autofilter to the result to get down to a smaller subset?
Yea thats right!.
But really really thanks much for your help....and support.
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks