Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to excel and maintaining info
I am exporting a report (or query) to excel, the headers the query supplies
are non-sense to everyone not involved in building the database. How can I export to a template with the headers in place and not have them written over (deleted) by the non-sense headers? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to excel and maintaining info
Create the headers you want to show on row 1. Then have the report imported
starting on row 2. Hide row 2 (the nonsensical headers). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shannon" wrote: I am exporting a report (or query) to excel, the headers the query supplies are non-sense to everyone not involved in building the database. How can I export to a template with the headers in place and not have them written over (deleted) by the non-sense headers? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to excel and maintaining info
How do I export starting on row 2?
Thank you "Luke M" wrote: Create the headers you want to show on row 1. Then have the report imported starting on row 2. Hide row 2 (the nonsensical headers). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "shannon" wrote: I am exporting a report (or query) to excel, the headers the query supplies are non-sense to everyone not involved in building the database. How can I export to a template with the headers in place and not have them written over (deleted) by the non-sense headers? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to excel and maintaining info
Easiest way? Export to a new workbook, open your template, and paste rows 2
through bottom... Otherwise, to export directly to Excel, that would completely depend upon your method. "shannon" wrote: I am exporting a report (or query) to excel, the headers the query supplies are non-sense to everyone not involved in building the database. How can I export to a template with the headers in place and not have them written over (deleted) by the non-sense headers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining history Data in Excel | Excel Worksheet Functions | |||
Exporting Excel Sheet With Additional Info Added To A Text File | Excel Discussion (Misc queries) | |||
Exporting info from a cell | Excel Discussion (Misc queries) | |||
Exporting work sheet info to envelopes | Excel Discussion (Misc queries) | |||
Exporting contact info to Outlook 2003 | Excel Discussion (Misc queries) |