#1
|
|||
|
|||
Stocktake using excel 2007
Hi i'm new on here so please forgive me if i break any rules, i promise i learn quick and will obey master.
I am struggling at work to create a simple stocktake system. We use an epos system for stock and I can save an existing stockfile to excel including the barcode serials. I can also create a scanable barcode. I add another column and then scan my stock which is all ok. what I want to do is to compare the scanned stock with the database to show either matches or discrepencies automatically. Is there anything I can do or do any of you know where I can find the correct formula. Any help would ge great because this will save me so many man hours having to look through thousands of lines of stock. I should add I can sort the barcodes into a-z order. Thank you guys in advance. I await full of confidence in your ability, so no pressure. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 to Outlook 2007 - task import possible? | mjwillyone | Outlook | 2 | 07-05-2023 07:23 AM |
Excel 97 file is empty in Excel 2007 | drzeto | Excel | 1 | 04-13-2014 09:23 PM |
[Excel 2007] Building Power Point Slides from data in an Excel Table | bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
Excel 2007 custom ribbon not showing in Excel 2010 | Paulzak | Excel | 2 | 02-17-2012 06:35 PM |
Excel 2007 to Word 2007 Labels mail merge not working | rec | Mail Merge | 0 | 07-31-2010 10:45 AM |