Hello Everyone.
I hope some can help me .
I have workbook in excel 2010 which has 3 sheets in it.
On sheet 1 ( named Parts list ) in Column I there is a list of parts.
On sheet 2 ( named Shortage Screen ) is a spreadsheet using columns A to R , Column B has the parts number in it. There is also multiple entries with the same part number.
What i need is the rows on the shortage screen which match the parts list off the parts list sheet ( including the muliple Parts ) to be pasted onto sheet 3 starting on row 2.
Parts list spreadsheet Shortage Screen Sheet 3 I A B C D E A B C D E
1234 2 1234 abc 5 h 2 1234 abc 5 h
2345 10 9999 dfg 7 a 9 2345 hjk 3 i
4567 9 2345 hjk 3 i 20 1234 bnm 2 h
6789 20 1234 bnm 2 h
Hope this makes sense
Any help very much appreciated
Many Thanks
Dave
I hope some can help me .
I have workbook in excel 2010 which has 3 sheets in it.
On sheet 1 ( named Parts list ) in Column I there is a list of parts.
On sheet 2 ( named Shortage Screen ) is a spreadsheet using columns A to R , Column B has the parts number in it. There is also multiple entries with the same part number.
What i need is the rows on the shortage screen which match the parts list off the parts list sheet ( including the muliple Parts ) to be pasted onto sheet 3 starting on row 2.
Parts list spreadsheet Shortage Screen Sheet 3 I A B C D E A B C D E
1234 2 1234 abc 5 h 2 1234 abc 5 h
2345 10 9999 dfg 7 a 9 2345 hjk 3 i
4567 9 2345 hjk 3 i 20 1234 bnm 2 h
6789 20 1234 bnm 2 h
Hope this makes sense
Any help very much appreciated
Many Thanks
Dave