auto copy data from one sheet to another within a workbook

[nelsonsdavis]

Hello Team, I'm a casual user of Excel and need some expert advice.

I have one workbook. I have multiple sheets within that book. This concerns 2 of the sheets.

sheet #1 contains client data. Sheet #2 contains 3 rows of that same client data.

I've linked the three rows of data I am interested in, to sheet 2. All is well. When I change anything in the data in the 3 columns in sheet #1, it changes in sheet #2.

Now, I want to add new clients to sheet #1 (add a row of data). I see that these new rows are NOT showing up in sheet #2.

How do I set this up so when I add a new row of data in sheet #1, it automatically shows up in Sheet #2?

And there you have it.

Thanks,
Nelson Davis

Nelson Davis, Client Development Director
AIP New York Co., LTD.
1001 Ave of the Americas, Suite 1212
New York, NY 10018
Nelson.davis@aip-global.com
212.719.7529 Office
917.975.0357 Office Mobile
914.396.3662 Personal Mobile

THE BEST ONLINE PANELS IN ASIA, no kidding - just ask anyone!
Proprietary panel coverage - Japan, China, Korea, Taiwan, Hong Kong, Singapore,
Thailand, Malaysia, Indonesia, Vietnam, India and The Philippines.

Offices in - NEW YORK | Tokyo | Shanghai | Seoul | London | Hong Kong |
Always send your feasibility & cost requests to - "aip-sales@aip-global.com" and cc "nelson.davis@aip-global.com"