Parabolic33
MIS
Hello,
I'll start with a brief synopsis of what I am trying to accomplish.
I have a spread sheet of products which contains information such as the item number, description, colors, quantity position, and a picture as an example for the customer. The qty position field needs to be populated
with the quantity available from another sheet. The first sheet is laid out like below. I'll refer to this worksheet as sheet 1.
Picture Description Item Number Color Qty Position
Frame 100 series 101 Black
Frame 100 series 102 Red
Frame 100 series 103 Brown
Frame 200 series 201 Black
Frame 200 series 202 Red
Frame 200 series 203 Brown
On a seperate worksheet, call it sheet 2, in the same spreadsheet, I have all of the possible item numbers and their available quantities in two seperate columns. What I need to have happen is the qty position on sheet 1 to be populated with the available quantity from sheet 2 if the item number on sheet 1 matches the item number on sheet 2.
any help would be greatly appreciated.
Thanks,
Mike
I'll start with a brief synopsis of what I am trying to accomplish.
I have a spread sheet of products which contains information such as the item number, description, colors, quantity position, and a picture as an example for the customer. The qty position field needs to be populated
with the quantity available from another sheet. The first sheet is laid out like below. I'll refer to this worksheet as sheet 1.
Picture Description Item Number Color Qty Position
Frame 100 series 101 Black
Frame 100 series 102 Red
Frame 100 series 103 Brown
Frame 200 series 201 Black
Frame 200 series 202 Red
Frame 200 series 203 Brown
On a seperate worksheet, call it sheet 2, in the same spreadsheet, I have all of the possible item numbers and their available quantities in two seperate columns. What I need to have happen is the qty position on sheet 1 to be populated with the available quantity from sheet 2 if the item number on sheet 1 matches the item number on sheet 2.
any help would be greatly appreciated.
Thanks,
Mike