I have created a query to export all open, released jobs into Microsoft
Excel. The part number, operation sequence, operation code, run quantity &
completed quantities are also exported. The problem is, when the data is in
Excel I want a blank row between each job. There are 800 jobs so I don't
want to insert the row manually.
Does anyone know how to insert a blank row at every change in job number
either in the Business Activity Query or in Excel? I have very basis macro
skills & have created one to insert a row but I don't know how to apply the
condition for every change in job number.
Any help greatly appreciated.
Dawn Pacepavicius
Pensafe Inc.
563 Barton Street
Stoney Creek, ON
L8E 5S1
T: 905.643.7188
F: 905.643.5088
[Non-text portions of this message have been removed]
Excel. The part number, operation sequence, operation code, run quantity &
completed quantities are also exported. The problem is, when the data is in
Excel I want a blank row between each job. There are 800 jobs so I don't
want to insert the row manually.
Does anyone know how to insert a blank row at every change in job number
either in the Business Activity Query or in Excel? I have very basis macro
skills & have created one to insert a row but I don't know how to apply the
condition for every change in job number.
Any help greatly appreciated.
Dawn Pacepavicius
Pensafe Inc.
563 Barton Street
Stoney Creek, ON
L8E 5S1
T: 905.643.7188
F: 905.643.5088
[Non-text portions of this message have been removed]