Export from QuickBooks sets end of file marker at the last row ofworksheet not of the data.

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

When I export to Excel the end of file marker should be at the end of
data but is set at the last row. This causes significant delays when
deleting all the extra rows or when inserting columns. How can I
prevent that from happening?
 
You'll need to tell us what's the difference between 'end of data' and 'the
last row'. To me they are the same. A safe assumption is that Excel experts
know nothing about Quickbooks.

You'll also have to tell us what you are deleting, and how you are deleting
it (eg, macro, data filter, etc.)

The contributors to this group can do just about everything except read
minds.

Regards,
Fred.
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
how do I limit the number of rows when exporting data into excel? 3
VBA - retrieve data on last create named range from previous inserted named range 0
Export for Quickbooks to Excel creates a HUGE file 4
export data between excel files 1
Excel help please, Button to export data 6
End process at last row of data 3
Changing position of last used cell 4

Back
Top