0

Respected All, My question is below

I have a 50 Workbook in a folder and in every workbook there is a separate Sheet name Call "Data". here i would like to loop form multiple workbook throw loop and find seprate "Data" sheet name in the workbook if there is a sheet called "Data" then Copy that sheet and paste into the Master Work book. is it possible in in VBA if possible please guide me how to do this.

Community
  • 1
  • 1
Ajay
  • 23
  • 3
  • Welcome Ajay to SO. This is a Q&A site. So, short answer is Yes, it is possible to do what you want with VBA. You can research a bit on VBA tutorials and even SO itself to get started. For example, here https://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba or here https://stackoverflow.com/questions/20246465/how-to-copy-only-a-single-worksheet-to-another-workbook-using-vba Try them out and come back here if you have more questions. – PA. Jul 18 '17 at 09:51
  • Possible duplicate of [Loop through files in a folder using VBA?](https://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba) – PA. Jul 18 '17 at 09:53
  • what is the folder path? – mojo3340 Jul 18 '17 at 10:42
  • Hi @PA i have check this above all link but i am not able to find suitable answer i would like to find seprate sheet name in my 50 Workbook which name is Order i would like to find Order Sheet Name in all 50 Workbook if find then copy the data can you please help me Please – Ajay Jul 18 '17 at 10:59
  • Hi @user1, I have save in my local directory called C:\Data in this i have save around 50 Workbook and in all 50 workbook there is Order sheet name – Ajay Jul 18 '17 at 11:02
  • What kind of help you need? the linked SO questions contain possible solutions to your stated problems. Look at them, try them, and come back with a more precise question. – PA. Jul 18 '17 at 18:00
  • Hi @PA i have check link that you have mark but this is loop only file name i need to loop Tab name of 50 workbook can you please guide me how to loop throw tab name of 50 workbook – Ajay Jul 19 '17 at 03:19
  • Research yourself ! Just a quick check on SO gave me this... https://stackoverflow.com/questions/1591442/how-can-i-loop-through-a-subset-of-worksheets – PA. Jul 19 '17 at 06:21

0 Answers0