Sheet Link

[pigpox]

Good afternoon everyone,
i have two excel workbooks one is an input and the other is a display sheets (its on a screen always on) these two workbooks are always connected via get data from workbook.

the "display workbook" receives the information into Sheet2 like so (see image)



i want to transfer the data from Sheet2 to the Display sheet in the same workbook that looks like this.



the problem is the cells their is sooooooo many i stated using

=Sheet1!A2

but its painful lol is there is simple solution to this? something like how you highlight information on a chart .

Thanks

 

[ravishankar]

copy your data in sheet1 > sheet2 choose pastespecial > click transpose > say OK. if you want excel to do on its own, an event trigger may be used.
Ravi shankar