Copying cells which have MS Query results

[markd89]

Hi,

I'm using Excel 2010.

I have a cell which displays a number returned from a SQL Server stored procedure. The stored procedure takes two inputs -- a date and an employee name. I have Excel properly pulling these from two cells in the sheet. The employee name "BILL" is in J1.

See: http://realityisreality.com/xl/ex1.jpg

So far, so good. I can change the date or change the name in J1 and the number updates dynamically.

Now, I want to copy/paste my source cell to another cell so that I can use it to get the same date but a different employee name. The original cell uses data from J as the name parameter. I copy and paste it to K and I expect the parameters to automatically update to use K, but they don't - they keep using J.

Question#1: How can I fix that so that Excel will automatically change the parameters when I copy/paste?

Question#2: Is t here a way to suppress "Column1"

This is a simple example. My project is to convert an Excel 2003 sheet which makes heavy use of SQL.REQUEST to work with Office 2010, so I know I need to resolve the two above to pull it off.

Thanks!

Mark

 

[markd89]

Question #2 I figured out. Click into the cell with the query result, on the Ribbon, click Table Tools Design and uncheck Header Row.

Question #1, is the bigger issue. My "real" spreadsheet has hundreds of cells, each of which is a total from a different stored procedure. To boil it down simply, I really need to be able to:

a. Copy cell J1, J2, J3 from my example (see the .JPG)
b. Paste into K1, K2, K3
c. Have the Stored procedure use K1 for it's parameter rather than J1.

Any help, much appreciated!

Mark

 

[markd89]

bump!