Copy entire row from multiple workbooks to a master workbook if condition was met

Hi All,

I'm a newbie in Macros and I need help in this project. To give you a background, I have 10 users of my template (all in the same format) and located in shared folder. This template basically use as blotter of all trades/deals (buyer/seller) done by each user and once the checkbox was hit, it automatically prints their trade ticket. The user who will print the ticket is the "buyer" of the trade. We can determine which is the buyer of the trade by the list of clients of each user.(8 clients per users at most).
What I want to do is:

1. from the template, add a button that will copy the data from the entire row if the user of the template is the "buyer" of the trade.
2. copy the data to a master workbook/file
3. and if the other user clicks the button, the macro will locate the next available row in the master file.

hope you can help me with this.

thanks in advance.

Its better to bump the previous thread on this same question than creating a duplicate thread.

Continued on another thread.

Thread Closed