LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Rows/Columns Automatically BG Excel Worksheet Functions 1 February 10th 09 05:43 PM
Sorting Rows/Columns Automatically BG Excel Worksheet Functions 0 February 10th 09 05:07 PM
Sorting Several Columns/Rows Automatically BG Excel Worksheet Functions 0 February 10th 09 05:05 PM
Sorting automatically by columns HumingBean Excel Discussion (Misc queries) 4 December 1st 06 10:46 AM
Sorting and copying automatically between worksheets nadia New Users to Excel 2 February 12th 06 10:18 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"