Exporting / or copy to Excel

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

Guest

Hi:

How can a I export or copy an Access query result to Excel (always the same
columns) and keep the formula that I have originally in Excel; so: to have in
col X, for example M2*2 before the col X is populated??

Any help is appreciated!

Thanks,

Dan
 
1. save the formulas in column X to an un-used column
2. perform the export to Excel
3. restore the formulas from the un-used column back to column X
 
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

Resize a row but copy but skip columns I don't want to copy 6
Export Data to Text file with fix format 11
Six columns randon no.'s no dupes 6
convert columns to rows 6
Excel 2007 Like or Contains Expression 2
Macro to copy A1 tp J(bottom) 1
VBA to run all variable combinations in a calculation model and store result 6
Formula or VB? 1

Back
Top