How to auto populate certain cells on one sheet from another
On sheet 1, I have a column called "Type". Next to that I have a column called "Part Number". Next to that I have a column called "Description".
On sheet 2 I have the same set up.
I filled in all the information I need on sheet 2 for each Type of Product as a reference sheet. How do I auto populate sheet 1 information to match those 3 columns when I type in the Type in sheet 1?
Note: Sheet 1 has multiple qty's on different rows of the same product. Since I cannot copy and paste from one sheet to another, I was hoping to have a reference sheet (Sheet 2) that I could use to auto populate Sheet 1 whenever I typed in a certain Type. I do plan on using the dropdown menu in the Type column for Sheet 1 and have that match the Types in Sheet 2.
Please help with any info you have. Kevin