M
Micos3
Hello
I've made a control of stock wich i would like to complete, but i don't know
how.
I have stock organized like this:
In 1 sheet it is like this:
A B C D E(invisible)
Design. Qty In Out Stock
1 Pen E1+C1-D1 10 15 50
2 Rubber E2+C2-D2 0 2 20
3 Whathever E3+C3-D3 1 0 10
What i want in other sheet is to know the quantity i took or put and the day
something like this:
A B C D E F
G..........
Design. Qty Day Qty Day Qty Day
1 Pen +10 25-10 -8 26-10 -7 30-10
2 Rubber -2 22-10
3 Whathever +1 23-10
Can anyone understand my doubt? Is it possible to do?
If someone can help me i apriciate
Thanks
I've made a control of stock wich i would like to complete, but i don't know
how.
I have stock organized like this:
In 1 sheet it is like this:
A B C D E(invisible)
Design. Qty In Out Stock
1 Pen E1+C1-D1 10 15 50
2 Rubber E2+C2-D2 0 2 20
3 Whathever E3+C3-D3 1 0 10
What i want in other sheet is to know the quantity i took or put and the day
something like this:
A B C D E F
G..........
Design. Qty Day Qty Day Qty Day
1 Pen +10 25-10 -8 26-10 -7 30-10
2 Rubber -2 22-10
3 Whathever +1 23-10
Can anyone understand my doubt? Is it possible to do?
If someone can help me i apriciate
Thanks