When something is entered in a cell on a worksheet, a new row and that value is generated on another
Posted by Jerry Cain on June 22, 2001 7:48 AM
Hey there
Does anyone know how I can do this:
I have a workbook and I want it so that if I enter a number in a cell on one of the worksheets, a new row on another worksheet is inserted and the value I entered appears in one of the cells of the new inserted row.
Can this be done?
Thank you for any help you may be able to give
Posted by Damon Ostrander on June 22, 2001 8:27 AM
Jerry,
Yes, this can be done quite easily using VBA.
The code to insert the new row and enter the value would have to be put into a Worksheet Change event for the sheet you enter the data into. From your question I wasn't sure whether you wanted anything entered in ANY cell on the first worksheet, or just one (or perhaps several) specific cell, or where you want the new row inserted in the other worksheet. Let me know, and I'll send you an example.
Damon
