Copy new data being added automatically to sheet2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Banks - 01 Sep 2005 17:18 GMT

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

+-------------------------------------------------------------------

Reply to this Message

Ron de Bruin - 01 Sep 2005 20:17 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Hi,
>
[quoted text clipped - 17 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=3770 |
> +-------------------------------------------------------------------+

Reply to this Message

Banks - 02 Sep 2005 11:14 GMT

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

+-------------------------------------------------------------------

Reply to this Message

Ron de Bruin - 05 Sep 2005 17:08 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Hi,
>
[quoted text clipped - 15 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=3774 |
> +-------------------------------------------------------------------+

Reply to this Message