Link to home
Start Free TrialLog in
Avatar of c7c4c7
c7c4c7Flag for United States of America

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
SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of c7c4c7

ASKER

Adding a number is a problem, the customer is going to see it eventually and it could confuse them
Is there a particular reason you don't want to use VBA?

Dave
Avatar of c7c4c7

ASKER

Not really, it would be less work if Excel provided the functionality without writing the code.
Avatar of c7c4c7

ASKER

Appreciate your help, looks like code time