Transfer activity data to new sheet with yes/no criteria.

Ask a question Viren - Last answered on Sep 4, 2017 at 06:03 AM by vcoolio

I need to prepare the excel summary with the help of Master sheet. If the drop down in master sheet is yes, than that option should be copy pasted in new sheet.

If no that option will not come in summary.


plus moins
Hello Viren,

You're going to have to elaborate a little more.

Where are the drop down lists situated? Are they all in a particular column?
Are they set in each cell in this particular column?

If the option "Yes" is selected in a cell, do you wish for the entire relevant row of data to be transferred to the Summary sheet?

How many columns are you using in the Master sheet?

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!