| |
| | MrExcel Message Board :: View topic - VBA>>>>>VBA>>>>>MACRO>>>!!!!!Please Help me!! |
 | | But now the problem is it only works for one sheet, it copies the sum of the K column into k42 cell of "sheet", but if i add another sheet, it replaces the old value of the k42 cell on sheet "sheet", which means i am loosing my old data from the previous sheet. |
 | | Now it upgrades the value to cell k42 of Sheet "Sheet", but if i add another sheet based on the same template, instead of adding the values from new sheet to the old value of the k42 cell, it overwrites the value of the new sheet to cell k42. |
 | | Lets suppose i have total value of 10,000 in k42 cell after the end of one sheet, once i add another sheet (sheet2 based on that template) and start puttind data that data should be added into 10,000(old value of k42) not to be replaced. |
| www.mrexcel.com /board2/viewtopic.php?t=13451 (1761 words) |
|