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
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
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