Frank Kabel II

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thank u two and sorry to put ur name in topic but i'm.....
Julie u undearstand me in one part, i'll try explain better.
With example i gave i'll continue from there ok? Let's supose that in the
two examples the product has IN first.
A B C D
Prod. Stock In Out
Wine 10 3 6 (applyed this formula on stock B=B+C-D)
Fish 13 2 1
Click to expand...

i had 13 pieces of wine in stock put more 3(C) then take 6(D).
What i wanted was to get in a cell in a row:
G H I
WINE 3 IN (preferencialy in other sheet these 3 col.)
WINE 6 OUT
The problem is that with many products we have another 'X', because can
appear ex. WINE or FISH and so in row i show as G we can see what product is.

Now undearstand me? :)

Cause like this with a NOW(DATE) and with a filter i can have a historical
register of the many producys, with more than 65000 lines.
I guess is more clear now and the purpous too.
Is tangable?

Thanks
 
kHi
still not completely clear (at least to me). First some general remarks
- you also need a column which stores a date at which you put/move item
to/from your stock. Otherwise how would you apply a filter
- you need more than 65K rows -> Excel is definetely not the right tool

All this sounds like an inventory database where you want to keep track of
your stocks. I woudln't do this in Excel but would either create a adatabase
application (Access) or have a look at some freeware/shareware products for
keeping track of stocks
 
Hi

Ure right its a database inventory, but once the inventory works without
historical register i thought that was better to get one so i figured this
option.
If it was possible to do what i asked i would like to give it a shoot, if it
is too dificult, well like Jonh Lennon sayd "Let it be", but if not...
I guess u undearstand the complete picture now, what u say?

Thanks very much for all advices.

"Frank Kabel" escreveu:
 
Back
Top