ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy rows from one sheet to another based on a cell value (https://www.excelbanter.com/excel-worksheet-functions/123373-copy-rows-one-sheet-another-based-cell-value.html)

SM1

Copy rows from one sheet to another based on a cell value
 
I need a formula to copy rows of cells from one sheet to another based on a
specific cell name value (North, Central, or South). I will have a master
sheet containing information from three teams, North, Central, and South, and
three other sheets individually named. I want to move the row data to it's
related sheet based on these names. The names will be in the same column, "M".


Max

Copy rows from one sheet to another based on a cell value
 
See one response to your multi-post in .newusers
Please do not multi-post
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SM1" wrote:
I need a formula to copy rows of cells from one sheet to another based on a
specific cell name value (North, Central, or South). I will have a master
sheet containing information from three teams, North, Central, and South, and
three other sheets individually named. I want to move the row data to it's
related sheet based on these names. The names will be in the same column, "M".



All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com