Copy data maybe with an IF formula but without leaving gaps

[Lisa13]

Hi, I have a table of data, it is a list of actions for different team members, so the columns are: A1 = action number, A2 = name of the team member, A3 the Action assigned.
I want to have 1 central database of actions with all of the teams work related actions on, this is the main source, BUT each team member also has other personal actions like training etc. that need to be private/separate from the team tracker, so rather than them having to open 2 trackers I want to build them 1 spreadsheet which extracts the data from the main SOURCE data table and which also allows them to add in their personal actions. I have used an IF formula which selects from the source table which says if you find this name then copy this line of date in to this new spreadsheet, it works but!...because there are multiple lines...over 200 lines etc. that means the spreadsheet copies like for like to the personal action tracker, so all the lines without their names on are blank...what formula do I have to use so that their action tracker will show their actions on consecutive lines even if the information in the source data is 20 lines apart?. Please help.

 

[DanteAmor]

Hi, I have a table of data, it is a list of actions for different team members, so the columns are: A1 = action number, A2 = name of the team member, A3 the Action assigned.
I want to have 1 central database of actions with all of the teams work related actions on, this is the main source, BUT each team member also has other personal actions like training etc. that need to be private/separate from the team tracker, so rather than them having to open 2 trackers I want to build them 1 spreadsheet which extracts the data from the main SOURCE data table and which also allows them to add in their personal actions. I have used an IF formula which selects from the source table which says if you find this name then copy this line of date in to this new spreadsheet, it works but!...because there are multiple lines...over 200 lines etc. that means the spreadsheet copies like for like to the personal action tracker, so all the lines without their names on are blank...what formula do I have to use so that their action tracker will show their actions on consecutive lines even if the information in the source data is 20 lines apart?. Please help.

You could upload some examples, what you have in your source sheet and the result you expect.
Please, explain on the sheet the examples of what you need.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.