Hello AIceStL,
I'm not totally sure what you have in mind but here's something that may head you off in the right direction.
The data base you have could be split up into zones as you have mentioned with each zone having its own worksheet. In your "Master" data base, a "Zone" column could be added to indicate which post code should be allocated to that zone. Hence, once a customer's details are entered in a row, you select a Zone from a drop down in the last cell of the row (the Zone column).
Once all your data has been entered, a VBA code assigned to a button could separate each customer into their relevant zone and then that data transferred to the relevant zone worksheet. That code could be as follows:-
Option Explicit
Sub Test()
Dim wsM As Worksheet, wsV As Worksheet
Dim ar As Variant, i As Integer
Set wsM = Sheets("Master")
ar = [{"North","South","East","West";"North","South","East","West"}]
Application.ScreenUpdating = False
For i = 1 To UBound(ar, 2)
Set wsV = Sheets(ar(1, i))
wsV.UsedRange.Offset(1).ClearContents
With wsM.[A1].CurrentRegion
.AutoFilter 7, ar(2, i)
.Offset(1).EntireRow.Copy wsV.Range("A" & Rows.Count).End(xlUp)(2)
.AutoFilter
wsV.Columns.AutoFit
End With
Next i
Application.ScreenUpdating = True
MsgBox "All done!", vbExclamation
End Sub
I've attached a mock-up work book just to show you how it could work. Click on the "RUN" button to see it work.
The Zone column has a drop down in each cell created in Data Validation. You select the relevant Zone once you decide which Zone a post code ( Column F) belongs to.
Its a starting point for you and perhaps someone else on this forum may have other ideas to offer up.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks