View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
goingtospace goingtospace is offline
external usenet poster
 
Posts: 1
Default use macro to append records to worksheet

Hi. I am very new to writing macros and would really appreciate some
help. I have an excel macro that opens outlook, looks for certain
messages and extracts data from them to excel. so far so good. The
problem I have is that each time it runs, it creates a new worksheet -
I would like it to run in the same worksheet each time and append the
new records at the end. Any tips very gratefully received.
Thanks loads