Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have created a database of names and associated information. Names are
located in A1 thru A500 and sorted alphabetically. Corresponding data is contained in B thru I for each name. Now I would like to break up the list so that A-K is on worksheet1, L-S on worksheet2 and the remaining T thru Z on the worksheet3. What would be the best method of copying the information and then be able to add or delete names and data, and have it propagated into the correct sheet alphabetically? Thank you in advance. CS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |