ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting into Excel (https://www.excelbanter.com/excel-discussion-misc-queries/112518-exporting-into-excel.html)

Chey

Exporting into Excel
 
Is there a way to export into excel by skiping every other row.
I have a report that i would like to export into excel. It places it on
each row. I would like a row between each row of data. I have tried placing
an unbound field on my report and that did not work. Any other suggestions?

Thanks
Chey

Jim Cone

Exporting into Excel
 
You can add the blank rows after the data is added...

If you have 100 rows, then in an adjacent column fill
down numbers from 1 to 100 then continue on
down with another fill of 1 to 100.
Sort your data including the new column by the new column.
Your done.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Chey"
wrote in message
Is there a way to export into excel by skiping every other row.
I have a report that i would like to export into excel. It places it on
each row. I would like a row between each row of data. I have tried placing
an unbound field on my report and that did not work. Any other suggestions?

Thanks
Chey

hot dogs

Exporting into Excel
 
inmport the list, then you could hold 'ctrl' and slect each row in the list
by turn, then right click one of the row numbers and select insert, this will
insert a row in-between each row of data, but if you have a long list it
might be time consuming to select each row.

"Chey" wrote:

Is there a way to export into excel by skiping every other row.
I have a report that i would like to export into excel. It places it on
each row. I would like a row between each row of data. I have tried placing
an unbound field on my report and that did not work. Any other suggestions?

Thanks
Chey



All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com