Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
get data from another sheet
Name: jmyers1643 Date: December 16, 2005 at 12:13:04 Pacific OS: xp CPU/Ram: 800
Comment:
i have one excel document i keep track of orders, another one with inventory. How can i display one of the sheets from the inventory spreadsheet into the orders spreadsheet. I have tried to make a database query, but it says it cant find any tables to pull from?
Name: Jennifer SUMN Date: December 16, 2005 at 15:49:57 Pacific
Reply:
Data Import External Data Import Data Then browse to the Workbook that contains the sheet you want.
Soylent Green is PEOPLE!!!
0
Response Number 2
Name: wizard-fred Date: December 17, 2005 at 05:15:55 Pacific
Reply:
If you are doing an order entry and inventory control application, it would be better if you use a database or a higher level language. There are many examples available. How do you plan in keep orders from different customers or different orders from the same customer in Excel?
Summary: Got a bit of an Excel query that I am struggling with. Say you have two worksheets - Data1 and Data2. Both sheets will have identical columns and column headings. But Data1 will be the main sheet wher...
Summary: I am stuck on trying to get data from one sheet to another using a drop down menu as the trigger. What I have is a spreadsheet for comparing # of completed tasks on a weekly/monthly/yearly basis for 1...
Summary: First, a posting tip: Excel 2007 isn't a good subject line. You should try to use a subject line that is relevant to the question in your post. If everyone used a subject line like Excel 2007, then we...
0 
