auto added checkbox

Hello everyone. I wanna ask about this problem:

I have a table of data(Sheet1), which all the data will retrieve from physical folder (C:/Data).
(as attach image)

My problem a

1) When new data retrieved, a checkbox will automatically add, at the end of the column. The new data will be inserted row by row.
2) When the checkbox is ticked, send the ticked data to another sheet (Sheet2).
At the Sheet2, there have two column. So, both of two column is need to be automatically ticked when the checkbox at Sheet1 have ticked.


I appreciate your help to solve my problem.

-nia-

Hi
Your file is at this link : http://cjoint.com/?BGexpx8kguO
Some instruction on the sheet, test it before.
HTH
Cimjet
"niailmar" > wrote in message
...
>
> Hello everyone. I wanna ask about this problem:
>
> I have a table of data(Sheet1), which all the data will retrieve from
> physical folder (C:/Data).
> (as attach image)
>
> My problem a
>
> 1) When new data retrieved, a checkbox will automatically add, at the
> end of the column. The new data will be inserted row by row.
> 2) When the checkbox is ticked, send the ticked data to another sheet
> (Sheet2).
> At the Sheet2, there have two column. So, both of two column is need to
> be automatically ticked when the checkbox at Sheet1 have ticked.
>
>
> I appreciate your help to solve my problem.
>
> -nia-
>
>
> +-------------------------------------------------------------------+
> |Filename: check and send data.JPG |
> |Download: http://www.excelbanter.com/attachment.php?attachmentid=450|
> +-------------------------------------------------------------------+
>
>
>
> --
> niailmar

Sorry wrong post, please ignore the previous post.
Cimjet
"niailmar" > wrote in message
...
>
> Hello everyone. I wanna ask about this problem:
>
> I have a table of data(Sheet1), which all the data will retrieve from
> physical folder (C:/Data).
> (as attach image)
>
> My problem a
>
> 1) When new data retrieved, a checkbox will automatically add, at the
> end of the column. The new data will be inserted row by row.
> 2) When the checkbox is ticked, send the ticked data to another sheet
> (Sheet2).
> At the Sheet2, there have two column. So, both of two column is need to
> be automatically ticked when the checkbox at Sheet1 have ticked.
>
>
> I appreciate your help to solve my problem.
>
> -nia-
>
>
> +-------------------------------------------------------------------+
> |Filename: check and send data.JPG |
> |Download: http://www.excelbanter.com/attachment.php?attachmentid=450|
> +-------------------------------------------------------------------+
>
>
>
> --
> niailmar