Copy cell data to another cell

shaunB

New Member
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

Last edited:

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

onlyadrafter

Well-known Member
Hello,

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

shaunB

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

onlyadrafter

Well-known Member
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

New Member
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

Replies
3
Views
674
Replies
11
Views
334
Replies
13
Views
457
Replies
3
Views
2K
Replies
6
Views
206

Threads
1,191,092
Messages
5,984,604
Members
439,896
Latest member
SquareCare

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back