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.
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.