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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
