Excel doesn't do this kind of stuff very well.

You could try to create a macro that would do all the validation, but lots of
things could go wrong. (I wouldn't try it.)

In fact, I try to keep all my data in one location (worksheet). It makes
updating much easier. If I need to split it into pieces later, I'll do that
whenever I need to. But my updates will always be done in that first location.

If you think you'd want to try this kind of thing...

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

kiran wrote:

Hi All,
I have 3 xls ex: exl1, exl2 & exl3, any data entered in exl1 of column A
and data entered in exl2 of column D to be automatically added in column A of
exl3, kindly help pls........

TIA

--

Dave Peterson