Thread
:
Finding data
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Finding data
I would use a macro that makes a unique list and copies it to the other
sheet and then goes down that list using FINDNEXT to add each
find.offset(,1) to the list.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Byron720" wrote in message
...
I hope someone can help me on this:
I have an inventory database where thousands of parts have different bin
locations. What I need is a formula(s) that can tell me all bin locations
where a part is located but horizontally. For example, I have a master
data
that looks something like this:
Part # Bin Locations
1111 A1
2222 B5
3333 G7
1111 H9
7777 C2
8888 D1
1111 E3
4444 F8
5555 A3
6666 H2
2222 B9
3333 E2
Then, in sheet 2 my final result should be something like this:
Part # Location 1 Location 2 Location 3 Location 4
etc
1111 A1 H9 E3
2222 B5 B9
3333 G7 E2
4444 F8
5555 A3
6666 H2
7777 C2
8888 D1
Data on Part # column should be entered manually and the Bin Location info
automatically after I typed the part #
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett