i HAVE A PROBLEM IN EXCEL.tHIS IS EXPLAINED AS BELOW--
I am entering cite details into my sheet.When i enter a cite details in main sheet,that cite details(total row) should transfer from this main sheet to that particular linked cite sheet.
So can any one solve this problem for me.
needs more details.anyhow what you need is an event handler or event code
if you right click the main sheet tab and click view code you get that sheet code.
if the left hand side arrow choose worksheet. on the right window arrow choose "change"
in that your write the code some thing like this
Private Sub Worksheet_Change(ByVal Target As Range)
this has to be tweaked somewhat for that more details or a small extract of your main sheet is required. anyhow I am sure you can work on the above suggestion.