auto copying from one sheet to another

I have a master list of files.

• Each file is assigned to a person (4-5 people total).
• Each file has a unique number assigned to it.
• Each person has their own sheet listing the files Assigned to them.

I'm trying to make Excel copy the the information entered on the master list
(its one row per file)
to the sheet of the person assigned to it.

[col1] [col2] [col3] [ID #(col4)] [col5] [col6] [person assigned(col7) [col8]

Hi,

In the destination worksheet type
=
go to the source worksheet and source cell
press enter

HTH
Carim

its not referencing I need it that I add a row of info then(automaticlly or by using a MAcro)
It copies the the row information to the corosponding
Sheets that match the person assigned to their corrsponding sub-sheet
also makes sure not to make duplicates using the unique ID number of each file.
God I feel like a teacher making up an assignment

Sorry I totally misunderstood your request ...

What you are after is much more challenging ...

For precise answers, would you mind sharing with us your file in a zipped way ?

Carim

Here is the file

Okay so November is the main list
The name of the sheets matches to the BDA (sort of)
- the names on the sheets are the BDA assistants if need be I can rename the sheets with the BDA names

So we enter the info into the November sheet (then either automatically or by using a macro) it copies the row info to the BDA's matching sheet
Making sure not to make duplicate rows (probably by using the Loan number each file has its own)

OK I understand you request now ...

Solution is with Data Filter Advanced Filter

where you can select Database, Criteria, Extract

Best approach is to start with a tiny sample to get familiar with the tool and then adapt it to your specific requirements

HTH
Carim

Thank you I'll let you know how it goes

Do not hesitate to share your various questions, if need be ...

Cheers
Carim