Forum Discussion

MSTS0022's avatar
MSTS0022
Copper Contributor
May 09, 2024
Solved

Copy cells to second sheet based on condition on one cell from first cell

Good Afternoon all!   I have Sheet1 with columns from A to O and the I column is Shipping Status. If I column value is Ready To Ship or Ready for P/U, I need columns/cells  B, I , J, K, L M, N, O t...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 09, 2024

    MSTS0022 

    In A2 on Sheet2:

     

    =CHOOSECOLS(FILTER(Sheet1!$A$2:$O$1000, (Sheet1!$I$2:$I$1000="Ready to Ship")+(Sheet1!$I$2:$I$1000="Ready for P/U"), ""), 2, 9, 10, 11, 12, 13, 14, 15)

MSTS0022's avatar
MSTS0022
Copper Contributor
May 09, 2024

HansVogelaar Thanks you .

 

I tried it however it did not work.

Could you please look into that again.

HansVogelaar's avatar
HansVogelaar
MVP
May 09, 2024

MSTS0022 

Which version of Excel do you have? The formula that I posted will work in Excel in Microsoft 365 (and Excel Online).

  • MSTS0022's avatar
    MSTS0022
    Copper Contributor
    May 09, 2024
    I tried in both.

    I am using Microsoft® Excel® for Microsoft 365 MSO (Version 2403 Build 16.0.17425.20176) 64-bit
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 09, 2024

      MSTS0022 

      It should work - I have attached a small demo workbook.

      If you cannot get it to work, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

Resources