Excel Export of Report

S

Steve

I have a report that has 4 columns across an 8.5 x 11 sheet of paper. No
special graphics or anything to deal with. I'd like to export it to Excel in
the columnar fashion but when I export it coverts the data into ROWS rather
than COLUMNS - what do I need to do?
thanks!
 
F

Fons Ponsioen

I do not think there is a way to do this directly. One
option I see is to export the report to Word, convert it
to a table, and than take the table to excell.
Not a nice way to do it.
Fons
 
J

Jim/Chris

Why not export the query or table that the report is based on. It i
allot cleaner export. I export my data to a hidden sheet and the
reference the data on the main sheet. This keeps all my formatting
 

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 --> Word 4
Merging from an Excel file with graphics 1
Need Help with a VBA subroutine 0
VBA - exporting serial letters to single documents 0
Cell data entering slow! 0
creating report to print 4-up index cards on Avery 3381 3
Possible to Combine reports to's to a single box? 0
Report Width, why 23" not 11" 0

Top