Spreadsheet: 862516d1710230283-how-to-pull-the-data-from-sheet-1-to-sheet-2-excel-data
Sheet: Sheet1

 | SEARCH BOX
 |  |  |  |  |  |  |  |  |  |  |  | CID Number | Campaign Name | Data | Start Date | End Date | Total Cost (₹) | Trade discont 15% | GST | GST 18% | Without GST | Total Campaign Runing Day
 |  |  |  |  |  |  |  |  |  |  |  | CID-1306 | YM Test Advertiser | 19-02-2024 | 2024-02-20 00:00:00 | 2024-03-20 00:00:00 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 29
 |  |  |  |  |  |  |  |  |  |  |  | CID-1305 | Murugan S | 15-02-2024 | 2024-02-16 00:00:00 | 2024-02-21 00:00:00 | 1062 | 159.3 | 902.7 | 162.486 | 740.214 | 5
 |  |  |  |  |  |  |  |  |  |  |  | CID-1304 | Royal | 15-02-2024 | 2024-02-15 00:00:00 | 2024-03-14 00:00:00 | 35400 | 5310 | 30090 | 5416.2 | 24673.8 | 28
 |  |  |  |  |  |  |  |  |  |  |  | CID-1303 | Oxford English School | 15-02-2024 | 2024-02-16 00:00:00 | 2024-02-25 00:00:00 | 1180 | 177 | 1003 | 180.54 | 822.46 | 9
 |  |  |  |  |  |  |  |  |  |  |  | CID-1302 | YM Test Advertiser | 15-02-2024 | 2024-02-23 00:00:00 | 2024-02-23 00:00:00 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 0
 |  |  |  |  |  |  |  |  |  |  |  | CID-1301 | YM Test Advertiser | 15-02-2024 | 2024-02-16 00:00:00 | 2024-02-24 00:00:00 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 8
 |  |  |  |  |  |  |  |  |  |  |  | CID-1300 | YM Test Advertiser | 13-02-2024 | 2024-02-14 00:00:00 | 2024-02-20 00:00:00 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 6
 |  |  |  |  |  |  |  |  |  |  |  | CID-1299 | [NAME] | 12-02-2024 | 2024-02-12 00:00:00 | 2024-02-16 00:00:00 | 2065 | 309.75 | 1755.25 | 315.945 | 1439.305 | 4
 |  |  |  |  |  |  |  |  |  |  |  | CID-1298 | Testt | 12-02-2024 | 2024-02-14 00:00:00 | 2024-02-21 00:00:00 | 295 | 44.25 | 250.75 | 45.135 | 205.615 | 7
 |  |  |  |  |  |  |  |  |  |  |  | CID-1297 | Aniruth s | 12-02-2024 | 2024-02-21 00:00:00 | 2024-02-24 00:00:00 | 708 | 106.2 | 601.8 | 108.324 | 493.476 | 3
 |  |  |  |  |  |  |  |  |  |  |  | CID-1296 | [NAME] | 10-02-2024 | 2024-02-11 00:00:00 | 2024-02-11 00:00:00 | 2360 | 354 | 2006 | 361.08 | 1644.92 | 0
 |  |  |  |  |  |  |  |  |  |  |  | CID-1295 | Arumugam.P | 09-02-2024 | 2024-02-10 00:00:00 | 2024-02-14 00:00:00 | 1770 | 265.5 | 1504.5 | 270.81 | 1233.69 | 4
 |  |  |  |  |  |  |  |  |  |  |  | CID-1294 | [NAME] | 09-02-2024 | 2024-02-10 00:00:00 | 2024-02-14 00:00:00 | 1770 | 265.5 | 1504.5 | 270.81 | 1233.69 | 4
 |  |  |  |  |  |  |  |  |  |  |  | CID-1293 | V.Ganeshpandian Saravanampatti | 09-02-2024 | 2024-02-10 00:00:00 | 2024-02-10 00:00:00 | 5900 | 885 | 5015 | 902.6999999999999 | 4112.3 | 0
 |  |  |  |  |  |  |  |  |  |  |  | CID-1292 | Magesh.S | 08-02-2024 | 2024-02-09 00:00:00 | 2024-02-14 00:00:00 | 1062 | 159.3 | 902.7 | 162.486 | 740.214 | 5
 |  |  |  |  |  |  |  |  |  |  |  | CID-1291 | [NAME] | 08-02-2024 | 2024-02-09 00:00:00 | 2024-02-16 00:00:00 | 2360 | 354 | 2006 | 361.08 | 1644.92 | 7
 |  |  |  |  |  |  |  |  |  |  |  | CID-1290 | Murugan S | 07-02-2024 | 2024-02-08 00:00:00 | 2024-02-13 00:00:00 | 1062 | 159.3 | 902.7 | 162.486 | 740.214 | 5
 |  |  |  |  |  |  |  |  |  |  |  | CID-1289 | ASTRO VED.COM PRIVATE LIMITED | 07-02-2024 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 59000 | 8850 | 50150 | 9027 | 41123 | 1
 |  |  |  |  |  |  |  |  |  |  |  | CID-1288 | [NAME] | 06-02-2024 | 2024-02-06 00:00:00 | 2024-02-06 00:00:00 | 1498.6 | 224.79 | 1273.81 | 229.2858 | 1044.5242 | 0
 |  |  |  |  |  |  |  |  |  |  |  | CID-1287 | M ARULPRAKASH, CHEYYAR | 04-02-2024 | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | 1498.6 | 224.79 | 1273.81 | 229.2858 | 1044.5242 | 0
 |  |  |  |  |  |  |  |  |  |  |  | CID-1286 | YM Test Advertiser | 02-02-2024 | 2024-02-03 00:00:00 | 2024-02-20 00:00:00 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 17
 |  |  |  |  |  |  |  |  |  |  |  | CID-1285 | Dreams Advertisnment Cbe | 25-01-2024 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 11800 | 1770 | 10030 | 1805.4 | 8224.6 | 1
 |  |  |  |  |  |  |  |  |  |  |  | CID-1284 | Arumugam.P | 25-01-2024 | 2024-01-26 00:00:00 | 2024-01-31 00:00:00 | 1770 | 265.5 | 1504.5 | 270.81 | 1233.69 | 5
 |  |  |  |  |  |  |  |  |  |  |  | CID-1283 | Magesh.S | 25-01-2024 | 2024-01-26 00:00:00 | 2024-01-30 00:00:00 | 1062 | 159.3 | 902.7 | 162.486 | 740.214 | 4
 |  |  |  |  |  |  |  |  |  |  |  | CID-1282 | Paulraj P | 24-01-2024 | 2024-01-24 00:00:00 | 2024-01-24 00:00:00 | 1180 | 177 | 1003 | 180.54 | 822.46 | 0