Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Thanks ITWare for replying. Your answer works too. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thr

Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Hi Chih Hung, You will need three files to achieve the goal you pretend. File 1 - Origem. This will be the file you got every 2 week with your source data. File 2 - Modelo. This is the file where you will paste data from file Origem. File 2 - Controlador. This is the file where resides the vba co

Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Your request should be File, it is best to have one sheet to copy. 2013/9/10 Chih Hung Choo > > > Hi, I'm hoping to get some help here to automate the work that I have to > do every 2 weeks. The work is repetitive and hopefully a VBA script will > help shorten sometimes a day's work to minutes

$$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Hi, I'm hoping to get some help here to automate the work that I have to do every 2 weeks. The work is repetitive and hopefully a VBA script will help shorten sometimes a day's work to minutes. I'm using Excel 2007. There are 2 files. File A: This file is generated every 2 weeks. The data I