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

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