I build a workbook with 10 worksheets. Worksheets
contained a lot data. I linked all worksheets to my summary. On those
worksheets there are column summorize one year capital which linked all
to my summary. Now I have no idea how can i write a macro creating one
cell on summary which will commend(change) data on my capital column if
I want to reflect 2 or 3 years capital. The changes has to be made at
same column.