EXCEL Macro issues
Ok I have 2 different work books...1: Post Date Log...2: Promise to Pay Log...

What I have in the promise to pay log is a table that has headers of:

 - account
 - date
 - payment date
 - customer name
 - balance
 - payment
 - payment method
 - status
 - phone
 - paid?

the post date log table has the following table headers.

 - account
 - date
 - payment date
 - customer name
 - amount
 - payment type (different then payment method)

What I want it to do is check each row to see if paid? has a Y in it then in needs to copy

 - account
 - date
 - payment date
 - customer name
 - payment
 - payment method

to the post date log table....

I want it to paste it in the exact same order...
Is this possible with two work books or would it be faster and more logical to do it in one workbook with seperate worksheets....

also to throw a kink into thinks I need it to put it into the right month based on the payment date... in post date log i have the work sheets:

 - JUN 11
 - JUL 11
 - AUG 11
 - SEP 11
 - OCT 11
 - NOV 11
 - DEC 11

each worksheet representing its corresponding month...

any help is greatly appriciated...Microsoft Office 2007 if that is needed also
EXCEL Macro issues
===

Ok I have 2 different work books...1: Post Date Log...2: Promise to Pay Log...

What I have in the promise to pay log is a table that has headers of:

 - account
 - date
 - payment date
 - customer name
 - balance
 - payment
 - payment method
 - status
 - phone
 - paid?

the post date log table has the following table headers.

 - account
 - date
 - payment date
 - customer name
 - amount
 - payment type (different then payment method)

What I want it to do is check each row to see if paid? has a Y in it then in needs to copy

 - account
 - date
 - payment date
 - customer name
 - payment
 - payment method

to the post date log table....

I want it to paste it in the exact same order...
Is this possible with two work books or would it be faster and more logical to do it in one workbook with seperate worksheets....

also to throw a kink into thinks I need it to put it into the right month based on the payment date... in post date log i have the work sheets:

 - JUN 11
 - JUL 11
 - AUG 11
 - SEP 11
 - OCT 11
 - NOV 11
 - DEC 11

each worksheet representing its corresponding month...

any help is greatly appriciated...Microsoft Office 2007 if that is needed also