We have 6 workbooks.
Each has between 10 and 100 or so tabs
Each sheet is records customer details. There is a cell in each - [I2] - which has "yes" or "no" for newsletters
What we want to do is to create a sheet which shows just the following information for those who have "yes" in cell I2
firstname [c16], surname [c17], email [C20]
...and another sheet the same for those who have "no" in [l2].
This justt needs to be on a separate simple sheet so that it can be processed by us asinto the email newsletter system
and another sheet the same for those who have "no" in [l2].
56 freelancers are bidding on average $41 for this job
Ready to complete this job for you. I'm in the Accounting field and work with Excel regularly on a daily basis. Can easily get this work done for you.