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

Closed
Viren - Updated on Sep 4, 2017 at 06:09 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 4, 2017 at 06:03 AM
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


Related:

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Sep 4, 2017 at 06:03 AM
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.
0