Macros and sort function

G

Guest

I'm trying to create a macro for a workbook. The sorting feature doesn't
transfer to my next worksheet of data. How can I create a macro that will
allow sorting to each of my specified worksheets?
 
G

Guest

You have to edit the macro script
Replace the worksheet name (Sheet1) with ActiveSheet
 

Ask a Question

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.

Ask a Question

Similar Threads

Auto sort help. 2
Worksheet Names using Macros 5
Collapsing all groups 0
Sorting Macro in Excel 2007 2
Run a sort macro in a protected WORKBOOK 4
Sort each line horizontally and separately 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Sorting Macro 4

Top