Spreadsheet: 42076d1240604506-automatic-update-of-data-in-other-spreadsheet-nirulas-vikas-puri
Sheet: Sheet1

cola id | outlet
dd1234 | [NAME] |  |  | I want  to  copy orde taken column(d) to get automatically
 |  |  |  | copied to another workbook … so that history of orders can
 |  |  |  | be maintained and is that posible to save the copied data to
 |  |  |  | get saved after few columns when I add new data in this sheet
 | order form
 |  |  | orders taken
PACK | Product Code | BRAND
200 ML RGB | FG- 0101 | COKE | 2
 | FG- 0201 | FANTA | 3
 |  | Fanta APPLE | 5
 | FG- 0501 | THUMS UP
 | FG- 0601 | LIMCA
 | FG- 0301 | SPRITE | 4
 |  | Total 200 ml
250 ML RGB | FG- 0902 | MAAZA-MANGO | 4
 |  | Total 250 ml
250 ML Pet |  | MAAZA-MANGO | 5
 |  | Total 250ml | 6
300 ML RGB | FG- 0103 | COKE
 | FG- 0203 | FANTA | 7
 |  | Fanta APPLE | 7
 | FG- 0503 | THUMS UP | 8
 | FG- 0603 | LIMCA
 | FG- 0303 | SPRITE | 9
 | FG- 1003 | KINLEY SODA | 4
 |  | Total 300 ml
330 ML CANS | FG- 0130 | COKE
 | FG- 0230 | FANTA | 3
 | FG- 0330 | SPRITE | 3
 | FG- 0430 | THUMS UP | 33
 | FG- 0130 | COKE | 33
330 ML CANS | FG- 0130 | Diet COKE | 3
 | FG- 0230 | FANTA | 1
 | FG- 0330 | SPRITE | 3
 | FG- 0530 | THUMS UP | 4
 | FG- 0431 | Diet cane (1*6) | 5
 |  | Total Can 330 ml
330 ML CANS | FG- 0130 | COKE | 6
 | FG- 0430 | DIET COKE | 5
 | FG- 0230 | FANTA | 4
 | FG- 0330 | SPRITE | 4
 | FG- 0530 | THUMS UP | 4
 |  | Total Can 330 ml | 56
 |  | COKE | 6
350 ML PET |  | SPRITE
 |  | THUMS UP | 5
 |  | Diet Pet | 5
 |  | Total 500ml Pet | 5
500ml Pet | FG- 0115 | Coke | 5
 | FG- 0215 | Fanta | 5
 | FG- 0615 | Limca | 5
 | FG- 0515 | Tup | 5
 | FG- 0315 | Sprite | 5
 | FG- 1215 | [NAME] water | 5
 | FG- 0415 | Diet
 | FG- 0415 | Diet | 5
 | FG- 1015 | KINLEY SODA
 |  | Total 500ml Pet | 5
500ml Pet |  | [NAME]
1000ml | FG- 1217 | [NAME] | 5
1000ml | FG- 1217 | [NAME] | 5
600 Ml PET | FG- 0116 | COKE  Promo Stock | 5
 | FG- 0216 | FANTA  Promo Stock | 5
 | FG- 0516 | THUMS UPPromo Stock
 | FG- 0616 | LIMCAPromo Stock | 5
 | FG- 0316 | SPRITE Promo Stock | 5
 |  | Total 600ml Pet | 5
600 Ml PET | FG- 0116 | COKE | 5
 | FG- 0216 | FANTA
 |  | Fanta APPLE
 | FG- 0516 | THUMS UP
 | FG- 0616 | LIMCA
 | FG- 0316 | SPRITE
 |  | Total 600ml Pet
600 Ml PET | FG- 0116 | COKE
 | FG- 0216 | FANTA
 | FG- 0516 | THUMS UP
 | FG- 0616 | LIMCA
 | FG- 0316 | SPRITE
 |  | Total 600ml Pet
[NAME] 600 ml |  | [NAME]  Promo Stock
[NAME] 1200ml |  | [NAME]  Promo Stock
 |  | Total Maaza pet
[NAME] 600 ml | FG- 0916 | [NAME]
[NAME] 1200ml | FG- 0918 | [NAME]
 |  | Total Maaza pet
1250ML | FG-122 | COKE
 | FG-222 | FANTA
 | FG-522 | THUMS UP
 | FG-622 | LIMCA
 | FG-322 | SPRITE
 |  | Total 1250 ml Pet
2Ltr PET | FG- 0120 | COKE
 | FG- 0220 | FANTA
 | FG- 0520 | THUMS UP
 | FG- 0620 | LIMCA
 | FG- 0320 | SPRITE
2.25Ltr PET | FG- 0120 | COKE
 | FG- 0220 | FANTA
 | FG- 0520 | THUMS UP
 | FG- 0620 | LIMCA
 | FG- 0320 | SPRITE
 |  | Total 2000 ml Pet
NRGB | FG- 0543 | Soda water
NRGB | FG- 2262 | [NAME]
NRGB | FG- 2262 | Bitter Lemon
NRGB | FG- 2262 | Tonic Water
 |  | TOTAL
Canisters 18 Ltr | FG- 0144 | COKE
 | FG- 0244 | FANTA
 | FG- 9917 | Water Jar20ltr
 | FG- 0644 | LIMCA
 | FG- 0344 | SPRITE
 |  | Total
Mango Maaza Tetra | FG- 0953 | Mc Donald"s
 | FG- 0953 | Maaza Tetra [NAME]
 | FG- 0953 | Maaza [NAME]
MMPO 400ml | FG- 3664 | MM PO 400 ml
 |  | MM PO 400 ml Promo Stock
 |  | MM PO 1000 ml Promo Stock
 |  | Total
 |  | MMPO Pet 250 ML
 | FG- 3664 | MM PO 400 ml
MMPO 1000ml | FG- 3670 | MM PO 1000 ml
 |  | Total