Clueless401
New Member
- Joined
- Aug 18, 2020
- Messages
- 42
- Office Version
- 2016
- Platform
- 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!
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: