hello...
i want to copy column A,D,E,F from sheet 1 to sheet 2 column B,C,D,F...
I have a sheet titled "Main" that contains the raw data like the example below. I have another sheets titled "Orders" and . I'm needing a code to copy the data only from column A,D,E,F in "Main" sheet, and paste it in the "Sheet 2" column B,C,D,F based on "sell & buy" values
Sheet(main)
<tbody>
</tbody>
Sheet(Orders)
<tbody>
</tbody>
Any help is MUCH appreciated THANK YOU!!
i want to copy column A,D,E,F from sheet 1 to sheet 2 column B,C,D,F...
I have a sheet titled "Main" that contains the raw data like the example below. I have another sheets titled "Orders" and . I'm needing a code to copy the data only from column A,D,E,F in "Main" sheet, and paste it in the "Sheet 2" column B,C,D,F based on "sell & buy" values
Sheet(main)
A | B | C | D | E | F |
ORDER TYPE | #ORDERS | PRICE | % | ||
BUY | 1 | 45.78 | 0.1 | ||
SELL | 23 | 2354.67 | 0.15 | ||
- | - | - | - | ||
BUY | 345 | 6789 | 0.23 |
<tbody>
</tbody>
Sheet(Orders)
A | B | C | D | F | G |
A1 | BUY | 1 | 45.78 | 0.1 | |
B2 | SELL | 23 | 2354.67 | 0.15 | |
C1 | BUY | 345 | 6789 | 0.23 | |
D1 |
<tbody>
</tbody>
Any help is MUCH appreciated THANK YOU!!