Automatically Sorting Columns into Worksheets

  • Thread starter Thread starter Patrece
  • Start date Start date
P

Patrece

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!
 
You could use formulas in teh respective sheet to extract the data.


You could write a macro that breaks out the information
 
when you say formulas do you mean like an if function
cause there are 77 different names (sheets) that the
information from sheet one could go too. so would be be
something like:
like cell A1 would have
=IF(A1=stevens,Sheet2!,A2)
then cell A2 would have
=IF (A2=jones,Sheet3!,A3)
etc....
and how could i make this macro that could break them up?
can you give me more information on that. thanks in
advanced!
 
No, you have to put your formulas in the destination sheets, not the source
sheet.

You would need to use array formulas to build a list of rows to extract from
and then embed those in formulas like Index or offset to actually retrieve
the data.

As far as a macro, if you don't know anything about macros, then that
doesn't sound like an option for you.


If the sheets don't need to be pre created, you could make a pivot table out
of your data then make the names the page field and double click on it -
this should create all the worksheets and populate them.
 
Back
Top