"Auto-populating" data-worksheet to worksheet.
I have a worksheet with 5 columns (Col B:Col F), with Column headers as follows: Category/Item/Description/Cost/Price.
Col A is for the Sales Rep to put the quantity of item ordered.
If an item is ordered, i.e. a quantity number is put in Col A, I want Excel to "autopopulate" our Invoice Statement on another worksheet with not only the Quantity ordered (Col A) data, but also the corresponding row information for that item, i.e., Item, description, price.
In otherwords, if a number is entered in Col A then I would like excel to vlookup that row data an imput it into our Invoice Statement. I know how to do the vlookup, I just cannot for the life of me figure out how to get the if/then part (if quantity data is entered inCol A, take that row information and insert in Invoice Statement) to link to the vlookup. It is kind of like I need an if-then and a vlookup formula together eh?. The problem is I have spent hours trying to do this and I cannot figure out how. Any ideas? Thank You.
|