Hi
I would macro to change data from vertically to horizontally with the same format
result
I will add new data every time in PURCHASE sheet.
thanks in advanced.
I would macro to change data from vertically to horizontally with the same format
| VR.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | CODE | CCS-1 | CCS-2 | CCS-3 | CCS-4 | ||
| 2 | CLIENT NO | CC2-TRB-1 | CC2-TRB-2 | CC2-TRB-3 | CC2-TRB-4 | ||
| 3 | INVOICE NO | INV-TRGG-1 | INV-TRGG-2 | INV-TRGG-3 | INV-TRGG-4 | ||
| 4 | ID-CC | IDTR-100 | IDTR-101 | IDTR-102 | IDTR-103 | ||
| 5 | BB-R | FFDOOD-1 | FFDOOD-2 | FFDOOD-3 | FFDOOD-4 | ||
| 6 | TT-Y | PACK-2 | PACK-3 | PACK-4 | PACK-5 | ||
| 7 | OR-GG | TTR | BBR | LLR | MMR | ||
| 8 | QTY | 60.00 | 10.00 | 5.00 | 10.00 | ||
| 9 | PRICE | $120.00 | $130.00 | $100.00 | $289.00 | ||
| 10 | TOTAL | $7,200.00 | $1,300.00 | $500.00 | $2,890.00 | ||
PURCHASE | |||||||
result
| VR.xlsm | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | CODE | CLIENT NO | INVOICE NO | ID-CC | BB-R | TT-Y | OR-GG | QTY | PRICE | TOTAL | ||
| 2 | CCS-1 | CC2-TRB-1 | INV-TRGG-1 | IDTR-100 | FFDOOD-1 | PACK-2 | TTR | 60.00 | $120.00 | $7,200.00 | ||
| 3 | CCS-2 | CC2-TRB-2 | INV-TRGG-2 | IDTR-101 | FFDOOD-2 | PACK-3 | BBR | 10.00 | $130.00 | $1,300.00 | ||
| 4 | CCS-3 | CC2-TRB-3 | INV-TRGG-3 | IDTR-102 | FFDOOD-3 | PACK-4 | LLR | 5.00 | $100.00 | $500.00 | ||
| 5 | CCS-4 | CC2-TRB-4 | INV-TRGG-4 | IDTR-103 | FFDOOD-4 | PACK-5 | MMR | 10.00 | $289.00 | $2,890.00 | ||
EXAMPLE | ||||||||||||
I will add new data every time in PURCHASE sheet.
thanks in advanced.
