Hello,
I need to filter by Sample ID (Sample 1, 2, 3, 4) and also by pairs of Types (001 & 002, 003 & 004 or 006 & 007). An example of Master Data filtered by Sample 1 in Column A and Type 001 & 002 in Column B is included in link to spreadsheet that I am trying to create. How do I to use formulas to automatically populate newly filtered results to the Filtered Data.
https://drive.google.com/open?id=1rB...x6qKJEr09ibVJj
Best,
Francis
Please attach the file directly here - instructions up at the top of the page.
Is this an Excel or Google Sheets question?
Last edited by AliGW; 12-29-2019 at 03:21 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Frankcase
you just need to bring your source to Power Query and un-Pivot it then load it to Excel, Pivot it and use slicers to be your filters for types and Sample ID
Each time when you update your source in Excel, just goto last two tabs and right click refresh
Christopher Yap
Hi,
Here is a crude excel macro example of what I am trying to do. But how do I create a button/dropdown list or combo box to select a Sample (Sample 1, 2, 3 or 4) with a pair of Types (001 & 002, 003 & 004 or 006 & 007)
Sample
Sample 1
Sample 2
Sample 3
Sample 4
Type
001_Element 1_No IS
002_Li_IS 1_IS_I
003_Element 2_No IS
004_B_IS 2_IS_II
006_Element 3
007_IS 3
After the above selection is made. The Master data is filtered based on the above selection and the filtered data is automatically copied to the filtered data sheet
I recorded a macro that achieves that goal but would like be able to have this process automated with a couple of clicks
Once again, is this solution needed for Excel or Google Sheets?
Excel 2016
Last edited by AliGW; 12-30-2019 at 08:32 AM. Reason: Please don't quote unnecessarily!
Aligw,
Any ideas to solve this excel 2016 macro problem for data organization?
Best,
Francis
No, sorry - VBA is not my area of expertise - but I'll move this to the VBA section.
Administrative Note:
Unfortunately, this is a duplicate thread …
Please see Forum Rule #5 about thread duplication.
Mrrc,
Hi it got moved bt AliGW to the VBA forum. Does that mean I have to delete the other message?
Wait for a moderator explanation …
This thread was moved this morning to the VBA section. There is no duplicate of it that I am aware of.
MarcL - please provide a link to the thread that you think is a duplicate.
Frankcase - what 'other message' are you referring to?
Last edited by AliGW; 12-31-2019 at 10:46 AM.
Maybe I'm wrong for the duplicate but not for the wild cross posting on at least two others forums
where he yet got solutions according to the level of his 'explanation' …
If there have been cross posts, then please report them to us using the report button. Thank you.
@Frankcase - there will be no further help here until you respond to the accusation of cross posts with links to them.
Last edited by AliGW; 12-31-2019 at 01:10 PM.
In fact I'm right for the duplicate, initial thread with cross post links :
Dynamically Filter Data in two columns to a different sheet …
Last edited by Marc L; 01-01-2020 at 09:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks