how to transfer data from sheet to sheet with new range?

Giganews Newsgroups
Subject: how to transfer data from sheet to sheet with new range?
Posted by:  Jon
Date: Sun, 19 Aug 2007

Greeting
I have a work book with two sheets. Sheet 1 is for entering data with range
from a1to d1. in sheet 2, I need the range in sheet 1 to be transferred to
a1:d1. What I want to do is when entering data in sheet 1, the data transfer
to sheet 2 and if there is a data in the above rang, a new range is setting
for the new data.
thanks

Replies