Home

Pulling data from my inventory to fill qualities for new items

%3CLINGO-SUB%20id%3D%22lingo-sub-849817%22%20slang%3D%22en-US%22%3EPulling%20data%20from%20my%20inventory%20to%20fill%20qualities%20for%20new%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849817%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20excel%20to%20check%20in%20items%20to%20my%20inventory.%20Each%20item%20I%20have%20is%20unique%20because%20it's%20a%20collectible%20(so%20the%20qualities%20that%20differentiate%20one%20version%20of%20this%20item%20vs%20another%20means%20I%20have%20to%20treat%20them%20independent).%20However%2C%20each%20item%20shares%20most%20qualities%20with%20every%20other%20item%20like%20it%2C%20such%20as%20dimensions%2C%20date%20published%2C%20content%2C%20and%20location.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20create%20a%20new%20sheet%20for%20each%20upload%20I%20create%20(because%20we%20process%20the%20information%20in%20groups%20based%20on%20shipments%20and%20consigners)%20but%20is%20it%20possible%20that%20I%20can%20just%20pull%20the%20repeated%20data%20(dimensions%2C%20date%20published%2C%20etc)%20into%20my%20new%20worksheet%20as%20I'm%20filling%20out%20the%20content%3F%20I%20don't%20want%20to%20have%20to%20struggle%20to%20type%20in%20the%20date%20etc%20every%20time%20I%20see%20an%20item%20I%20see%20often.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20custom%20lists%2C%20but%20it%20won't%20save%20the%20number%20data%20like%20the%20dimensions%20and%20date%20which%20are%20the%20biggest%20qualities%20I%20want%20to%20capture.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-849817%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-854428%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20data%20from%20my%20inventory%20to%20fill%20qualities%20for%20new%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854428%22%20slang%3D%22en-US%22%3EIt%20sounds%20like%20the%20VLOOKUP()%20function%20would%20be%20a%20good%20start.%20Could%20you%20provide%20a%20sample%20so%20that%20I%20can%20walk%20you%20through%20this%20function%20and%20its%20use%20specific%20to%20your%20sample%3F%3C%2FLINGO-BODY%3E
OliviaOddish
Occasional Visitor

Hi!

 

I use excel to check in items to my inventory. Each item I have is unique because it's a collectible (so the qualities that differentiate one version of this item vs another means I have to treat them independent). However, each item shares most qualities with every other item like it, such as dimensions, date published, content, and location.

 

I have to create a new sheet for each upload I create (because we process the information in groups based on shipments and consigners) but is it possible that I can just pull the repeated data (dimensions, date published, etc) into my new worksheet as I'm filling out the content? I don't want to have to struggle to type in the date etc every time I see an item I see often.

 

I've tried custom lists, but it won't save the number data like the dimensions and date which are the biggest qualities I want to capture.

1 Reply
It sounds like the VLOOKUP() function would be a good start. Could you provide a sample so that I can walk you through this function and its use specific to your sample?
Related Conversations