Referencing a range

[dm59]

Hello
Is it possible to display an entire range from another worksheet or workbook? For example, let's say ws #1 has 100 cells with data of whatever sort. I would like, in ws #2, to show the data from #1 and augment it with additional columns showing different info. WS #3 would reference the same range from #1 but add other additional info.

Possible? If so, how?

Thanks in advance.

 

[NBVC]

The simplest way is to just reference the cells in the other workbooks with a simple formula

=Sheet1!A1 copied down and across would pull the info from the corresponding cells in Sheet1.

Is this what you meant? If no, please elaborate.

 

[dm59]

Thanks NBVC. That's a nice, quick and easy way of doing it.