What is your code for sheet2? Are you wanting it to do the same thing only
post data one cell down rather than insert a new row?

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"KLEM" wrote in message
...
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