Alpha numeric sorting across tabs

[jrobertsandco]

I am making a master inventory sheet for my Real Estate Company. I have created 5 tabs to track the data for each department. The tabs are as follows:

• General Property Info
• Agent Action Items
• Accounting Action Items
• C2C Action Items
• 2011 Closed Files

I was able to create the following code to auto sort on the General Property info tab:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Range(("A6:j6"), Cells(Rows.Count, 1).End(xlUp)).Sort Key1:=Range("A7:j7"), Order1:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=True, Orientation:=xlTopToBottom
End Sub

This works great for the first tab, however although the other tabs populate the information on the general property information tab, the colums to the right of that info do not sort with the first tab.

Can anyone help? Am I explaining this well enough? lol

 

[FishingIsMoreFun]

By tabs do you mean sheets.
Maybe the other sheets cannot see the private sub.
You could try pointing at the

Worksheets("name").Range(("A6:j6"), Cells(Rows.Count, 1).End(xlUp)).Sort

 

[jrobertsandco]

Yes, sorry I meant sheets.

 

[FishingIsMoreFun]

Actually I am not really very familiar with this, however at a laymans guess the other sheets are not seeing the code.

Since there are only five sheets add the code to every sheet in the private sheet modules , Under Microsoft Excel Objects, in the Visual Basic Editor Project Explorer.

You code does not appear to have any reference to another sheet.

Maybe you have already done this but you have not specified.

cheers

 

[FishingIsMoreFun]

Ok just looking at the code

• You have the General info tab which has columns of data

• Your code uses the first column of data in the General info sheet and sorts that column alphabetically on data entry.

• The rows to the right of that column are sorted according to the first column, so you are sorting multiple columns based on one column's data.

I have placed the code in the every sheet object under the Project Explorer in VBE (In every sheet, which would be the five you mentioned). Or click on sheet tab go >"view code"

It works fine if you do this.

Or are you wanting the data on 4 sheets to be sorted based on the sorting of the general info sheet?

In other words you want the sorting to work across the 5 sheets relative to the first sorted row in General info?