View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrece Patrece is offline
external usenet poster
 
Posts: 3
Default Automatically Sorting Columns into Worksheets

i was wondering, is it possible to have data be imported
into excel sheet 1 automatically sort into different
sheets by the information given.

i.e:
imports into sheet 1:
name id# contract#
alicia stevens 403 174309
greg johnson 721 309581
alicia stevens 403 290385
david micheal 124 093480

sheet 2 (aka stevens)
name id# contract#
alicia stevens 403 174309
alicia stevens 403 290385

sheet 3 (aka johnson)
name id# contract#
greg johnson 721 309581

sheet 4 (aka micheal)
name id# contract#
david micheal 124 093480


so is there some type of way to have the info from sheet
one automatically sort into their individual sheets as
soon as its dumped into excel? thanks in advance!