Copy rows to another sheet automatically based on cell value

In Excel for the web, you can use Microsoft Excel formulas along with the FILTER function to dynamically display the matching rows. Follow these steps:

Assuming your data is in Sheet1 and you want to copy rows to Sheet2 when the status in column F is "pending":

1. Open Sheet2 where you want the filtered data to be copied.
2. In the first row of Sheet2, enter the following formula in the first cell where you want the data to appear (let's say it's cell A1):
   
   

   Please Login or Register  to view this content.

   This formula uses the FILTER function to extract rows from Sheet1 where the status in column F is "pending."
3. Press Enter.

Now, whenever the status in column F of Sheet1 is set to "pending," the corresponding row from columns A to H will automatically appear in Sheet2 (you can change which columns appear from Sheet1 by changing Sheet1!A:H to whichever columns you want to see reflected in Sheet2).

Keep in mind that this method is based on formulas and will update dynamically as you change the data in Sheet1.

---

If you want to copy the row to another sheet instead of just displaying it dynamically, you can use Power Automate (previously known as Microsoft Flow) to set up an automated workflow. Power Automate allows you to create flows that can automate repetitive tasks across different applications, including Excel for the web.

Here's a basic outline of the steps you can follow:

1. Go to the Power Automate website (flow.microsoft.com) and sign in with your Microsoft account.
2. Click on "Create" to create a new flow.
3. Choose a trigger for your flow. For example, you can use the "When a row is added, modified, or deleted" trigger for Excel.
4. Set up the trigger by specifying the file and sheet where your data is located.
5. Add a condition to check if the status in column F is "pending."
6. If the condition is true, use an action to create a new row in another sheet (your target sheet) and copy the values from the current row.
7. Save and test your flow.

Power Automate provides a user-friendly interface that allows you to create automated workflows without the need for programming. It should be noted that the availability of Power Automate features may vary based on your Microsoft 365 subscription.

Edit: AI was used to construct part of this answer.