Copying values from cells if another cell contain value

[a94andwi]

Hello.

I have a sheet that contains data. In Column F, G, H and I , I have a number that is the person in charge of a part number.
The same number is in different columns and I want to split all part numbers and copy them to a different sheet for those who have the same number in the columns mentioned before.

Please se attached file vol.txt and hopefully you'll understand.

/Anders

[Bernie Deitrick]

Anders,

Repost with a small sample table of your data, and show what you want as your end result, within the
post. Few people will open files, for obvious reasons.

HTH,
Bernie
MS Excel MVP


"a94andwi" <[email protected]> wrote in message
news:[email protected]...
>
> Hello.
>
> I have a sheet that contains data. In Column F, G, H and I , I have a
> number that is the person in charge of a part number.
> The same number is in different columns and I want to split all part
> numbers and copy them to a different sheet for those who have the same
> number in the columns mentioned before.
>
> Please se attached file vol.txt and hopefully you'll understand.
>
> /Anders
>
>
> +-------------------------------------------------------------------+
> |Filename: vol.txt |
> |Download: http://www.excelforum.com/attachment.php?postid=3733 |
> +-------------------------------------------------------------------+
>
> --
> a94andwi
> ------------------------------------------------------------------------
> a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
> View this thread: http://www.excelforum.com/showthread...hreadid=398582
>

[a94andwi]

Here I have uploaded a small sample data that you can help me with maybe.

The columns Lb1-L4 contains a number that I want one new row for each number. If the same number appears twice in LB1-LB4 I only want one row.

What I'm trying to do is a simple autofilter where the same number in LB1-LB4 is shown. Today if I use autofilter on one column many of the other columns that contain the same number is hidden and I can't see them.

Each number in LB1-LB4 is a number connected to one person. I want to be able to filter out each row that contains one persons number and so on.

I hope you understand what I mean.

Please Login or Register  to view this content.

I was able to copy and paste this data directly into excel. I hopw it works for you as well. Copy the text and paste it in notepad. Copy the pasted data and then paste it into excel.

Heres what I want to do but don't know the syntax for:

1. Loop through all the rows
2. If value in LB1 = 34 then copy row to separate worksheet
3. If value in LB2 = 34 then copy row to the new created worksheet
4. If value in LB3 = 34 then copy row to the new created worksheet
5. If value in LB5 = 34 then copy row to the new created worksheet

I'd allso like to add a function that searches the fields LB1-LB4 and puts all the values in an array. Then I could use this array to make one new worksheet for every number that the array contains. This is definately an add-on. If I could get help with the first part at first then it would make my day.

/Anders