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

Report
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
Hello,

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.

Regards
Viren


1 reply

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
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?

Cheerio,
vcoolio.