Not without a lot of work to create a macro--and lots can be changed that would
be difficult to foresee (in my opinion).

I always try to keep my data in one location.

Basant wrote:

Can it be possible ?
In a two different excel file if i update one file other one update
automatic.with specify coloums

kindly guide me

--

Dave Peterson