copy mastersheet data to different tabs in another workbook based on cell value

aldrinproto

New Member
Joined
Oct 3, 2021
Messages
8
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
hello guys, i want to copy my data to another workbook tab/sheet based on the cell value.
for example i have code_no "2021-LAB-0010" on my mastersheet data then it will paste on another workgroub sheetname "2021-LAB-0010"


sorry for my bad english


this is my mastersheet

New Data.xlsm
ABCDEFGHIJKLMNOPQR
1TimestampEmail_AddressData_Sharing_AgreementCode_NoLaboratory_NameTesting_PlatformMDate_ReportingDate_SubmittedMax_Test_Capacity_DaySamples_Received_YesterdayPlates_Run_YesterdayPlates_Yesterday_PTC_FailurePlates_Yesterday_NTC_FailurePercentage_Yesterday_ICSamples_Repeat_Tested_YesterdayReasons_Repeat_TestedEvents_Recorded_YesterdayResolved
22021-09-14 11:46:54bghmcpcrlab@yahoo.comYes,Yes,Yes2021-LAB-010Bataan General Hospital and Medical Centerrt-PCR2021-09-14100083610000.0059Confirmation of initial resultNoneNo
32021-09-13 11:00:31bghmcpcrlab@yahoo.comYes,Yes,Yes2021-LAB-010Bataan General Hospital and Medical Centerrt-PCR2021-09-138002163000.000Not Applicable (if no repeat-tested sample)NoneNot Applicable
42021-09-13 11:00:31bghmcpcrlab@yahoo.comYes,Yes,Yes2021-LAB-011Bataan General Hospital and Medical Centerrt-PCR2021-09-138002163000.000Not Applicable (if no repeat-tested sample)NoneNot Applicable
Report Filter









then i want to paste it on this wworkgroup corresponding their code_no and sheetname



try.xlsm
ABCDEFGHIJKLMNOPQRSTU
4Timestamp
5Email_Address
6Data_Sharing_Agreement
7Code_No
8Laboratory_Name
9Testing_Platform
10MDate_Reporting
11Date_Submitted
12Max_Test_Capacity_Day
13Samples_Received_Yesterday
14Plates_Run_Yesterday
15Plates_Yesterday_PTC_Failure
16Plates_Yesterday_NTC_Failure
17Percentage_Yesterday_IC
18Samples_Repeat_Tested_Yesterday
19Reasons_Repeat_Tested
20Events_Recorded_Yesterday
21Resolved
22Percentage_Result_Release_Today
23Reason_Delay_TAT
24Improve_Form
25Percent_Torc
26Percent_Greater_48TAT
27PTC_Failure_Percent
28Ntc_Failure_Percent
29IC_Failure_Percent
30Throughput
31region
32province
2021-COVIDLAB-010
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

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