In Excell, I am inputting data into a spreadsheet from written documents. I work for a shoe company, and I'm inputting
information about each shoe, such as Color, Size, and Model.
Let me give an example of what I am doing:
-I look at a document, and in a new spreadsheet, input:
-then I look at the Master List spreadsheet and find the row that has the shoe that is Red, Size 10, and Athens model. That
shoe has an item number in that same row, which I have to copy and paste onto the spreadsheet I am working on.
Here is a pic of the Master List:
And here is a pic of the spreadsheet I would be working
The tedious part is finding the item number for each shoe.
So I am wondering if there is a way to make this easier.. such as having Excell automatically input that item number for me
once I type in the size, color, and model name.
If Excell can't draw information from one Spreadsheet and put it into another, I can always start this new Spreadsheet at the
bottom of the master list too.
I would really appreciate help with this challenge.
Thanks so much