I am not very technical so simple answers please.

I also cannot send the worksheet as my work computer cannot send information out.

I want to find out if its possible to have a whole row of information copied to another worksheet depending on what value was selected from a drop down in a specific cell?

For example In cell...
A2 I have the date
B2 I have the Advisers Name
C2 I have written text
D3 I have the drop down option telling me who the advisers manager is.

So Say for example the advisers manager is Manager X.

I have a separate worksheet for Manager X to collate all the information specific for their team but maintaining the master worksheet with all of the information.

Any help would be greatly appreciated.