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