View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Imported and Manually Entered Data

It sounds as if you are inserting new data in a range of cells as opposed to
inserting rows at a time.

col1 col2 col3
doc desc date
doc2 desc2 date2
etc.
Then when you insert new data you get this:

col1 col2 col3
doc desc date
doc3 desc3 date2
doc2 desc2 blank

So you inserted cells instead of rows? If that is the case, the simple fix
would be to insert whole rows instead.