Most valuable professional
  • Hot Topics

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.

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

This thread is current as of February 5, 2018.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel