aldrinproto
New Member
- Joined
- Oct 3, 2021
- Messages
- 8
- Office Version
- 2013
- 2010
- Platform
- 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
then i want to paste it on this wworkgroup corresponding their code_no and sheetname
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 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | Timestamp | Email_Address | Data_Sharing_Agreement | Code_No | Laboratory_Name | Testing_Platform | MDate_Reporting | Date_Submitted | Max_Test_Capacity_Day | Samples_Received_Yesterday | Plates_Run_Yesterday | Plates_Yesterday_PTC_Failure | Plates_Yesterday_NTC_Failure | Percentage_Yesterday_IC | Samples_Repeat_Tested_Yesterday | Reasons_Repeat_Tested | Events_Recorded_Yesterday | Resolved | ||
2 | 2021-09-14 11:46:54 | bghmcpcrlab@yahoo.com | Yes,Yes,Yes | 2021-LAB-010 | Bataan General Hospital and Medical Center | rt-PCR | 2021-09-14 | 1000 | 836 | 10 | 0 | 0 | 0.00 | 59 | Confirmation of initial result | None | No | |||
3 | 2021-09-13 11:00:31 | bghmcpcrlab@yahoo.com | Yes,Yes,Yes | 2021-LAB-010 | Bataan General Hospital and Medical Center | rt-PCR | 2021-09-13 | 800 | 216 | 3 | 0 | 0 | 0.00 | 0 | Not Applicable (if no repeat-tested sample) | None | Not Applicable | |||
4 | 2021-09-13 11:00:31 | bghmcpcrlab@yahoo.com | Yes,Yes,Yes | 2021-LAB-011 | Bataan General Hospital and Medical Center | rt-PCR | 2021-09-13 | 800 | 216 | 3 | 0 | 0 | 0.00 | 0 | Not Applicable (if no repeat-tested sample) | None | Not Applicable | |||
Report Filter |
then i want to paste it on this wworkgroup corresponding their code_no and sheetname
try.xlsm | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
4 | Timestamp | ||||||||||||||||||||||
5 | Email_Address | ||||||||||||||||||||||
6 | Data_Sharing_Agreement | ||||||||||||||||||||||
7 | Code_No | ||||||||||||||||||||||
8 | Laboratory_Name | ||||||||||||||||||||||
9 | Testing_Platform | ||||||||||||||||||||||
10 | MDate_Reporting | ||||||||||||||||||||||
11 | Date_Submitted | ||||||||||||||||||||||
12 | Max_Test_Capacity_Day | ||||||||||||||||||||||
13 | Samples_Received_Yesterday | ||||||||||||||||||||||
14 | Plates_Run_Yesterday | ||||||||||||||||||||||
15 | Plates_Yesterday_PTC_Failure | ||||||||||||||||||||||
16 | Plates_Yesterday_NTC_Failure | ||||||||||||||||||||||
17 | Percentage_Yesterday_IC | ||||||||||||||||||||||
18 | Samples_Repeat_Tested_Yesterday | ||||||||||||||||||||||
19 | Reasons_Repeat_Tested | ||||||||||||||||||||||
20 | Events_Recorded_Yesterday | ||||||||||||||||||||||
21 | Resolved | ||||||||||||||||||||||
22 | Percentage_Result_Release_Today | ||||||||||||||||||||||
23 | Reason_Delay_TAT | ||||||||||||||||||||||
24 | Improve_Form | ||||||||||||||||||||||
25 | Percent_Torc | ||||||||||||||||||||||
26 | Percent_Greater_48TAT | ||||||||||||||||||||||
27 | PTC_Failure_Percent | ||||||||||||||||||||||
28 | Ntc_Failure_Percent | ||||||||||||||||||||||
29 | IC_Failure_Percent | ||||||||||||||||||||||
30 | Throughput | ||||||||||||||||||||||
31 | region | ||||||||||||||||||||||
32 | province | ||||||||||||||||||||||
2021-COVIDLAB-010 |