Hello, everyone. I was hoping someone here could help me figure this out. I've been going crazy trying to figure it out myself.
I need to create a formula that grabs all of my items in a certain type of category into a separate sheet. Here is what I mean.
Input Sheet
| item_|_type|
|_1___|__A_|
|_2___|__A_|
|_3___|__B_|
|_4___|__B_|
|_5___|__B_|
|_6___|__C_|
|_7___|__C_|
Output Sheet:
item
3
4
5
Can anyone help with this? Thanks in advance
Last edited by seikowatchesusa; 08-03-2011 at 08:28 PM. Reason: The problem was solved.
-->Berto<--
SeikoWatchesUSA.com
Hello,
I have attached the a sample worksheet which has the functionality you described. I have bound it to a button, but it can also be run by viewing macros. It is rather hard-coded, which means you will manually have to change the code if the table is longer, in a different location, sheets are called something different, and so on. If you have trouble adapting the code to your specific spreadsheet consider posting the actual spreadsheet.
Good luck!
The code is also here:
Please Login or Register to view this content.
Thanks I appreciate it. I'm messing with it right now.
I'm not very good with macros. I'm a little scared of them.Is there a way to use a formula?
I have to do some heavy modifying because I have to pull it from a textfile.txt file of over 4000 entries, an I have no idea how to do that in vb.
Last edited by seikowatchesusa; 08-03-2011 at 07:44 PM.
Hello,
See the attached.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Outstanding!! It took me a while to figure it out, but I got it working! Thank you! You saved me countless hours of work!Originally Posted by Haseeb A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks