TRANSFERRING DATA IN TWO EXCEL SHEET AT A TIME

%3CLINGO-SUB%20id%3D%22lingo-sub-3404192%22%20slang%3D%22en-US%22%3ETRANSFERRING%20DATA%20IN%20TWO%20EXCEL%20SHEET%20AT%20A%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3404192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%223%22%3EHi%20Respected%20COMMUNITY%20TEAM%20MEMBERS%2C%20hope%20all%20of%20You%20are%20well.%20I%20unable%20to%20access%20my%20Excel%20work%20book%20(as%20given%20below).%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EITEM%20RECEIVED%20Sheet%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%20width%3D%221306%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2259%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2299%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2261%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2243%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2238%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2261%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2247%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2241%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2255%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2245%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2252%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2252%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FTD%3E%3CTD%20width%3D%2242%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2249%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2265%22%3EDATE%3C%2FTD%3E%3CTD%20width%3D%2259%22%3EINVOICE%20NO%3C%2FTD%3E%3CTD%20width%3D%2299%22%3ESUPPLIER%20NAME%3C%2FTD%3E%3CTD%20width%3D%2261%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2265%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2243%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2238%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2261%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2240%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2247%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2241%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2255%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2245%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2242%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2252%22%3ESUB%20TOTAL%3C%2FTD%3E%3CTD%3ETAX%3C%2FTD%3E%3CTD%20width%3D%2262%22%3EVALUE%20INCL%20TAX%3C%2FTD%3E%3CTD%3EDISC%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EINVOICE%20VALUE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E20-05-2022%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EBANGUR%3C%2FTD%3E%3CTD%3EAB1%3C%2FTD%3E%3CTD%3EABCD%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EAB2%3C%2FTD%3E%3CTD%3EEFGH%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3EAB3%3C%2FTD%3E%3CTD%3EIJKL%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3EAB4%3C%2FTD%3E%3CTD%3EMNOP%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E5%25%3C%2FTD%3E%3CTD%3E105%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E103%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CFONT%20size%3D%223%22%3EITEM%20LIST%20Sheet%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%20width%3D%22315%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2237%22%3ESr.%20No%3C%2FTD%3E%3CTD%20width%3D%2255%22%3EItem%20Code%3C%2FTD%3E%3CTD%20width%3D%22158%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2265%22%3ESales%20Price%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CFONT%20size%3D%223%22%3ESUPPLIER%20LIST%20%3C%2FFONT%3E%3CFONT%20size%3D%223%22%3ESheet%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%20width%3D%22849%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2251%22%3ESr.%20No%3C%2FTD%3E%3CTD%20width%3D%2283%22%3EDate%3C%2FTD%3E%3CTD%20width%3D%2273%22%3EInvoice%20No%3C%2FTD%3E%3CTD%20width%3D%2292%22%3ESupplier%20Name%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2242%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2245%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2246%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2243%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EInvoice%20Value%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CFONT%20size%3D%223%22%3EActually%20I%20want%20to%20Transfer%20some%20Schedule%20DATA%20From%201)ITEM%20RECEIVED%20Sheet%20in%20to%20Schedule%20CELL%20of%20Two%20Excel%20Sheet%20named%202)ITEM%20LIST%20Sheet%20and%203)SUPPLIER%20LIST%20Sheet%20by%20pressing%20SAVE%20Button%20on%20ITEM%20RECEIVED%20sheet%20at%20a%20time%20with%20using%20VBA%20code.%20%3C%2FFONT%3E%3CFONT%20size%3D%223%22%3Ethis%20matter%20I%20have%20posted%20on%2017-05-2022%2C%20and%20our%20Important%20%22COMMUNITY%20TEAM%20MEMBER%22%20Respected%20%3C%2FFONT%3E%3CFONT%20size%3D%223%22%3EMr.Subodh_Tiwari_sktneer%2CSir%20send%20VBA%20CODE%20to%20me%20for%20this%20and%20I%20also%20applied%20that%20in%20my%20said%20work%20book.%20But%20unfortunately%20it%20is%20not%20working%20properly.%20%3C%2FFONT%3E%3CFONT%20size%3D%223%22%3E(as%20given%20below).%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3EITEM%20RECEIVED%20Sheet%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%20width%3D%221306%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2259%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2299%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2261%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2243%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2238%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2261%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2251%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2240%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2247%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2241%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2255%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2245%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2242%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2252%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2252%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FTD%3E%3CTD%20width%3D%2242%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2262%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2249%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2265%22%3EDATE%3C%2FTD%3E%3CTD%20width%3D%2259%22%3EINVOICE%20NO%3C%2FTD%3E%3CTD%20width%3D%2299%22%3ESUPPLIER%20NAME%3C%2FTD%3E%3CTD%20width%3D%2261%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2265%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2243%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2238%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2261%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2240%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2247%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2241%22%3EITEM%20CODE%3C%2FTD%3E%3CTD%20width%3D%2255%22%3EITEM%20NAME%3C%2FTD%3E%3CTD%20width%3D%2245%22%3EQTY%3C%2FTD%3E%3CTD%20width%3D%2242%22%3EUNIT%20PRICE%3C%2FTD%3E%3CTD%20width%3D%2252%22%3ESUB%20TOTAL%3C%2FTD%3E%3CTD%3ETAX%3C%2FTD%3E%3CTD%20width%3D%2262%22%3EVALUE%20INCL%20TAX%3C%2FTD%3E%3CTD%3EDISC%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EINVOICE%20VALUE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E20-05-2022%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EBANGUR%3C%2FTD%3E%3CTD%3EAB1%3C%2FTD%3E%3CTD%3EABCD%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EAB2%3C%2FTD%3E%3CTD%3EEFGH%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3EAB3%3C%2FTD%3E%3CTD%3EIJKL%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3EAB4%3C%2FTD%3E%3CTD%3EMNOP%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E5%25%3C%2FTD%3E%3CTD%3E105%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E103%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CFONT%20size%3D%223%22%3EITEM%20LIST%20Sheet%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%20width%3D%22574%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2237%22%3ESr.%20No%3C%2FTD%3E%3CTD%20width%3D%2255%22%3EItem%20Code%3C%2FTD%3E%3CTD%20width%3D%22158%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2265%22%3ESales%20Price%3C%2FTD%3E%3CTD%20width%3D%2272%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2292%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EITEM%20CODE%3C%2FTD%3E%3CTD%3EITEM%20NAME%3C%2FTD%3E%3CTD%3EAB1%3C%2FTD%3E%3CTD%3EABCD%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CFONT%20size%3D%223%22%3ESUPPLIER%20LIST%3C%2FFONT%3E%20%3CFONT%20size%3D%223%22%3ESheet%3C%2FFONT%3E%3C%2FP%3E%3CTABLE%20width%3D%22849%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2251%22%3ESr.%20No%3C%2FTD%3E%3CTD%20width%3D%2283%22%3EDate%3C%2FTD%3E%3CTD%20width%3D%2273%22%3EInvoice%20No%3C%2FTD%3E%3CTD%20width%3D%2292%22%3ESupplier%20Name%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2242%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2245%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2246%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EItem%20Name%3C%2FTD%3E%3CTD%20width%3D%2243%22%3EQty%3C%2FTD%3E%3CTD%20width%3D%2272%22%3EInvoice%20Value%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EQTY%3C%2FTD%3E%3CTD%3EITEM%20NAME%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E103%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EABCD%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E103%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E20-05-2022%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EBANGUR%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E103%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CFONT%20size%3D%223%22%3EI%20know%20this%20of%20course%20is%20my%20fault%20because%2C%20I%20could%20not%20explain%20the%20matter%20properly.%20Actually%20I%20need%20help%20from%20DATA%20of%20'Item%20Name'%20and%20'Item%20Qty'%20should%20be%20transfer%20to%20maintain%20as%20per%20'Cell%20Name%20Headings'%20to%20SUPPLIER%20LIST%20Sheet%20and%26nbsp%3BDATA%20of%20'Item%20Name'%20and%20'Item%20Code'%20should%20be%20transfer%20to%20maintain%20as%20per%20'Cell%20Name%20Headings'%20to%20ITEM%20LIST%20Sheet%20from%20ITEM%20RECEIVED%20Sheet%20and%20it%20will%20occurs%20frequently%20as%20maintain%20next%20row.%20if%20found%20'ITEM%20CODE'%20and%20'ITEM%20NAME%20'%20are%20same%20in%20frequent%20receiving%20in%20'ITEM%20RECEIVED'%20then%20not%20necessary%20to%20transfer%20the%20same%20in%20'ITEM%20LIST'%20Sheet.%20%3C%2FFONT%3E%3CFONT%20size%3D%223%22%3Emay%20I%20get%20help%20in%20this%20regards.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3404192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi Respected COMMUNITY TEAM MEMBERS, hope all of You are well. I unable to access my Excel work book (as given below).

ITEM RECEIVED Sheet

                   
 

 

 
    
DATEINVOICE NOSUPPLIER NAMEITEM CODEITEM NAMEQTYUNIT PRICEITEM CODEITEM NAMEQTYUNIT PRICEITEM CODEITEM NAMEQTYUNIT PRICEITEM CODEITEM NAMEQTYUNIT PRICESUB TOTALTAXVALUE INCL TAXDISCINVOICE VALUE
20-05-20221BANGURAB1ABCD12AB2EFGH34AB3IJKL56AB4MNOP781005%1052103

ITEM LIST Sheet

Sr. NoItem CodeItem NameSales Price
    
    
    

SUPPLIER LIST Sheet

Sr. NoDateInvoice NoSupplier NameItem NameQtyItem NameQtyItem NameQtyItem NameQtyInvoice Value
1            
2            
3            
4            

Actually I want to Transfer some Schedule DATA From 1)ITEM RECEIVED Sheet in to Schedule CELL of Two Excel Sheet named 2)ITEM LIST Sheet and 3)SUPPLIER LIST Sheet by pressing SAVE Button on ITEM RECEIVED sheet at a time with using VBA code. this matter I have posted on 17-05-2022, and our Important "COMMUNITY TEAM MEMBER" Respected Mr.Subodh_Tiwari_sktneer,Sir send VBA CODE to me for this and I also applied that in my said work book. But unfortunately it is not working properly. (as given below).

ITEM RECEIVED Sheet

                   
 

 

 
    
DATEINVOICE NOSUPPLIER NAMEITEM CODEITEM NAMEQTYUNIT PRICEITEM CODEITEM NAMEQTYUNIT PRICEITEM CODEITEM NAMEQTYUNIT PRICEITEM CODEITEM NAMEQTYUNIT PRICESUB TOTALTAXVALUE INCL TAXDISCINVOICE VALUE
20-05-20221BANGURAB1ABCD12AB2EFGH34AB3IJKL56AB4MNOP781005%1052103

ITEM LIST Sheet

Sr. NoItem CodeItem NameSales Price   
   ITEM CODEITEM NAMEAB1ABCD

SUPPLIER LIST Sheet

Sr. NoDateInvoice NoSupplier NameItem NameQtyItem NameQtyItem NameQtyItem NameQtyInvoice Value
1            
2            
3            
4            
   QTYITEM NAME       103
     1ABCD     103
 20-05-20221BANGUR        103

I know this of course is my fault because, I could not explain the matter properly. Actually I need help from DATA of 'Item Name' and 'Item Qty' should be transfer to maintain as per 'Cell Name Headings' to SUPPLIER LIST Sheet and DATA of 'Item Name' and 'Item Code' should be transfer to maintain as per 'Cell Name Headings' to ITEM LIST Sheet from ITEM RECEIVED Sheet and it will occurs frequently as maintain next row. if found 'ITEM CODE' and 'ITEM NAME ' are same in frequent receiving in 'ITEM RECEIVED' then not necessary to transfer the same in 'ITEM LIST' Sheet. may I get help in this regards.

 

0 Replies