Thread: Exportin to xl
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ScottO
 
Posts: n/a
Default Exportin to xl

I see your problem ... each time you export, the rows and columns can
be different depending on the report choices you make.
If you want the report to export to a known spreadsheet format,
you'll need to be very disciplined about how you go about it - e.g. I
suggest that you set the Column specs to Month so as to create room
for future months and to ensure that the YTD column is in a known
position. If you add to your chart of accounts, or use a previously
unused account, then row positions will change, so you probably need
to think about you account structures before you get too far along.
I hope this helps.
Rgds,
ScottO


"Trying To Excel" wrote in
message ...
| Hi Scotto
| I Have a similar version and there is button to export to
excel. One of
| the options is to export it to an existing file, I would like to
have that
| file already created so that the columns and rows are set to accept
the data.
| Otherwise each time a report is exported I would have to adjust
each time.
|
|
|
| "ScottO" wrote:
|
| I have the current version of Quickbooks Pro.
| When I view a report on screen, one of the available buttons at
the
| top of the report window is labelled "Export...".
| If I hit the export button, one of the export options is to
export as
| "a new Excel workbook".
| Is your version different?
| Rgds,
| ScottO
|
| "Trying To Excel" wrote
in
| message
...
| | I would loke to export a report from quickbooks to excel. Can
| someone walk me
| | through
|
|
|