Excel Updating
 

Hi, thanks in advance for your help.

Is it possible (and if so how ) in Excel (using VBA or whatever
easiest) to have 2 worksheets A
and B where worksheet B is atomatically updated. A bit more complicated
tho!! I enter data into
worksheetA,
and worksheetB takes that data and enters into column 1 for instance.
(or column January)- Easy
enough so far. But when i clear worksheetA
and enter new data, I want worksheetB to take the new data again but
this time put it into column
2 (or Feb for
instance)???
Any ideas....thanks a mill, been wrecking my head