How to automatically add/copy or delete a a row from a second worksheet based on a value on another worksheet
Posted on 2012-03-23
Excel 2010, Win 7 Pro
I have a Workbook with 2 Worksheets, 1 of them we use to input data and perform calculations the second we want to create automatically from the first.
Basically the concept is the following
if a Cell, for example B1, of WorkSheet1 has a "Yes" copy that row to the next available row in worksheet 2
Do that in every row that has a Yes until the end of the Worksheet
If the Yes is changed to No delete it from the second worksheet
If it is changed from No to Yes add it to the second worksheet
Do it automatically if a row is added or deleted on Worksheet 1
Is it possible to do that without writing VBA code? If so how do I do it?