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

Viren - Sep 4, 2017 at 02:05 AM - Latest reply: vcoolio 1171 Posts Thursday July 24, 2014Registration dateModeratorStatus June 21, 2018 Last seen
- 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


See more 

Your reply

1 reply

vcoolio 1171 Posts Thursday July 24, 2014Registration dateModeratorStatus June 21, 2018 Last seen - Sep 4, 2017 at 06:03 AM
0
Thank you
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.
Respond to vcoolio