LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default I am looking for a warehouse inventory control excel format

Kevin do you think that I can setup something like that in Excel?
Or is it too complicated?
"Kevin B" wrote:

If you do have Access there are a number of wizard driven databases that can
be generated with little effort on your part. This includes the tables,
forms and reports. That might be a jump start.

Open Access and select New Database and then select Templates on my computer.

Click the databases tab and select the Inventory Control database and follow
the on-screen instructions.

At some point you could import your existing inventory information into the
database from Exel.

Hope this helps.
--
Kevin Backmann


"Eric." wrote:

Thanks for the reply Kevin,

Yes I tried the download center but did not find what I was looking for,I
tried different template but missing the one.
I am about to do an annual inventory with a lot of different parts and I
wish I can find a software (excel format 2003) that I will update time to
time.

With the option to reenter new stock to add to the old stock witout erasing
the previous one. also with a reorder level and price per item and total
prices....

I know that Access will do better but I know nothing about access,

Do you have some clues???

Thank you in advance.

Eric.

"Kevin B" wrote:

Have you tried the Microsoft Office Download Center. Click URL below...

http://office.microsoft.com/en-us/te...s/default.aspx
--
Kevin Backmann


"Eric." wrote:

trying to find an excel sheet to do an inventory control.
(unit in stock, unit received, level to reorder, unit price. total price...)
Thank you for your help
Eric.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inventory Control WLMPilot Excel Discussion (Misc queries) 2 May 16th 06 12:30 AM
Excel used for inventory control mauisun Excel Discussion (Misc queries) 2 March 1st 06 04:21 PM
How can I set up an inventory control system on Excel? webbmarketingsolutions Excel Discussion (Misc queries) 1 January 13th 06 05:06 PM
inventory control in excel artisanpp Excel Discussion (Misc queries) 0 June 1st 05 08:12 PM
Creating a Multiple Warehouse Inventory Spreadsheets Alice Charts and Charting in Excel 2 January 25th 05 03:54 PM


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"