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-

auto added checkbox
 

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

auto added checkbox
 

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