Hello!
I am very grateful for the help you provide when I post my doubts in the
list. My knowledge of OO improve a lot with your help. Whoever I am
working in a spreadsheet and have a problem that I can't solve for myself.
My spreadsheet is to count the items stored in a warehouse: I have a
type of spreadsheet to add items to the stock in the warehouse, and
other type of spreadsheet to remove items from the warehouse. So in the
new spreadsheet I have:
SHEET 1 - A list with all the possible items in the stock;
SHEET 2 - Must read the files with the items added to the warehouse;
SHEET 3 - Must read the files with the items removed from the warehouse;
SHEET 4 - Must calculate the stock of items in the warehouse;
SHEET 1:
A B
1 Ref. P1 Description of P1
Z Ref. Pz Description of Pz
SHEET 2:
A B C
D X
1 Ref. P1 Description of P1 Quant. added of P2 (File A1)
Total Ad of P1
2 Ref. P2 Description of P2 Quant. added of P2 (File A1) Quant.
added of P1 (File A2) Total Ad of P2
3 Ref. A3 Description of P3 Quant. added of P3 (File A1) Quant.
added of P3 (File A2) Total Ad of P3
N Ref. An Description of Pn Quant. added of Pn (File A1)
Total Ad of Pn
Z Ref. Az Description of Pz Quant. added of Pz (File A1) Quant.
added of Pz (File A2) Total Ad of Pz
SHEET 3:
A B C
D X
1 Ref. P1 Description of P1 Quant. rmd of P2 (File A1)
Total Rm of P1
2 Ref. P2 Description of P2 Quant. rmd of P2 (File A1) Quant. rmd
of P1 (File A2) Total Rm of P2
3 Ref. A3 Description of P3 Quant. remd of P3 (File A1) Quant. rmd
of P3 (File A2) Total Rm of P3
N Ref. An Description of Pn
Total Rm of Pn
Z Ref. Az Description of Pz Quant. rmd of Pz (File A1) Quant. rmd
of Pz (File A2) Total Rm of Pz
SHEET 4
A B C
1 Ref. P1 Description of P1 Total Ad of P1 - Total Rm of P1
2 Ref. P2 Description of P Total Ad of P2 - Total Rm of P2
3 Ref. A3 Description of P3 Total Ad of P3 - Total Rm of P3
N Ref. An Description of Pn Total Ad of Pn - Total Rm of Pn
Z Ref. Az Description of Pz Total Ad of Pz - Total Rm of Pz
My problem is to write a formula that find a product, eg A3, in the file
A1 and put the quantitie in in the correct line in SHEET 1. And the same
for the files with the products removed.
I hope my explanation (and my English) are good enough to you understand
this problem.
All the help will be very welcomed! Regards,
EVarejão
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
