ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting Multiple Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/140844-sorting-multiple-worksheets.html)

[email protected]

Sorting Multiple Worksheets
 
I have five worksheets of data how do I sort all 5 sheets of data
alphabeticaly?

joel

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?


Gary''s Student

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?


[email protected]

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?


Toppers

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?



All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com