Forum Discussion
poje12
Jan 17, 2025Copper Contributor
File for work. please help!
Hi all, i have a file that i use for work. Right now there are 2 different pages. a list of the items with their code and an info about their situation. For Example if they are out, lost, etc. a ...
peiyezhu
Jan 22, 2025Bronze Contributor
Re:Ideally i need something that keeps track of what goes out and what comes back and the dates.
I am confused too.
which sheet is your source data?
and show your expected result.
Can.you explain sheet2 clearly?
- poje12Jan 22, 2025Copper Contributor
hi, i posted the proper sheet. the second is the list of the code of the items that i send in a specific date. so i know exactly what went out and when and what came back
- peiyezhuJan 22, 2025Bronze Contributor
If track stock,three columns journal/ledger will be a method.
e.g.
date item debt credit
- poje12Jan 22, 2025Copper Contributor
hi peiyezhu, sorry i miss this reply.
how can i do that?