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$$ Help needed in Excel

Hi Pankaj, On column C you could write the following formula =trim(a1)& " " &trim(b1) You will have no leading or trailing spaces when paste the content of column C in the Notepad for instance. HTH, OS 2013/8/14 Pankaj > Thanx for your great help. Only one issue - I was able to merge the >

Re: $$Excel-Macros$$ need help

Hi Thameem, Suppose you have the total for everyone of the 40 sheets on cell B100. The following formula would sum every total of the 40 sheets you have. I guess this is what you want. =SUM(Plan2!B100;Plan3!B100;Plan4!B100) Best regards. OS 2013/8/12 ashish koul > can u share the sample fil