How to transfer specific data from one workbook to another using vba

Hi,

I am very new in the use of excel vba and require some advice. My source data is a master spreadsheet that has column A to I filled with information. All subsequent workbooks will have the same headers. My queries is in 2 parts.

Part 1
The master spreadsheet contains the workload of a team with each row representing a task and being assigned to a team member. I would like each row that is assigned to an individual (column D) to be copied and pasted into their individual workbook (1 workbook per team member). The row is to be pasted on the first available row of the target workbook.
The master spreadsheet will be opened when new entries are to be added and then closed. No data is to be removed from there.


Part 2
Each team member's workbooks will have a tab called "active" where all the task assigned to them are written. the Column A contains the status of the task and I would like for each task that has for status "complete" to be transferred to a second tab that will be called "complete"
I repeat that all workbooks will have the same headers.

I hope it all make sense and that you will be able to assist me.
Please let me know if you require any additional information.

Hi alansidman,

I attached the master spreadsheet. The other spreadsheet represent a team member's individual workbook, LR being the member in question. The "before" only contains headers.
The "after 1" shows the spreadsheet as it should be after the first part of the process with all tasks delegated to LR being transfer that that workbook.
The "after 2" shows the second part where all tasks with "complete" status being moved to the complete tab.

thank you for reminding me, here are the cross posting links

http://www.mrexcel.com/forum/excel-q...lications.html

http://www.excelguru.ca/forums/showt...ed=1#post25386