#1
|
|||
|
|||
"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. |
#2
|
|||
|
|||
Like so...
|
#3
|
||||
|
||||
If you are trying to make invoices, Word's Mail Merge is also something that can be useful
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
For JBeaucaire
You guys are absolutely unbelievable! I am studying your formulas to ensure I understand how they work and will attempt to imput into my workbook today. Your care to respond, time and knowledge of excel are a true blessing.
Thank you so very much JBeaucaire. I am in awe of your ability. |
#5
|
|||
|
|||
Glad to help. Let us know how you make out converting the sample to your own uses.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get auto-updated "number of days since specified date" on MS word? | terry795 | Word | 16 | 01-07-2016 04:33 PM |
Outlook 2007: "The drive that contains your data file is out of disk space....." | CLAWS | Outlook | 1 | 12-18-2011 11:54 PM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |
TRANSFER DATA TO NEW WORKSHEET | BOBN | Excel | 0 | 11-08-2007 10:34 PM |