Hi looking for some help with what I expect is an easy task for experienced excel users!
I have an excel sheet with a reference in the A column and a quantity in the B column. e.g.
Cell A1 - W1 Cell B1 - 2
Cell A2 - W2 Cell B2 - 4
What I'm trying to do is get another worksheet or workbook to autopopulate Column A with the references but times by the quantitys in Column B. As below;
W1
W1
W2
W2
W2
W2
I'm using Windows7.
My excel skills are restricted to basic formulas so any help would be much appreciated.
I have an excel sheet with a reference in the A column and a quantity in the B column. e.g.
Cell A1 - W1 Cell B1 - 2
Cell A2 - W2 Cell B2 - 4
What I'm trying to do is get another worksheet or workbook to autopopulate Column A with the references but times by the quantitys in Column B. As below;
W1
W1
W2
W2
W2
W2
I'm using Windows7.
My excel skills are restricted to basic formulas so any help would be much appreciated.