View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KLEM KLEM is offline
external usenet poster
 
Posts: 1
Default Macro to save data in one cell and add new data in cell below etc

Hi,

(Using xl03) I work on 3 worksheets. When I input data on w/sheet 1, it is
automatically entered onto worksheet 2 & 3. I run a macro on w/sheet 2 to
retain the data from w/sheet 1 but to also insert a new line (hence data
moves down 1 cell and if I input new data from w/sheet 1, this is now in the
'inserted' line in w/sheet 2 and so on.

My problem is with w/sheet 3. I need a macro that retains the data from
w/sheet 1 (similar to above macro), but rather than inserting a new line, I
want the new data in the cell below it and so on.

Any suggestions will be muchly appreciated.
--
KLEM