Copy new data being added automatically to sheet2

[Banks]

Hi,

I have this sheet which i am currently working on - what i would lik
to do is everytime a new bit of data is added to sheet1, i
automatically updates sheet2 (which is a datastore). It has to be abl
to find the next blank cell in the store so data isn't overwritten.

I would prefer not to use a button but am open to suggestions. Ar
there change events i could put code behind?

Kind Regards,

Alex

The file sometimes has problems opening straight from a folder so ope
excel first, and find the file through that. Cheers

+-------------------------------------------------------------------
|Filename: LDN.zip
|Download: http://www.excelforum.com/attachment.php?postid=3770
+-------------------------------------------------------------------

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy1.htm

You can use events to run the macro if you want
If you need more help post back

 

[Banks]

Hi,

Extremly useful looking site, i just cant get what i'm doing to work.

If you look at my attached sheet, the problem is that i have 2 area
which need to be looked at. There are 6 columns in each area, which
then want to be pasted to the datastore sheet automatically when th
user types in some extra data.

can you advise me on what to use and where? Would be much apreciated,

Kind regards,

Ale

+-------------------------------------------------------------------
|Filename: LDN.zip
|Download: http://www.excelforum.com/attachment.php?postid=3774
+-------------------------------------------------------------------

 

[Ron de Bruin]

I don't look at your file but you can use this example I think
http://www.rondebruin.nl/copy1.htm#range2

Try this first