View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sus sus is offline
external usenet poster
 
Posts: 3
Default Macro to update workbooks

Hello,

I was wondering how to set up a macro so that I can copy and paste data into
a 'master worksheet' that automatically updates certain cells in other
workbooks; also, is it possible to set up the workbooks so that the data
rolls over, e.g. old data is automatically placed in a new column? Thanks