query destination field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you change a destination field of a query in Excel? I have the data from the query being sent to cell A4 but need it to go to cell A1.

I tried the "edit query" option but with no luck
 
albert

I think you can just delete Rows 1:3 and it will adjust accordingly.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

albert said:
How do you change a destination field of a query in Excel? I have the data
Click to expand...
from the query being sent to cell A4 but need it to go to cell A1.
 
Select the sheet that contains the query results
Click the dropdown arrow in the Name box, to the left of the Formula bar
Select the query range, e.g. Query_from_MS_Access
Drag the selected range so the top left cell is in A4
 
Correction:
Drag the selected range so the top left cell is in A1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Links error when insert line/row to source workbook 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Excel Query setup 0
Receiving valid Multicast address failed on mini port driver 0
Getting request that a query have a destination field 3
Searching Lists 4
how to get IF(OR) formula to recognize multiple cells 7
Access #Error & Excel Pivot 0

Back
Top