Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Paramater value in a cell
Hello. I have a worksheet that imports external data from a MS Access
database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Paramater value in a cell
Are you running a macro? How are you prompting the User for inputs if not a
macro. the macro can easily be modified if you post ift to write the dates to a cell. "cyb3rwolf" wrote: Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Paramater value in a cell
No, I am not running a macro. I have it set up in MS Query for the "Date"
criteria to be "= [Start Date] And <= [End Date]". And then i have excel set to prompt for the parameter. What i am trying to do is have 2 other cells in excel return the values for [Start Date] and [End Date]. I realize that it can get the paramater values from a cell or cells, but for my purposes, that isn't what i want to accomplish, I want to do the opposote; have 2 different cells return the values. "Joel" wrote: Are you running a macro? How are you prompting the User for inputs if not a macro. the macro can easily be modified if you post ift to write the dates to a cell. "cyb3rwolf" wrote: Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Paramater value in a cell
You could setup a macro to input the Start and End Dates. The macro would
put the value into the cells you want and also put these values into the Query. "cyb3rwolf" wrote: No, I am not running a macro. I have it set up in MS Query for the "Date" criteria to be "= [Start Date] And <= [End Date]". And then i have excel set to prompt for the parameter. What i am trying to do is have 2 other cells in excel return the values for [Start Date] and [End Date]. I realize that it can get the paramater values from a cell or cells, but for my purposes, that isn't what i want to accomplish, I want to do the opposote; have 2 different cells return the values. "Joel" wrote: Are you running a macro? How are you prompting the User for inputs if not a macro. the macro can easily be modified if you post ift to write the dates to a cell. "cyb3rwolf" wrote: Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date and ending date for the report when it is opened. What i want to do is have 2 other cells return the dates that were entered in for the paramaters. Anybody help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paramater driven value | Excel Worksheet Functions | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
Display contents of cell in another cell as part of text string? | New Users to Excel | |||
Naming Pivot Table Paramater Report | Excel Discussion (Misc queries) |