Copy matching lines
 

I have 2 workbooks, Ill call them wb1 and wb2.

On wb2 I have on Row 1 The Column Headings like this:

CustID | Name | Work Performed | Done? |

Below the title heading are many rows with different info under each.
Under the 'Done?' column, there will be either a "n" or a "y".

Now on wb1 I have a cell (call it cell H9). When I put a number in cell
'H9', I want the macro to look for that same number on wb2 under
"CustID", and any line containg "n" under the Column Heading, I want to
insert this line(s) on Row 18, on wb1. For each line it copies over, I
want it to make a new line so it isnt copying them onto the same Row.
It must start at Row 18 and continue down.

Any Ideas?


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=497037

Copy matching lines
 

I edited the post to be more desciptive, hope it helps.


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=497037