VBA to split column values as new workbook along with hidding sheets

manilara

New member
Joined
Nov 5, 2011
Messages
10
Reaction score
0
Points
0
Location
sydney
Excel Version(s)
2019
Dear VBA experts

I want you solve the task with your experiences

i have master workbook contains master sheet in column A:A have some values needs to split unique repeats of column along with hide sheets of master workbook (EAST,WEST,NORTH,SOUTH)

RESULT IF Symmetrix data is 100 it has to split along with sheets(EAST,WEST,NORTH,SOUTH)

please find the attachment of three workbook
1st workbook is MASTER
2nd & 3rd is output file which is requirement of result.....................


thanks alot
 

Attachments

  • MASTER.xls
    142.2 KB · Views: 14
  • Symmetrix Computer Systems Pvt Ltd.xls
    42.9 KB · Views: 11
  • Bluecom InfoTech Pvt Ltd.xls
    43.3 KB · Views: 12
Back
Top