Copying values from cells if another cell contain value
 

Hello.

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

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

/Ander

+-------------------------------------------------------------------
|Filename: vol.txt
|Download: http://www.excelforum.com/attachment.php?postid=3733
+-------------------------------------------------------------------

--
a94andw
-----------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=39858

Copying values from cells if another cell contain value
 

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" wrote in message
...

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

Copying values from cells if another cell contain value
 

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.


Code:
--------------------
SupNr VOLYM Host OMSH LB1 LB2 LB3 LB4 ANT.
5023 654593559 14860766 4404 30 8 2 20 30
12051 17732595 12461064 142 36 14
245 191478676 9918760 1930 48 67 33 10 21
7042 80010210 9378659 853 16 2 67 8 47
6600 268889664 7966356 3375 8 2 37 27 39
139 57732378 6862498 841 16 45 22
--------------------



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.


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=398582