Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Worksheets update
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Consolidation of Worksheets | Excel Worksheet Functions | |||
Simple...Update Text Box in Chart | Charts and Charting in Excel | |||
Simple Way to Count the Number of Duplicate Dates on Multiple Worksheets | Excel Discussion (Misc queries) | |||
Update another worksheets | Excel Worksheet Functions |