Discussion Locked

how to break one excel file in to many excel files

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

for eg

I have an excel file which contains data from all the cities.Now what i want is each city data should be exported in to independent new file with the name of the city as file name

1 reply

by sehul.bhatt

HI.
I DONT KNOW EXACTLY HOW ITS DONE.BUT I CAN GUIDE YOU.IF YOU KNOW VB-MACRO CODE,YOU CAN EXPORT INDIVIDUAL SHEETS AS FILE TO NEW SHEET.
USE MACRO HELP TO GET COMMAND LIKE--
WORKBOOK.WORKSHEET()

This discussion is closed to new replies.