How do I...

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

Guest

Hello.

I am trying to copy the results of 51 queries to one workbook worksheet via
the Transfer Spreadsheet macro command. What I want to do, though, that
isn't working for me at present, is to just copy a single value to a
specified cell on the worksheet, then repeat the proces for the remainder of
the queries and to copy to different cell locations on the same worksheet.
How do I do this to avoid having to create 51 seperate worksheets and then
referening thwese worksheets to get the values onto a single master worksheet
within the workbook?

Prefer to accomplish without code, but code is acceptable, if necessary.

Thank you.

NWO
 
I, for one, have never heard of "Transfer Spreadsheet macro command".

Is it a feature of the new 2007 version?


Gord Dibben MS Excel MVP
 
I think the OP may have intended to refer to the TransferSpreadsheet macro
command, which is (I believe) a feature of Access, not of Excel.
 
Yes. Looked it up in Access help and found the Transfer Spreadsheet.

Thanks David.


Gord
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Absolute References and worksheets 0
Copy cells in Excel 1
need help on either doing a loop and counting specific values orusing subtotal function 2
How do I have a cell value define a dynamic named range? 15
Copy worksheet from one workbook to a master workbook 2
how do I use a cell from one worksheet in the equation of another 3
Copying Named Range 5

Back
Top