Replicate Data Between Worksheets

[Cuperman007]

Any one know of a clean way to replicate data between worksheets?

For example, I have a bunch of data in a Staff List (a "proper" list)

Worksheet1
Id Name Gender DOB
1 Mark M 21/10/1982
2 Amy F 16/10/1980

I want to repeat the data from the first two columns on various other
worksheets to capture additional information:

Worksheet 2
Id Name Favourite Color Favourite Superhero
1 Mark Cyan Superman
2 Amy Blonde Batman

Worksheet 3
Id Name Do you? Score
1 Mark No 2
2 Amy Yes 4

I don't want to use straight forward Worksheet!Cell references, as
this won't pick up new entries in my Staff List. I can write a macro,
but want to avoid that if there is a solution that will allow my "non-
programmer" collegues to work with this too.

Many thanks
Mark

 

[RAGdyer]

Why do you say that a "straight" cell reference to Sheet1 will *not* pick up
new entries?

You can copy something like this down hundreds of rows in your additional
WSs, and the data will display as you enter new staff names and numbers in
your main list on Sheet1:

=IF(Sheet1!A1<>"",Sheet1!A1,"") ... =IF(Sheet1!B1<>"",Sheet1!B1,"")

Or am I not understanding your question?

 

[Cuperman007]

Thanks for taking the time to reply.

A straight cell reference would require me to guess how many staff
members i am likely to want to add (No doubt I'll always be one
short!! ;-))

This direct method would also then make things like aggregation of
data on a summary row more difficult. Also this approah would bloat a
workbook file size.

All things I'm trying to avoid by using a magic built in formula ;-)

Best,
Mark