View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erik Erik is offline
external usenet poster
 
Posts: 96
Default import data into existing excel file

I need to import an excel worksheet from one file into another one. I know
how to do this, but my file has about 16 rows of data at the top that never
changes and needs to stay. It also has 4 rows of information that need to
stay at the end (basic calculations are in these rows that are based on the
imported data). So, I need to import data and insert between the rows
existing, but when I try to import, it will import the data and insert at row
16 (like I need it to), but it erases everything else. How can I import data
so that it will paste between my upper rows (1-16) and the 4 rows of data
that need to be at the end.