View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darryl Darryl is offline
external usenet poster
 
Posts: 1
Default Link Rows To Multiple Sheets Based on Value

Hello all,

I have a parent sheet that is updated periodically with data from
multiple regions. I would like to link several child sheets to this
parent sheet with each containing only data for a particular child. I
need an entire row of data from division 1 for instance to be on sheet
1 and the rows from division 2 to appear on sheet 2. This data will
continue to grow and be updated, so simply copying the filtered data
will not cut it for me.

What type of suggestions do you recommend to tackle this task?

Thank you in advance,

Darryl