I want to connect two excel documents... such that any change in figures or updation in the first one refreshes the figures in the second one. Have to use macro code... but what and how?

Impossible to answer without seeing what you need.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your two workbooks... make sure it's clear what should be connected where.

I don't need to do that am trying to do the same stuff in access... need some modification in sql select code... how can I insert a new row in result dataset in query and in that dataset perform sum of a column of numeric such that its displayed in that new row created;query dataset created from a specific table?