S
SPP-IT
I have an excel file that maps to a csv file. I am trying to implement a
column Y in this Excel file that grabs the data in column X cell 1, queries a
database for information based on that content, and then returns the data (if
any) to column Y cell 1. I want this to happen for each cell in column Y
corresponding to each cell in column X...so X:2 would determine Y:2 and so
on. I can set up a query using the wizard to do this, create the parameter
and set the value of the parameter based on the content from the selected
cell. What I have a problem with is implementing this for the entire column.
With a function you can drag the mouse down, however, that does not work
with the query, it just copies the content not the query
implementation/parameter. Basically, I would have a whole column of queries
pointing to X:1. Any help would be appreciated! Thank you!
column Y in this Excel file that grabs the data in column X cell 1, queries a
database for information based on that content, and then returns the data (if
any) to column Y cell 1. I want this to happen for each cell in column Y
corresponding to each cell in column X...so X:2 would determine Y:2 and so
on. I can set up a query using the wizard to do this, create the parameter
and set the value of the parameter based on the content from the selected
cell. What I have a problem with is implementing this for the entire column.
With a function you can drag the mouse down, however, that does not work
with the query, it just copies the content not the query
implementation/parameter. Basically, I would have a whole column of queries
pointing to X:1. Any help would be appreciated! Thank you!