Automatically Copy contents of cell to another worksheet?

Hello,

I have two worksheets. In worksheet called 2008 I have column A which is populated with peoples names. When I enter a name in this column I would also like the contents of this cell to be copie to column A in worksheet 2.

Currently I am using the formula ='2008'!A4 and so on. The trouble is that for the balk rows in column A in worksheet 2 instead of the cells being blank I have a "0" showing.

Is there a function or any way to automatically populate the contents (as I am already) but if the cell is empty for nothing to be displayed?

Any help would be much appreciated please.

Kind regards.

Paul

Originally Posted by davesexcel

Check out this thread ,
change sheet names and ranges as required
http://www.excelforum.com/showthread.php?t=591047

Thanks Dave,

This is giving me a good start (although I have to confess that I do not know much about using VB.

So, how do I use this code without sortng and also to include columns B and C from sheet1 as well? I used the code and got it sort of working so would just like to refine it a little if possible to get rid of the sort and also to add in columns B and C as well.

Thanks ever so!!