make column lists for select query.

sheet1
table1	col1_1
table1	col1_2
table1	col1_3
table1	col1_4
table1	col1_5
table1	col1_6
table2	col2_1
table2	col2_2
table2	col2_3
table2	col2_4
....
....


sheet2
table1	col1_1,col1_2,col1_3,col1_4,col1_5,col1_6,
table2	col2_1,col2_2,col2_3,col2_4,
....
....

I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1

without vba is it possible?

thanks.
0
kang (41)
7/16/2007 9:09:59 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
374 Views

Similar Articles

[PageSpeed] 42

I think you may want some dependent lists.   

http://www.contextures.com/xlDataVal02.html

HTH,
Barb Reinhardt

"kang" wrote:

> sheet1
> table1	col1_1
> table1	col1_2
> table1	col1_3
> table1	col1_4
> table1	col1_5
> table1	col1_6
> table2	col2_1
> table2	col2_2
> table2	col2_3
> table2	col2_4
> ....
> ....
> 
> 
> sheet2
> table1	col1_1,col1_2,col1_3,col1_4,col1_5,col1_6,
> table2	col2_1,col2_2,col2_3,col2_4,
> ....
> ....
> 
> I want to make column lists for some table listed in sheet1.
> for example, select column_lists from table1
> 
> without vba is it possible?
> 
> thanks.
> 
0
7/16/2007 12:32:05 PM
Reply:

Similar Artilces:

ShAutComplete
Hello there, I am working on a browser based application, currently using ShAutoComplete in order to provide Auto complete facility for combo box used to enter the address of page that you want to browser. Used ShAutoComplete with SHACF_URLALL to show list of recently browsed web pages and webpage in history. Now how can I add address of web page browsed through my application into that list ? Means If I browser http://msn.com in my application, then it should go in the recently browsed page list that ShAutoComplete uses. Awaiting for your comments. The interface you are looking for ...

Select Query acting like an Update Query
I am having trouble with my database where my select queries are acting as update queries. If a user happens to accidentally or otherwise adjust the results provided by the query, it is updating the information on the table(s). I need to find out why it is doing this and how to prevent this from occurring and altering the data. Thank you, Terri On Dec 17, 9:34 am, Tboartz <Tboa...@discussions.microsoft.com> wrote: > I am having trouble with my database where my select queries are acting as > update queries. If a user happens to accidentally or otherwise adjust the > res...

Check query shows voided checks too!
I am running this query but its also showing voided checks! How can I make it now show voided checks? SELECT VCHRNMBR AS PaymentNumber, VENDORID, DOCDATE AS CheckDate, DOCNUMBR AS CheckNumber, DOCAMNT AS CheckAmount FROM PM30200 WHERE (DOCTYPE = 6) AND (DOCAMNT > 25000) Add this to the end of the WHERE clause AND (VOIDED = 0) -- Japheth Nolt MCP Microsoft GP/SBF Specialist Landis Computer http://landiscomputer.com "Michael@nyresume.com" <Michaelnyresumecom@discussions.microsoft.com> wrote in message news:7163A485-9E90-48C7-B931-C989827039D6@micros...

Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an Access Database. The count of the records is then stored in a Worksheet. For most of the queries, the figure stored in the Worksheet matches the number of records if you run the query in Access. But for certain queries, the count of the records does not match the number of records when the query is run in Access. If I change the query to a make table query and then base another query on that table, the results are correct. Can anybody suggest running the query from Excel would results in a different number of records bein...

Outlook 2003: Email address in 'From' column of Inbox.
Anyone know how to get the full email address to display in the 'from' column of the inbox in Outlook 2003? I have about half a dozen "Dave"s that all have different email address but they're indistinguishable in the inbox. Plus, I'm sick of just seeing someone's name when I really need to know the company name more than anything else. At least with a proper email address, I can easily work out if it's a legit email from a known company or spam. I don't want to have to read the post to see if it's valid. ------------------------------------------...

Append Query
I have a table "Rates" with the following data: StartDate: 5/15/08 End Date: 6/23/08 Rate: $53 StartDate: 6/24/08 End Date: 7/15/08 Rate: $86 StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99 I have another table "Transactions". I want to create an append query such that if I supply the StartDate and EndDate, the query will populate the "Transactons" table with date and rate data from the "Rates" table for each and every day within the date range. Example: If I supply the StartDate of 6/23/08 and the EndDate of 6/25/08, the query would pop...

Traspose Column data into Row
Hi, I want to transpose column data in to row. I have seen many posts (using INDEX or OFFSET functions) but all these solution assume a fixed block of data to be transposed, My problem is that the data i have not only has variable blocks to be transposed but also has some duplicate headings(headings are duplicate but the data in front of each heading has different value. Below is the example of data Col A Col B Col C PRODUCT COST COMPONENT COST$ A Raw Mat 10 A D L ...

Use list options to hide columns
Excel 97 Hi, I was wondering if the following is possible in excel: <big deep breath> I have 4 separate worksheets for data entry and results calculation for radiation detection, each is a separate type of test. These worksheets/tests share a lot of common Fields for data input and calculations, what I want to do is combine the worksheets and show/hide only the columns relevant to each test. In column A, I have added a drop down list of 4 different types of test. Depending on the type of test I select; call them A, B, C & D Can I use a List to control which columns are sho...

List of SNMP MIBs for Exchange
Does anyone know if there is a list of SNMP MIBs available for Exchange 2003 anywhere? I'd like to get some basic statics via SNMP. On Tue, 14 Feb 2006 09:17:40 -0500, Irwin Fletcher <noffletchspam@nogmailspam.com> wrote: >Does anyone know if there is a list of SNMP MIBs available for Exchange >2003 anywhere? I'd like to get some basic statics via SNMP. I think you should be looking at WMI instead. ...

How do I eliminate duplicate addresses from multiple lists?
Just moved to Exchange from GroupWise. I maintain seperate address lists in excel and access and some of the addresses are in both lists. In GroupWise I could copy an entire column of addresses from an Excel spreadsheet into the To: box and blanks would be eliminated, then I could copy a column of addresses from an access database into the To: box and both blanks and duplicate email addresses are eliminated. How can I configure Outlook to do this? Nichol1947 <Nichol1947@discussions.microsoft.com> wrote: > Just moved to Exchange from GroupWise. I maintain seperate address ...

Make Excel Database from HTML
Hello. Im new here and I kinda know some about Excel but I have a problem. I need to make an Excel Database from an HTML file and I dont know how to get about doing it. The website is simple w/ one graphic at the top and just links going down... I dont know if Im posting in the right place but... Thanks, Nick -- NTL1991 ------------------------------------------------------------------------ NTL1991's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29081 View this thread: http://www.excelforum.com/showthread.php?threadid=488078 No One? Nic -- NTL199 ---...

SQL Query to transform/group data by Date
Hi, I have a large Access table with data organised as follows: Field1: Code Field2: Date Field3: Value1 Field4: Value2 There are seveal different codes and therefore duplicate dates. I'd like to run a query to bring back each code grouped by date and so put the codes along the top as feilds. For example the query below brings back the following data for two codes. SELECT field2, field1, field3 FROM Data WHERE field1 In ('LLOY','RSA'); 21/01/05, LLOY, 12454 22/01/05, LLOY, 31541 21/01/05, RSA, 21241 22/01/05, RSA, 12414 Instead I want the data to look like this: ...

Drawing a selection box using CRectTracker
Hello, I have an MFC SDI CView application and I want to draw an selection box when the user left clicks and move the mouse. I have found the CRectTracker class but I can't get it to work I have this code: void CSCMLaserView2::OnLButtonDown(UINT nFlags, CPoint point) { SetCapture(); m_startPt = point; m_theRectTracker.TrackRubberBand(this,point,TRUE); } void CSCMLaserView2::OnLButtonUp(UINT nFlags, CPoint point) { //Release the capture on the mouse ReleaseCapture(); CSCMLaserDoc* pDoc = GetDocument(); ASSERT(pDoc != NULL); CClientDC dc(this); OnPrepareDC(&dc); // Co...

IF ISNUMBER FIND in query design expression
I use the following formula in Excel and it works...I now want to do this in a query. Can I add it as an expression in the design grid in a seperate column and how does the syntax change? I will also want to use TRUE/FALSE for the result. =IF(ISNUMBER(FIND("TRANSF",H2)),"*", "") Try this -- My_Output: IIF(InStr([YourFieldName],"TRANSF")>0,"*", "") -- Build a little, test a little. "gator" wrote: > I use the following formula in Excel and it works...I now want to do this in > a query. C...

list links in new worksheet
I want to get a listing of all links in a new worksheet within th workbook - alternately I would like to get a list of all linked cells is there a way to do this? Thank -- Message posted from http://www.ExcelForum.com Something like this post: http://groups.google.com/groups?threadm=40C12CE0.8E5E3F8C%40msn.com And no matter what you're doing with the links, get a copy of Bill Manville's FindLink program: http://www.bmsltd.ie/MVP/Default.htm "txbjones <" wrote: > > I want to get a listing of all links in a new worksheet within the > workbook - alternately...

Converting MS query from Excel 2003 to Excel 2007
I have a master spreadsheet that I want to convert to xlsm format. However, I have two other spreadsheets that utilize MS Query to pull data from my master spreadsheet. How can I convert my master spreadsheet without losing the MS queries I have built in the other two spreadsheets? Is there a simple conversion process? I have tried to update the individual ms queries but I keep on getting error messages when I point to my master spreadsheet with the xlsm extension. Thanks. The "problem" with MS-Query and Excel 2007 is that instead of downloading the query to a data...

Adding an address to a Contact List
The client is using Outlook 2003 SP2. I know you can click on an email address in an email and add it as a contact to my main Contacts list. Is there a way to do the same task but add it to my other Contact Lists already setup as an addressbook...? Thanks, Tom... Tom Karpowski wrote: > The client is using Outlook 2003 SP2. > I know you can click on an email address in an email and add it as a > contact > to my main Contacts list. > Is there a way to do the same task but add it to my other Contact Lists > already setup as an addressbook...? > >...

Random Number in Query
Hi. I am trying to get a Random number between 0 and 5 to appear on each row of a query. I can get the same number on each row (it changes every time I run the query) but cannot get a different random number for each row. Basically, I want to create some Test data by adding the Random number to a Received Date and then saving this new date as a Completed Date. I have created a Module to generate a Random number: Function Random_Number() As Integer Randomize Random_Number = Int(Rnd * 6) End Function Then, I call the function from a query: Field = Number: Random_Number() Ca...

Select tab to import from excel spreadsheet in Macro
I have one excel file that contains multiple tabs. Is it possible to select a specific tab to import in a Macro? I have static labels on these tabs that can be referenced. If so, which function would that be? Your help is appreciated! Kanley Just to clarify, I just need to import one tab at a time, but when i specify the worksheet name in the range field as WORKSHEET!, it wouldn't take it. Please help! On Oct 30, 11:29 am, KT <kan...@rocketmail.com> wrote: > I have one excel file that contains multiple tabs. Is it possible to > select a specific tab to import in a Mac...

word freezes at the template selection screen at startup
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC My whole machine went down about a month ago. Finally got to installing office today and word freezes. I've uninstalled and reinstalled to no effect. Download and install the latest Office 2004 updates, which are the Office 2004 11.5.0 & 11.51 updates. In Office 2004, use Microsoft AutoUpdate to get the latest updates. From any Office application, go to Help > Check for Updates (or manually launch Microsoft AutoUpdate from the Applications folder). If any updates are needed, they will display in a sheet...

Linking columns for auto fill
Can I link two columns to auto fill Column A when corresponding data is entered in Column B? In A1 enter =IF(B1="","",B1) Copy down column A as far as you wish. Gord Dibben MS Excel MVP On Thu, 25 Mar 2010 09:11:01 -0700, Daisy <Daisy@discussions.microsoft.com> wrote: >Can I link two columns to auto fill Column A when corresponding data is >entered in Column B? ...

Dlookup in query
Hi guys, I have a query in which i want to use a dlookup which i have embedded in a function. Strange thing is that the first record returns the correct value and after that i get a invalid use of null.. ?? scenario (for testing purposes) table1: MyDate (set to date time) MyAmount (set to currency - standard - two decimals) table2: Dummy (text field) FutureDate (Set to date time) Created a query with the two fields from table2 both fields added to the querygrid. Third field added as follows: Amount: getprice(FutureDate) Module: function GetPrice(FutureDate) as d...

Lists
I have a user who is importing an excel spreadsheet into a Sharepoint List, but some of the column types that SP is selecting is incorrect. I can't find any place to change the type of these columns (like from text to text with link, etc). Is this possible? Yes, you can change the column type after importing. Just go to the list settings page and choose the column you would like to update. The very first section of the column settings page will be for the data type of the column. -RH "J. Belcher" wrote: > I have a user who is importing an excel sprea...

Selecting Cells with Shift Key
When I am selecting cells in Excell, I use the shift key and the arrows on my keyboard. If I pause at all, the selection is lost when I continue with the selection. Why? Can anyone help me? If you have removed your finger from the shift key then Windows will think you are starting a new selection. Just be sure that you don't touch the arrows without the shift being held down. LWhite "Jaymndad" <Jaymndad@discussions.microsoft.com> wrote in message news:961E850D-AFAD-444C-AB81-F4A609BCB3BA@microsoft.com... > When I am selecting cells in Excell, I use the shift key...

open excel 2007 refresh query from batch file
Hello all, I have a simple script saved as "C:\refresh_excel.vbs" that opens an Excel file, and does a refresh for a query on Sheet 1. I created a scheduled task to run this every day. It worked fine for previous versions of Excel, but since I have upgraded to Excel 2007 it doesn't work. Any help it helping me figure this out would be appreciated. /*contents of refresh_excel.vbs*/ Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls") objWorkbook.Sheets("...