I download Inventory Data from a company data base. I'll then inventory the racks of stock. Rather than looking through my sheets for the SKU item, I'd like to simply record the SKU's as I go (and any change in Quantity if needed) from the shelves into my Tablet. I know what quantities I should have per Company Data Base. I have a routine to show a Under-Even-Over of My Count vs Data Base. How do I get Excel to use either my Shelf Quantity Entered -or if no entry is made for quantity- use the Data Base Quantity in 'Column I' so 'Column J' shows my +/-/= status ?
What I seem to know: Cells with formulas and a retrieved '0' value keep my various ideas from working.
Have tried Helper Columns.
Columns can be re-arranged to facilitate a working sheet if needed.
Help !! How should I structure a Formula to calculate 'Column J' correctly ???? (Sample Workbook Attached)
Thank You in Advance !
Bookmarks