In/Out of stock spread sheet

Clueless401

New Member
Joined
Aug 18, 2020
Messages
42
Office Version
  1. 2016
Platform
  1. Windows
Please note i have very little experience with Excel.

I have a Net Price File effective October 1, 2020. This file contains the standard list x multiplier and special Gspec pricing. This was given to me from one of our vendors. And have no clue what that means!

How can i use this to set up a first in first out spread sheet using a UPC Code reader/scanner?

FYI - I have no clue what i am doing, kind of figuring things out as i go.

I was thinking of using the Excel sheet they sent me that contains all the information to be a key to other tables, one that has a list of what is currently in stock ( to add or subtract from stock) and the other table containing the prices and customers that the parts are being assigned too.

Does this make sense? I think it makes sense in my mind, lol!

Please help!
 
Last edited by a moderator:

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
See
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top