Hi All,
i have a excel file: Column A: Sr no, Column B: Location name (India, China, Pakistan,Singapore etc ), Column C: Property ID..etc..
Total 2000 rows with 18 locations,
Requirement: 18 different files for different different locations.
Current procedure: Doing filter and cut paste to different file.
Required procedure: Macro or something.
Please help me on this.. (File attached)
Prem
Bookmarks