c7c4c7
asked on
How to automatically add/copy or delete a a row from a second worksheet based on a value on another worksheet
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?
Thanks
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?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is there a particular reason you don't want to use VBA?
Dave
Dave
ASKER
Not really, it would be less work if Excel provided the functionality without writing the code.
ASKER
Appreciate your help, looks like code time
ASKER