M
Mark T.
I am pulling data from a SQL Server database into a
spreadsheet using Microsoft Query [Data, Import External
Data, New Database Query]. I have that part working.
There is an option setting to have the query results copy
down adjacent cells to the data range being imported,
keeping it in synch with the variable number of rows
returned by the query. The adjacent cell in this case is
formula for me that operates on the data being imported.
This works great.
The problem is, the "Copy Adjacent Cells Down" feature
only appears to only copy adjacent cells to the right of
the data range returned, not to the left. Is it possible
to copy adjacent cells to the left of the result set? I
have definite need to copy cells in a column to the left
of the data because I use that column as the lookup key
in a VLOOKUP function, and of course that has to be the
left most column in a data range.
Hope this makes sense. Thanks for any help.
spreadsheet using Microsoft Query [Data, Import External
Data, New Database Query]. I have that part working.
There is an option setting to have the query results copy
down adjacent cells to the data range being imported,
keeping it in synch with the variable number of rows
returned by the query. The adjacent cell in this case is
formula for me that operates on the data being imported.
This works great.
The problem is, the "Copy Adjacent Cells Down" feature
only appears to only copy adjacent cells to the right of
the data range returned, not to the left. Is it possible
to copy adjacent cells to the left of the result set? I
have definite need to copy cells in a column to the left
of the data because I use that column as the lookup key
in a VLOOKUP function, and of course that has to be the
left most column in a data range.
Hope this makes sense. Thanks for any help.