softman
03-04-2011, 11:37 PM
Please can someone urgent help me with VBA code to sort and copy data from one sheet to another?
I have a "Master" sheet and need to sort and copy it into another 16 sheets.
The 16 sheets data is sorted and copied from the Colum "Division" (B) and "Region" (A).
Attached is a sample with all data already copied into the correct sheets?
For example:
The Master sheet is sorted by Colum B (Division) and then only the sorted data "KKS" in Colum B is copied to the KKS sheet.
The KKS sheet is then sorted by Colum A (Region) and then copied to 5 different sheets (Regions) for example all KKS GNT, KSS FS, KSS KZN etc. to each own sheet (Region).
This is for the first 6 sheets.
Sheet 7 takes all the sorted data in the Master sheet Colum B (Division) for ESS and the copied to the ESS sheet.
The rest of the sheets work the same way as sheet 1 -7.
I have a "Master" sheet and need to sort and copy it into another 16 sheets.
The 16 sheets data is sorted and copied from the Colum "Division" (B) and "Region" (A).
Attached is a sample with all data already copied into the correct sheets?
For example:
The Master sheet is sorted by Colum B (Division) and then only the sorted data "KKS" in Colum B is copied to the KKS sheet.
The KKS sheet is then sorted by Colum A (Region) and then copied to 5 different sheets (Regions) for example all KKS GNT, KSS FS, KSS KZN etc. to each own sheet (Region).
This is for the first 6 sheets.
Sheet 7 takes all the sorted data in the Master sheet Colum B (Division) for ESS and the copied to the ESS sheet.
The rest of the sheets work the same way as sheet 1 -7.