Copy from excel sheet and paste in new folder

[ajaybenjwal]

Hi,

I have a excel sheet with different branch in different sheet,How i can copy data from each sheet and paste it to new folder and create separate worksheet for each branch,using Vba?

 

[tzw1378]

Please clarify what you mean by branch? Admittedly, I don't follow this wording and if others also don't follow, you may have difficulty in receiving an answer.

 

[ajaybenjwal]

Please clarify what you mean by branch? Admittedly, I don't follow this wording and if others also don't follow, you may have difficulty in receiving an answer.

Thanks for your prompt reply,actually i meant by branches(city name) is different sheets of excel workbook.
I have 10 sheets in one workbook, I want to copy data from each sheet and paste that data separately in different workbook .

 

[tzw1378]

I'm sorry it's been some time. Basically, you could start with an Excel file where the data will be pasted. In this file, write code using

Application.msoDialog...

with a multiselect to grab a group of files, comb through them, grab the data you want and paste it appropriately.