Copy data from one sheet to another based on a certain criteria

S

shina67

Board Regular
Joined
Sep 18, 2014
Messages
138
Hi,
I have a workbook with several tabs within it.
I am wanting to copy into the tab 'Stafforce' the name, surname and hours from the 'Fire Reg' tab.
The criteria that has to be met is the clock/jw no matching the same number in the 'stafforce' tab. The relevant hours to be in the relevant days against the relevant name.
I hope this makes sense. I have put a link to my workbook if that helps.
Thanks in advance for any help.

https://www.dropbox.com/s/d60ozbk1yyz7xvj/Week 23.xlsx?dl=0
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

Kaz09
  • Question
Copy rows of data from multiple worksheets to based on column equalling YES
Replies
0
Views
96
Kaz09
Kaz09
Kaz09
  • Question
Copy rows from multiple sheets based on data
Replies
1
Views
128
Fluff
Fluff
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
184
Insurance Dave
I
M
  • Question
VBA code to create command button and copy criteria based data from one worksheet to another
2
Replies
13
Views
426
Tupe77
T
gheyman
  • Solved
Copy from one workbook to another (just format and values)
Replies
2
Views
411
gheyman
gheyman

Forum statistics

Threads
1,214,384
Messages
6,119,201
Members
448,874
Latest member
Lancelots

Share this page

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

Which adblocker are you using?

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
Back
Top