Unable to run a macro to sort out data on different worksheets saved on a single workbook

[Makwa]

The problem here is to get the macro to automatically run this procedure on different spreadsheet ,how do I get the macro to also run this sort code/procedure without my interference?

The problem here is after sorting the data(adding headers, columns and separating text to numbers)i now want to sort the entire worksheet by "sales unit this year" then move to the last ACTIVE cell, then got to the next empty cell then put in that column and assign it to the data in column F then populate the data to the last cell that has data .

i use a for loop to move through deferent worksheets in this workbook the code must be able to accommodate the dynamic number of worksheets and data on each worksheet




please see below

 

[OaklandJim]

I understand that you tried to describe the issue/need but unfortunately, it is not totally clear to me. Maybe try to describe the need again, differently.

The pictures are only somewhat helpful.

First try posting your VBA code in a post. Someone may be able to tell you how to modify it. To do that use the "quick wrap" at the top of the post that says VBA. "Wrap" your code within the start and end labels. Example:

Sub DoSort(pwsSortSheet As Worksheet, psKeyHeaderName As String, pvDirection As Variant)
    
    Dim rAllData As Range
    
    With pwsSortSheet
        
        Set rAllData = .Range(psKeyHeaderName).CurrentRegion
        
        With .Sort
        
            .Header = xlYes
            
            .SortFields.Clear
            
            .SortFields.Add Key:=Range(psKeyHeaderName), Order:=pvDirection
            
            .SetRange rAllData
            
            .Apply
        
        End With '.Sort
        
    End With

End Sub

Use the Preview button (upper right for a post) to see if the code looks like it does in the VBA editor. Add comments to the code so the helper understands what you are trying to do.

Also, try using Mr Excel's excellent XL2BB add-in to post portions of your worksheets. See here: Link to Add-in

If possible use dropbox or 1drive to post a link to any workbooks that you can share. Otherwise 1) helpers have to guess what is in them and 2) helpers have to manufacture "fake" data to work with. Making such fake data can take a lot of work for the helper.

I hope that this was helpful.