Splitting up part numbers in to different sheets

[M4JIC]

Hi

Column 1 contains the part number and column 2 contains the socket codes it will fit into, there are 4 different sockets but over 1000 parts, what I am looking to do is have five sheets one for each socket. Parts are added to the database on a weekly biases.

The socket numbers are; 10, 20, 30, 40 these will each have a separate sheet.

PART 22 can either be used with a 20 socket or 2 number 10 sockets.

Coloumn 1 Sockets
PART 1 10
PART 22 20
PART 36 30
PART 95 40

Can someone help me on how to do this, any help is much appreciated.

[venkat1926]

the main sheet is called sheet1.

try this macro (keep the function also in the same module)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.