Circular Reference for inventory

  • Thread starter Thread starter scarlett1446
  • Start date Start date
S

scarlett1446

Hi,
I am trying to set up an inventory database using a circular reference
to subtract items out of inventory. I cannot seem to make it work. I
really don't want to make another cell for totals in this. My employer
doesn't have Access. (sure would like it tho) I would also like to
link the totals to other worksheets and create other formulas that
don't need circular references with the same 2 fields. Can I do this?
Thanks!!
Sharon
 
why go with circular references? they are hair-pullers and don'
generally work. why not try and find a work-around solution. tr
posting some data, like what formulas you have, how your data i
set-up, and what your trying to accomplish, and just watch the replie
flourish. :-)

HT
 
Hi
I agree with Vasant that this probably isn't feasible. You probably
have to use helper rows/columns for this.
Though it is possible to create an accumulator with VBA I won't use
this as you loose your paper trail. That is you enter something wrong,
how do you want to correct this?

If it has to be Excel I'd try the following:
1. Set-up an invetory sheet which stores all inputs/outputs
2. Use a column which specifies the type of inventory action (sell,
buy, re-stocking, loss, etc.)
 
scarlett1446 said:
My employer
doesn't have Access. (sure would like it tho)
Click to expand...

You don't need the MS Access application to create and/or query a Jet
database (.mdb file). You can do all this on the fly using only Excel
and ADOX (to create the .mdb file) and ADO (use DDL statements to
create the schema e.g. CREATE TABLE etc and SQL for queries).

You do need MDAC, free MS download and shipped with Excel, and Jet,
free MS download and shipped with early versions of MDAC, so it's
highly likely you already have the necessary components shipped with
Excel.

See the following links (in these articles, read 'Jet' for the word
'Access'
because the MS Access application is not actually used):

Creating an Access(sic) Database:
http://msdn.microsoft.com/library/d...s/odeopg/html/deovrcreatingaccessdatabase.asp

Running a Temporary Query:
http://msdn.microsoft.com/library/d...s/odeopg/html/deovrcreatingaccessdatabase.asp

--
 
Back
Top