Dear All

I am a VBA beginner, I will be very grateful if you can give me a VB
script for the following situation, cheers!
================================================== =======
I have 2 worksheets, "Sheet1" and "Sheet2". Lets say, there are
columns and 2 rows in Sheet 1

SHEET
Apple
6
4
(8) <------ new input

If I input a new row (8) in Sheet 1, this can generate 3 new rows i
Sheet 2. This logic is in accumulated basis.

SHEET
Apple
6
6
6
4
4
4
(8) <------ new update
(8) <------ new update
(8) <------ new update
================================================== =======

I will apply your given VBA script onto an action button in Excel. I
other words, data inputter need to press this button after each new ro
has been added in Sheet 1. Many many thanks!!!

Best Regards
Kelvi

--
KelvinVB
-----------------------------------------------------------------------
KelvinVBA's Profile: http://www.excelforum.com/member.php...fo&userid=1629
View this thread: http://www.excelforum.com/showthread.php?threadid=27690