Copy cell data to another cell

[shaunB]

Hi All,
I am pretty new to Excel but may of bitten off more than i can chew with a work task.

I am building up a Bradford factor spreadsheet, Each individual employee has there own tab where info from the summary tab needs to be transferred to. Wow this is complicated to explain!

ok on the summary tab I have (Col A) Employee Name(Col B) Sickness Date (Col C) and Number of days.
I have a spreadsheet tab for each indivisiual employee.

I need th data from the above cols mirroring in the specific employees spreadsheets, but only if There name appears in Col A of the summary.
Hope this makes sense. Can anyone steer me in the right direction please.

ShaunB

 

[onlyadrafter]

Hello,

does the persons name appear anywhere on their individual tab sheet, and if so which cell?

 

[shaunB]

Hi Thanks for the quick reply. In answer yes A1 on all

 

[onlyadrafter]

Hello,

on each Persons sheet, put this formula in B1

=IF(ISERROR(MATCH($A$1,Summary!$A:$A,0)),"",VLOOKUP($A$1,Summary!$A:$C,COLUMN(),0))
and copy over to C1.

If these results are not required in B1 & C1 post back with their destination.

 

[shaunB]

Hi The formula makes a list on the employers sheet. I need it to pick each instance of sick out for th emploe and place thm on the individual employee sheet from the summary.

Summary Sheet (inputted)
Employee Name Reason for sick Date Total days
Joe Bloggs Tooth 10/10/2009 2
Jane Joe Headache 21/02/2009 5
Joe Bloggs Sprain 22/03/2009 4



To display on Individual employees sheet
Reason for sick Date Total days (=Joe Bloggs sheet)
Tooth 10/10/2009 2
Sprain 22/03/2009 4

Jane Doe's sheet
Reason for sick Date Total days
Headache 21/02/2009 5

Hope this makes it easier to understand from my previous post.
Thanks
Shaunb