looper to copy tabs of a data file into template and save as

Hello,

I was wondering if someone could help me out. The attached file is a template. I have another file running overnight that will generate a data file with over 100 tabs of different companies. I need the looper to copy one of the data tabs into the attached templates "detail" tab and then do a save as. Close the file and then copy the second tab from the data file into the attached template and do a save as and so on. In the end I should end up with a template for all 100+ tabs of data. Any suggestions would be much appreciated.

Here is the file with the tabs of data. What I want is to grab the first tab drop it into the attached template - Detail Tab and then do a file save as. Then grab the second tab and follow the same steps doing a save as and do this until i have gone through the 100+ tabs.

I am getting closer

Please Login or Register  to view this content.

I just need to change the parts labeled windows RETAXWEST2.xlsm and RET GGP TEMPLATETESTALAMOANA4 so that it isn't referencing a file name hardcoded in the code but a file name sitting in a cell so that it keeps opening a template and following the steps. It is working but it is breaking down after the file save as because Alamoana4 is no longer called that. The code should save it and close it and then go back an open the template and continue to the next tab.

it works great. only one issue that I failed to mention. I have two data files. One is a detail and the other is a summary. I need to copy the property's detail tab from the one data file and the summary tab from another data file into the one template before doing the save as and loop through after the macro completes pasting in the two tabs. Sorry I didn't mention this before. The detail tab is also attached. I had to trim the size down on the number of tabs so I could load it. I need it to somehow match the data tabs from the summary and detail file so it copies the right ones into the template. I used a macro to name the files so they should be the same naming on both data files. Is that an easy change?

i modified your code a little to account for the two data files and it isn't working. Did I do something wrong?

Please Login or Register  to view this content.

I'm afraid I do not understand your request. The only thing that is clear that there are two data files to take data from. All the rest is unclear.

It is the same code that you gave me except i duplicated the copy of data so that I can get it to copy the summary data from one file into the template and then copy the detail data from a second file into the template. Then do the save as. Set Data_wkb2 = Workbooks("RETAXWEST2.xlsm") is where I started to duplicate the data you gave me so that it can perform the second part of copying in data.

I did not mean the code in post #6. I do not understand the process and can not make a judgement for the code of yours.

It's not clear what goes from where and what is the final result expected. I need a sample with explanations what and why has happened to get required result.

Sorry. So another department runs the data files for me. One file is a Detail Financial Statement and the other is a Summary. The tabs are labeled the same in both and are in alphabetical order in both using code I put together to name and sort the files once I get them. I have a template file that I need to create for each company. I need the code to take the template file and copy in the first tab on the summary data file (RETAX_Summary) and paste it into the template. Then copy the first tab on the detail data file (RETAXWEST2) and paste it into the template. Then do a file save as to finish that company's template. Then I need it to complete the same process until it has gone through every tab in both files. The number of tabs in each file should equal. The original code you created worked fast and was awesome. I thought I could just change it up a little by making it go and get the info out of the second data file. Example: Kickoff the code and it copies the AlaMoanaTP tab from the summary file onto the summary tab of the template then grab the AlaMoanaTP tab from the detail file onto the detail tab of the template and save as. Repeat this over and over. The tabs are in the same order on both data sets so I shouldn't have to worry about it copying in the wrong tab if it is working from the first tab to the last in both data files. Thanks for you expertise. You have been very helpful.

Questions:
1. What should happen if either file is missing?
2. If both files present but the same name sheet is missing in the other book?

The files can't be missing. We can't complete the template without both files. I have to test the two files to make sure no tabs are missing otherwise data has to be regenerated

option, run code test in template file. All three files should be located in the same folder

PS. I'm off so this goes without question answers being got

your the bomb.