Can you send me the final code you used to do this. I cannot seem to get mine
to work. I am trying to type something in one sheet and automatically have it
available in a summary sheet in excel.

thanks!



"Nadia" wrote:

I would like to enter data into lists on 3 different sheets and I would like
that data to automatically collate on a summary sheet (i.e. as soon as I hit
enter after typing the data in one of the 3 sheets it should appear on the
summary sheet on the next available row).
Can this be done??