Copy Cells

  • Thread starter Thread starter digitallifeform
  • Start date Start date
D

digitallifeform

Hi all

I have a spreadsheet which has lots of calls logged on it. Each call is
logged by a person. I have a tab for each person.

What i need to do is each persons tab needs to pick up the information
for that person (pick it out of the main sheet which has everyones call
on it).

So any cell in column 'A' with the name 'Joes Bloggs' needs to copy
accross to tab 'Joe Bloggs' along with the rest of the information on
that line.

Hope this makes sense, if you dont understand reply with a question.

Thanks in advance

Darren
 
=Small(if(Master!$A$1:$A$500="Joe Bloggs",Row($A$1:$A$500)),row(A1))

Entered with Ctrl+Shift+Enter, then drag fill down the column will give you
the row numbers of the rows in Master which contain Joe Bloggs. You can use
this information with Offset or Index to retrieve your information.
 
Back
Top