View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
outrigger outrigger is offline
external usenet poster
 
Posts: 9
Default update sheet with data at bottom of present data

I have 2 excel 2003 workbooks. Workbook one has 5 column with headings.
Workbook 2 has same five colums with headings. 2 gets updated every month
with data in A2:E5 (under the headings). I need this data range to go into
the workbook 1 at the bottom of the last entry. This is 4 rows and five
columns of data. I Need it to update only when called to update.