Question Details

[solution] » I need a VBA loop. I have an excel file name book located

Brief item decscription

Step-by-step solution file


Item details:

I need a VBA loop. I have an excel file name book located
More:

I need a VBA loop.

 I have an excel file name book located C:Users DesktopTESTbook.xlsm  in which I would like to copy data from another workbook located in another folder D:Users DesktopTESTMaster. This master folder has 5 different excel files 01a.xls, 05a_bla.xls, 10a_PTD.xls, 34a_RFT.xls, and 17 _MKV.xls. In each files has 31 tabs that which represents each day of the month. I would like to copy each of the file(day1, day 2,day 3?.day 31)Tabs and paste them to book.xlsm which the first tab in book.xlsm one must match the name of the file I?m copying from (01a ) etc.  

Master

End Result should look like this


I need a VBA loop.

 

I have an excel file name book located C:Users DesktopTESTook.xlsm in which I would like to copy

 

data from another workbook located in another folder D:Users DesktopTESTMaster. This master

 

folder has 5 different excel files 01a.xls, 05a_bla.xls, 10a_PTD.xls, 34a_RFT.xls, and 17 _MKV.xls. In each

 

files has 31 tabs that which represents each day of the month. I would like to copy each of the file(day1,

 

day 2,day 3?.day 31)Tabs and paste them to book.xlsm which the first tab in book.xlsm one must match

 

the name of the file I?m copying from (01a ) etc.

 

Master

 


 

End Result should look like this

 


 

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Feb 21, 2020

PRICE: $24

Solution~000950034.zip (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now