Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Worksheets
I have five worksheets of data how do I sort all 5 sheets of data
alphabeticaly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Worksheets
You haven't told us how your data is organized. Macro can help with these
type problems. You probably just want to paste all the data on one worksheet and then sort. so you don't corrupt your present data, add a new worksheet before pasting the data on the worksheet. Then do a normal sort. the macro would simply do the copying and pastingg automatically. " wrote: I have five worksheets of data how do I sort all 5 sheets of data alphabeticaly? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Worksheets
see:
http://groups.google.com/group/micro...1fe50a82037cba -- Gary''s Student - gsnu200718 " wrote: I have five worksheets of data how do I sort all 5 sheets of data alphabeticaly? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Worksheets
The data is listed by the products I sell. When I add new products I would
like to keep the names in Alphabetical order. I can sort one sheet but unable to sort all five. "Gary''s Student" wrote: see: http://groups.google.com/group/micro...1fe50a82037cba -- Gary''s Student - gsnu200718 " wrote: I have five worksheets of data how do I sort all 5 sheets of data alphabeticaly? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Multiple Worksheets
How many products (rows) in total (5 sheets)?
" wrote: The data is listed by the products I sell. When I add new products I would like to keep the names in Alphabetical order. I can sort one sheet but unable to sort all five. "Gary''s Student" wrote: see: http://groups.google.com/group/micro...1fe50a82037cba -- Gary''s Student - gsnu200718 " wrote: I have five worksheets of data how do I sort all 5 sheets of data alphabeticaly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting multiple worksheets | Excel Worksheet Functions | |||
sorting worksheets | Excel Discussion (Misc queries) | |||
Sorting data from multiple worksheets into a master sheet/tab | Excel Worksheet Functions | |||
Sorting Data from Multiple Worksheets | Excel Discussion (Misc queries) | |||
Sorting multiple worksheets simultaneously | Excel Discussion (Misc queries) |