Copying rows to another sheet

Closed

BGutschow

Posts: 1
Registration date: Wednesday February 7, 2018
Status: Member
Last seen: February 7, 2018

- Feb 7, 2018 at 02:52 PM
Blocked Profile - Feb 7, 2018 at 03:33 PM

I'm looking to copy certain cells in a row to a new sheet if another cell meets certain criteria.

If column O has "Yes" i need to copy cells A-F onto a new sheet.

Copying rows to another sheet
Excel - Copying row from another sheet - How-To - Excel
Copying cell from one sheet to another - Guide
Excel if cell contains text then copy row to another sheet ✓ - Forum - Excel
Excel copy row to another sheet based on cell value without macro ✓ - Forum - Excel
Copy rows to other sheets based on value in column ✓ - Forum - Excel

1 reply

Answer 1 / 1

Blocked Profile
Feb 7, 2018 at 03:33 PM

Take a look at this article, it is exactly what you are asking about!

https://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula

Subscribe To Our Newsletter!