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

2013-09-13 Thread Vandalo
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

Re: $$Excel-Macros$$ need help

2013-09-02 Thread Vandalo
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 koul.ash...@gmail.com can u

Re: $$Excel-Macros$$ Help needed in Excel

2013-09-02 Thread Vandalo
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 pankajdhamij...@gmail.com Thanx for your great help. Only one issue - I