Forum Discussion
TRANSFERRING DATA IN TWO EXCEL SHEET AT A TIME
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
| ||||||||||||||||||||||||
| DATE | INVOICE NO | SUPPLIER NAME | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | SUB TOTAL | TAX | VALUE INCL TAX | DISC | INVOICE VALUE | |
| 20-05-2022 | 1 | BANGUR | AB1 | ABCD | 1 | 2 | AB2 | EFGH | 3 | 4 | AB3 | IJKL | 5 | 6 | AB4 | MNOP | 7 | 8 | 100 | 5% | 105 | 2 | 103 |
ITEM LIST Sheet
| Sr. No | Item Code | Item Name | Sales Price |
SUPPLIER LIST Sheet
| Sr. No | Date | Invoice No | Supplier Name | Item Name | Qty | Item Name | Qty | Item Name | Qty | Item Name | Qty | Invoice 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
| ||||||||||||||||||||||||
| DATE | INVOICE NO | SUPPLIER NAME | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | ITEM CODE | ITEM NAME | QTY | UNIT PRICE | SUB TOTAL | TAX | VALUE INCL TAX | DISC | INVOICE VALUE | |
| 20-05-2022 | 1 | BANGUR | AB1 | ABCD | 1 | 2 | AB2 | EFGH | 3 | 4 | AB3 | IJKL | 5 | 6 | AB4 | MNOP | 7 | 8 | 100 | 5% | 105 | 2 | 103 |
ITEM LIST Sheet
| Sr. No | Item Code | Item Name | Sales Price | |||
| ITEM CODE | ITEM NAME | AB1 | ABCD |
SUPPLIER LIST Sheet
| Sr. No | Date | Invoice No | Supplier Name | Item Name | Qty | Item Name | Qty | Item Name | Qty | Item Name | Qty | Invoice Value |
| 1 | ||||||||||||
| 2 | ||||||||||||
| 3 | ||||||||||||
| 4 | ||||||||||||
| QTY | ITEM NAME | 103 | ||||||||||
| 1 | ABCD | 103 | ||||||||||
| 20-05-2022 | 1 | BANGUR | 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.
No RepliesBe the first to reply
