hi
I am currently using following macro which I found from forum (thanks), however now I would like to collect information if column B value is equal to "Europe"
Answer should be in Dropdown list
Please Login or Register to view this content.
Please help me
_____
data column C
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-20-2014 at 08:42 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Thank you very much for taking time to review, I have attached a sheet of data and requirement (before and After), the macro has no implication on the data, it should extract distinct unique information (preferably alpha sort) in a separate summary sheet, which enables to make summary sheets on unique item. Currently I am using excel array formula to get this information but it has slow down the worksheet, as the number of records are more than 300,000.
See the attached,
Please Login or Register to view this content.
Last edited by davesexcel; 12-20-2014 at 09:11 PM.
Hello Amir,
I've restored this thread to normal and modified your post #1 to be forum-rules compliant. I know you're new, and let me say welcome.
But do take a moment to read and understand the forum rules, the link is above in the menu bar. We all abide these rules for everyone's overall benefit, as must you. Note particularly rules #1 and #3, they are the most common broken by newcomers.
(hat-tip)
Last edited by JBeaucaire; 12-20-2014 at 08:56 PM.
_________________
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!)
What's up man!
Last edited by davesexcel; 12-27-2014 at 08:32 AM.
Just done a similar problem
http://www.excelforum.com/excel-prog...down-list.html
Last edited by jindon; 12-20-2014 at 10:18 PM. Reason: Attachment revised
Dear Gurus / Friends
The solution seem fine to me, however when I used the macro with my real data, it does not give the desired results, as I explan the data is very Dynamic the regions can increase or decrease same is with other columns data. for this specific reason I am using above code (VB code on top). What I need an array forumla which can extrat unique distinct information from my data of any Column based on criteria like ABC[country]. Same feature we use in Pivot table, if I select Country "SOM" it filters all info related to SOM, but this information is unique, so the macro should copy code "120130" and 120131 in a column "summary" sheet. So I can use sumifs function to get the financial information.
summary.JPG
Sorry If I was not very clear
Who are you talking to?
Posting picture doesn't help at all anyway.
jindon
The Macro you shared was really good, as I explained, I like to have some thing really dynamic, what I wnat is to have a macro which can extract unique information from hundread of thousand rows based on one to two critetia.
I know for you guys its simple but I was truggling to modify code which i share earlier
thank you
What you are asking is too abstract.
I am really sorry I wasted your time, just a last attempt
I have attached data table with desired results and my logic to obtain that result. With additional explanation of my data.
Thank you in advance for all your patience. I have improved my skills from looking many examples through this forum, and keep posting it It really helps the masses.
You can filter the data then do whatever you want with , check out the attached example..
Change A2 to get the list for B2, then select B2 to get the filtered data.
thanks for the help, this is very usefull
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks