Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use some Qwery to populate the sheet with the data from pre.
Can I populate the sheet with the data from a different sheet of the book
based on the value of the data on the sheet from one of the columns. Something like INsert into ..... select * from .... where .... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use some Qwery to populate the sheet with the data from pre.
Possibly using Data = Filter = Advanced Filter
-- Regards, Tom Ogilvy " wrote in message ... Can I populate the sheet with the data from a different sheet of the book based on the value of the data on the sheet from one of the columns. Something like INsert into ..... select * from .... where .... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use some Qwery to populate the sheet with the data from pre.
If i understand your question, what you're looking to do is build query based on cell input? If you were looking for the query "Select mycolumn from mytable wher mycolumn like = mystring" where all the "my" variables are taken fro cell input you could do the following. Dim mycolumn, mytable, mycondition As String Dim querystring As String mycolumn = [Sheet1!A1] <--- lets say the cell contains "age" mytable = [Sheet1!A2] <---- lets say the cell contains "family" mycondition = [Sheet1!A3] <---- lets say the cell contains "85" querystring = "Select " & mycolumn & " from " & mytable & " where " mycolum & " like " & mycondition You'd then get querystring as "Select age from family where age lik 85". So all you need to do is just pass the querystring string t whatever mechanism performs your query. Of course you can get muc creative than in taking the user's input but that gives you a basi idea of how to do it using cells for input -- ob3ron0 ----------------------------------------------------------------------- ob3ron02's Profile: http://www.excelforum.com/member.php...fo&userid=1545 View this thread: http://www.excelforum.com/showthread.php?threadid=27498 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use some Qwery to populate the sheet with the data from pre.
Hahah wow i totally misunderstood your question. Sorry -- ob3ron0 ----------------------------------------------------------------------- ob3ron02's Profile: http://www.excelforum.com/member.php...fo&userid=1545 View this thread: http://www.excelforum.com/showthread.php?threadid=27498 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to populate data from different sheet. | Excel Discussion (Misc queries) | |||
Need conditional data from 1 sheet to populate another sheet | Excel Worksheet Functions | |||
Populate order sheet with data from work sheet | Excel Worksheet Functions | |||
populate cells with data from another sheet | Excel Worksheet Functions | |||
Best way to extract data on one sheet & populate it on another sheet?????? | Excel Programming |