Excel: Copying Cells From One Sheet To Another Based On Certain Criteria


Hi there, I hope you can help me with this question. I'm not sure how to post an Excel spreadsheet but it may not be needed for this question anyway. Thanks in advance for your help! The spreadsheet would show Column A cells with either the word "yes" or "no." Same with Column B, C, D...M. Each column goes down 350 rows. Here are the actions I'd like to be able to accomplish... First Group: On "Sheet1", find the first "yes" that appears (going from top to bottom) in Column A. Copy cells from columns P-AH on that same row the first "yes" appears. Paste those cells on "Sheet2" in B1-T1. On "Sheet1", find the first "yes" that appears (going from top to bottom) in Column B. Copy cells from columns P-AH on that same row the first "yes" appears. Paste those cells on "Sheet2" in B2-T2. Repeat for columns C, D, E...M (first "yes" in each column, so Column M results will go to B13-T13). Second Group: On "Sheet1", find the second "yes" that appears (going from top to bottom) in Column A. Copy cells from columns P-AH on that same row the second "yes" appears. Paste those cells on "Sheet2" in B14-T14. On "Sheet1", find the first "yes" that appears (going from top to bottom) in Column B. Copy cells from columns P-AH on that same row the first "yes" appears. Paste those cells on "Sheet2" in B26-T26. Repeat for columns C, D, E...M with the third "yes" for each. Third Group: On "Sheet1", find the fourth "yes" that appears (going from top to bottom) in Column A. Copy cells from columns P-AH on that same row the fourth "yes" appears. Paste those cells on "Sheet2" in B27-T27. On "Sheet1", find the fifth "yes" that appears (going from top to bottom) in Column B. Copy cells from columns P-AH on that same row the fifth "yes" appears. Paste those cells on "Sheet2" in B39-T39. Repeat for columns C, D, E...M with the second "yes" for each. In total there will be 39 rows of data entered on "Sheet2." Thanks again!


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of February 05, 2018.


For more resources for Microsoft Excel