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.
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.