Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -- Gary''s Student - gsnu200752 "D" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
exporting from Excel | Excel Discussion (Misc queries) | |||
Exporting Logo from Access 97 to Excel 2000 by copy and pastespecial is stopping Cell A1 selection | Excel Programming | |||
Exporting from Excel | Excel Programming | |||
Exporting Excel | Excel Programming |