Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i believe there will be too many variables (5 fields, each of whiuch
has approx 5 potential values, so this gives 5 to the power 5 combinations (3125 columns). i would like to be able to build an sql query within a vba code as this will be very fast and keep workbook size very small. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locating Source Data in Master Spreadsheet | Excel Discussion (Misc queries) | |||
Use a different spreadsheet as source data | Charts and Charting in Excel | |||
.xlt does not contain new data from source spreadsheet. | Excel Discussion (Misc queries) | |||
Use spreadsheet as data source | Excel Discussion (Misc queries) | |||
Setting Spreadsheet control data source to Excel file | Excel Programming |