View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SM1 SM1 is offline
external usenet poster
 
Posts: 5
Default 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".