Spreadsheet: 188392d1350870253-is-it-possible-to-create-a-searchbox-in-a-cell-to-find-multiple-worksheet-the-sample-2
Sheet: RECEIPT

 |  |  |  |  |  |  |  |  |  |  | REF: ST 9151 J
 |  |  | OFFICIAL RECEIPT |  |  |  |  |  |  |  |  |  |  | XXXXXXXXXX
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LOT 10, BLOCK B, BANDAR BARU,
 |  |  |  | XXXXXXXXXXXXX |  |  |  |  |  |  |  |  |  | P.O.BOX NUMBER XXX
 |  |  |  | LOT 10, BLOCK B, BANDAR BARU, |  |  |  |  |  |  |  |  |  | 91307 SEMPORNA SABAH
 |  |  |  | P.O.BOX NUMBER XXX |  |  |  |  |  |  |  |  |  | NO TEL: XXXXXX |  |  | DATE:25/08/2011
 |  |  |  | 91307 SEMPORNA SABAH
 |  |  |  | NO TEL: XXXXX |  |  |  |  |  |  | [NAME] |  | ATIEH BIN KASIM |  |  | HARGA JUALAN: |  | RM 3800
 |  |  |  |  |  |  |  |  |  |  | NOMBOR IC |  | TIADA DALAM REKOD |  |  | DEPOSIT: |  | RM 1500
 | REF: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PINJAMAN: |  | RM 2300
 | no. resit | description |  |  |  |  |  | total (rm) |  |  | ALAMAT |  | TIADA DALAM REKOD |  |  | BUNGA: |  | RM 460
 |  | INSTALLMENT |  |  |  |  |  | 115 |  |  | [NAME] |  | TIADA DALAM REKOD |  |  | AGREEMENT |  | 24 MONTHS
 |  |  |  |  |  |  |  |  |  |  | MODEL: |  | MODENAS KRISTAR |  |  | BAKI: |  | RM 2760
 |  |  |  |  |  |  |  |  |  |  | NO. ENJIN |  | XXXXXXXX |  |  | BULANAN: |  | RM 115
 |  |  |  |  |  |  |  |  |  |  | NO. CHASIS |  | XXXXXXXXXXXXXXXX
 | installment balance: |  |  |  |  | date: |  |  |  |  |  |  |  | ACCOUNT DETAILS
 | other balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RM | RM | RM
 |  |  |  |  |  |  |  |  |  |  | NO. RESIT | DATE | [NAME] |  |  | DEBIT | CREDIT | BALANCE
 |  |  |  |  |  | COLLECTOR |  |  |  |  |  | 25/08/2011 | BALANCE |  |  |  | 2760 | 2760
 |  |  |  |  |  |  |  |  |  |  | 1544 | 13/10/2011 | INSTALLMENT FOR  SEPTEMBER |  |  | 115
 | THIS SHOULD BE THE NAME OF THE SHEET. |  |  |  | KIND OF COMBOBOX OR SEARCH BOX |  |  |  |  |  | 5767 | 28/10/2011 | INSTALLMENT FOR  OCTOBER |  |  | 115
 | EXAMPLE, IF I PUT "ST 9154 J" IT WILL SEARCH AND ONLY COPY THINGS INTO THAT SHEET ONLY. |  |  |  |  |  |  |  |  |  | 5801 | 30/11/2011 | INSTALLMENT FOR NOVEMBER |  |  | 115
 |  |  |  |  |  |  |  |  |  |  | 5837 | 29/12/2011 | INSTALLMENT FOR DECEMBER |  |  | 115
 | THE "INSTALLMENT" WORD SHOULD AUTOMATICALLY WIRTEN INTO THE '[NAME]' COLUMN, |  |  |  |  |  |  |  |  |  | 5873 | 30/01/2012 | INSTALLMENT FOR JANUARY |  |  | 115
 | ONE BY EVERY TIME THE CUSTOMER PAYING THEIR DEBT |  |  |  |  |  |  |  |  |  | 5916 | 26/02/2012 | INSTALLMENT FOR FEBRUARY |  |  | 115
 |  |  |  |  |  |  |  |  |  |  | 5955 | 28/03/2012 | INSTALLMENT FOR [NAME] |  |  | 115
 | THIS AMOUNT SHOULD BE THE SAME THING AS ABOVE DESCRIPTION. |  |  |  |  |  |  |  |  |  | 5986 | 23/04/2012 | INSTALLMENT FOR APRIL |  |  | 115
 | "115" AUTOMATICALLY WRITEN INTO DEBIT COLUMN |  |  |  |  |  |  |  |  |  | 6029 | 24/05/2012 | INSTALLMENT FOR MAY |  |  | 115
 |  |  |  |  |  |  |  |  |  |  | 6058 | 2012-12-06 00:00:00 | INSTALLMENT FOR JUNE |  |  | 115
 |  |  |  |  |  |  |  |  |  |  | 6110 | 22/07/2012 | INSTALLMENT FOR JULY |  |  | 115
 |  |  |  |  |  |  |  |  |  |  | 6155 | 2012-02-09 00:00:00 | INSTALLMENT AUGUST |  |  | 115
 | DATE ALSO AUTOMATICALLY WIRTEN INTO 'DATE' COLUMN |  |  |  |  |  |  |  |  |  | 6179 | 15/09/2012 | INSTALLMENT FOR SEPTEMBER |  |  | 230
 |  |  |  |  |  |  |  |  |  |  | 6216 | 14/10/2012 | INSTALLMENT FOR [NAME] |  |  | 115
 | IM GONNA PRINT THIS RECEIPT FOR THE CUSTOMER
 | AFTER PRINTING IT SHOULD BE BECOME AN EMPTY RECEIPT, SO I CAN RE-USE IT FOR RECORDING
 | THE OTHER SHEET.
 | THERE ARE 48 SHEETS, IM JUST SHOWING THINS AS ONE OF THE SAMPLE.
 |  |  |  |  |  |  |  |  |  |  |  | THIS IS FROM THE OTHER SHEET. IM JUST BRING INTO THIS SHEET COZ
 |  |  |  |  |  |  |  |  |  |  |  | SHOWING THE WAY IT SHOULD BE