I would like a macro to open up a source workbook and to copy the data into the destination workbook as follows:
1) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Zero Rate" appears, to be copied into col N, in the same row where the names matches the source workbook
2) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Exempt" appears, to be copied into col M, in the same row where the names matches the source workbook
I have attached sample data from the source workbook as well as the dastination workbook
Your assistance in this regard is most appreciated
1) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Zero Rate" appears, to be copied into col N, in the same row where the names matches the source workbook
2) Where the name in E2 matches the name in the destination workbook, Col B (these are in row B7:B40) , I need the value in Col F that is in the same row where "Exempt" appears, to be copied into col M, in the same row where the names matches the source workbook
I have attached sample data from the source workbook as well as the dastination workbook
Your assistance in this regard is most appreciated
| Excel Workbook | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | END | Time: 01:50:21 | ||||||||
| 2 | Company | BR1 | Date: 29/06/2012 | |||||||
| 3 | ||||||||||
| 4 | R E G I S T E R | R E P O R T | Page: 1 | |||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | Inclusive | VAT Amount | Net Amount | |||||||
| 8 | ||||||||||
| 9 | SALE | S (OUTPUT | TAX) Standard Rate | 1,261,591.19 | 155,511.25 | 1,106,079.95 | ||||
| 10 | Vehicle Transfers Out | 0.00 | 0.00 | 0.00 | 0 | |||||
| 11 | Warranty Payments | 10,550.19 | 1,295.64 | 9,254.55 | ||||||
| 12 | Zero Rate | -210,233.64 | 0.00 | -210,233.64 | ||||||
| 13 | Exempt | 0.00 | 0.00 | 0.00 | ||||||
| 14 | Output Vat Posting | 0.00 | 0.00 | 0.00 | ||||||
| 15 | - | ------------- -- | ------------ | -------------- | ||||||
| 16 | SUB-TOTAL | 1,061,907.74 | 156,806.88 | 905,100.86 | 0 | |||||
| 17 | Change In Use | 0.00 | 0.00 | 0.00 | -156807 | |||||
| 18 | - | ------------- -- | ------------ | -------------- | ||||||
| 19 | TOTAL OUTPUT TAX | 1,061,907.74 | 156,806.88 | 905,100.86 | ||||||
| 20 | - | ------------- -- | ------------ | -------------- | ||||||
| 21 | 0.00 | 0.00 | 0.00 | |||||||
| 22 | ||||||||||
| 23 | ||||||||||
Sheet1 | ||||||||||
| Excel Workbook | |||||
|---|---|---|---|---|---|
| B | M | N | |||
| 6 | Exempt Sales | Zero Rated Sales | |||
| 7 | BR1 | 0.00 | |||
| 8 | BR2 | -98,307.91 | |||
| 9 | BR3 | -23,014.24 | |||
| 10 | BR4 | 0.00 | -9,363.00 | ||
| 11 | BR5 | -93,523.00 | -12,293.00 | ||
| 12 | BR6 | -108,785.80 | |||
| 13 | BR7 | -6,117.56 | |||
| 14 | - | - | |||
| 15 | Total | -329,748.51 | -21,656.00 | ||
| 16 | - | - | |||
Jun-2012 | |||||
