Microsoft Office Forums "Auto-populating" data-worksheet to worksheet.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2012, 06:41 PM
meggenm meggenm is offline "Auto-populating" data-worksheet to worksheet. Windows 7 32bit "Auto-populating" data-worksheet to worksheet. Office 2007
Novice
"Auto-populating" data-worksheet to worksheet.
 
Join Date: Jan 2012
Posts: 11
meggenm is on a distinguished road
Default "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.
Reply With Quote
  #2  
Old 02-02-2012, 10:41 PM
JBeaucaire JBeaucaire is offline "Auto-populating" data-worksheet to worksheet. Windows XP "Auto-populating" data-worksheet to worksheet. Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

Like so...
Attached Files
File Type: xls OrderSample.xls (24.0 KB, 57 views)
Reply With Quote
  #3  
Old 02-03-2012, 03:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline "Auto-populating" data-worksheet to worksheet. Windows XP "Auto-populating" data-worksheet to worksheet. Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

If you are trying to make invoices, Word's Mail Merge is also something that can be useful
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #4  
Old 02-03-2012, 07:48 AM
meggenm meggenm is offline "Auto-populating" data-worksheet to worksheet. Windows 7 32bit "Auto-populating" data-worksheet to worksheet. Office 2007
Novice
"Auto-populating" data-worksheet to worksheet.
 
Join Date: Jan 2012
Posts: 11
meggenm is on a distinguished road
Default For JBeaucaire

Quote:
Originally Posted by JBeaucaire View Post
Like so...
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.
Reply With Quote
  #5  
Old 02-04-2012, 02:04 AM
JBeaucaire JBeaucaire is offline "Auto-populating" data-worksheet to worksheet. Windows XP "Auto-populating" data-worksheet to worksheet. Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

Glad to help. Let us know how you make out converting the sample to your own uses.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Auto-populating" data-worksheet to worksheet. How do I get auto-updated "number of days since specified date" on MS word? terry795 Word 16 01-07-2016 04:33 PM
"Auto-populating" data-worksheet to worksheet. Outlook 2007: "The drive that contains your data file is out of disk space....." CLAWS Outlook 1 12-18-2011 11:54 PM
"Auto-populating" data-worksheet to worksheet. 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


All times are GMT -7. The time now is 05:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft