Dear all;
I have data table with following conditions:
+ Row from 1 to 14000.
+Column from A to DTY
I need VBA to make this function find and copy/paste as below:
+ I’ll type the name of string need to find in cell A1, B1,..(can expand later) to cell M1 of Sheet2
+ Be based on my strings, VBA will find in Sheet1.
+ Copy the value found to Sheet2
Maybe it’ll clear with this example:
<tbody>
</tbody>
I appreciate all your support
Thank you!!!
Septimus
I have data table with following conditions:
+ Row from 1 to 14000.
+Column from A to DTY
I need VBA to make this function find and copy/paste as below:
+ I’ll type the name of string need to find in cell A1, B1,..(can expand later) to cell M1 of Sheet2
+ Be based on my strings, VBA will find in Sheet1.
+ Copy the value found to Sheet2
Maybe it’ll clear with this example:
Sheet1 (source) | |||||||||
| A | B | C | D | …….. | DTV | DTW | DTX | DTY |
1 | ID | Date | IN | Classify | …….. | ScaleA | ScaleB | ScaleC | Results |
2 | M001 | 011515 | 2000 | A | …….. | 0.5 | 0.3 | 0.2 | G |
3 | M002 | 011515 | 2000 | B | …….. | 0.5 | 0.3 | 0.2 | G |
4 | M003 | 011515 | 2000 | A | …….. | 0.5 | 0.3 | 0.2 | F |
5 | ID | Date | IN | Classify | ScaleA | ScaleB | ScaleC | Results | |
6 | M005 | 011515 | 2000 | A | 0.4 | 0.3 | 0.3 | F | |
7 | M006 | 011515 | 2000 | D | 0.4 | 0.3 | 0.3 | B | |
…. | …. | …. | …. | …. | …. | … | … | … | … |
13998 | ID | Date | IN | Classify | …. | ScaleA | ScaleB | ScaleC | Results |
13999 | M002 | 011515 | 2000 | D | …….. | 0.2 | 0.1 | 0.5 | F |
14000 | M006 | 011515 | 2000 | A | …….. | 0.2 | 0.1 | 0.4 | B |
Sheet2 (result) | |||||||||
| A | B | C | D | M | | | | |
1 | ScaleA | ScaleC | Classify | …. | …. | | | | |
2 | 0.5 | 0.2 | A | …. | …. | | | | |
3 | 0.5 | 0.2 | B | …. | …. | | | | |
4 | 0.5 | 0.2 | A | …. | …. | | | | |
5 | ScaleA | ScaleC | Classify | …. | …. | | | | |
6 | 0.4 | 0.3 | A | …. | …. | | | | |
7 | 0.4 | 0.3 | D | …. | …. | | | | |
…. | …. | … | | …. | …. | | | | |
13998 | ScaleA | ScaleC | Classify | …. | …. | | | | |
13999 | 0.2 | 0.5 | D | …. | …. | | | | |
14000 | 0.2 | 0.4 | A | …. | …. | | | | |
<tbody>
</tbody>
I appreciate all your support
Thank you!!!
Septimus