View Single Post
  #1   Report Post  
fresh
 
Posts: n/a
Default using a slave worksheet


OK, so i have a long list of contacts with numerous columns containing
all sorts of corresponding data. What i'm looking to do is create a
sub-list(s) of specific contractors based on this master list that will
contain far fewer columns and only a select group of these contacts.
The master list is constantly be adding to and changed and i dont want
to have to manually change the smaller list(s) each time new
information is added. How can i create a worksheet that will
auto-update to include any changed information as well as full rows
being added or deleted?

any suggestions would be great, thanks :)


--
fresh
------------------------------------------------------------------------
fresh's Profile: http://www.excelforum.com/member.php...o&userid=23943
View this thread: http://www.excelforum.com/showthread...hreadid=375740