Hi experts
the result should be in FINAL sheet from row7 based on cell A2 should match with column B for each sheet then should brings data:
1-in column A will show sheet name and brings data for old date .
2- in column B will brings INVOICE.N from each sheet is existed in column C based on adjacant cell contains sheet name in column A
3- in column C will brings DATE from each sheet is existed in column A based on adjacant cell contains sheet name in column A for FINAL sheet.
2- in column D will brings CUSTOMER from each sheet is existed in column D based on adjacant cell contains sheet name in column A .
4- in column E in row8 will brings QTY from STOCK sheet in Column (C) .
5-in column F in row2 will brings UNIT PRICE from STOCK sheet in Column (D) .
6- in column(G) will brings QTY from each sheet in column(E) based on adjacant cell contains sheet name in column A for FINAL sheet .
7- in column(H) will brings UNIT PRICE from each sheet in column(F) based on adjacant cell contains sheet name in column A for FINAL sheet .
8- in column(I) will calculation QTY based on sheet name , if sheet name in column A for FINAL sheet is
PURCHASES then the I=E +G
if sheet name in column A for FINAL sheet is
SALS then the I=E - G, if sheet name in column A for FINAL sheet is PURCHASES RETURNS then the I=E - G , if sheet name in column A for FINAL sheet is
SALES RETURNS then the I=E +G
9-column(J) should be the same column(H)
next row(8) depends on row7 then will move numric valus from row7 to row 8
in column( I ) in row7 will copy to column( E )for row8,
in column( H ) in row7 will copy to column( F )for row8,
in columns( G,H) will brings QTY,PRICE from sheet name is mathed with column A for row8,
in column( I ) will calculation QTY for row8(CHECK POINT 8) .
in column( J ) for row8 (check point9)
Bookmarks