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?