Multiple Sheets in One Workbook Sheet?

[Z]

What would be the best method of putting whole sheets of data into one
main sheet?

for instance:
Workbook A1:Sheet 1 - has accounting numbers (that is regularly
updated)
Workbook A2:Sheet 1 - has scheduling hours (that is regularly updated)
Workbook A3:Sheet 1 - has products ordered and shipped (that is
regularly updated)

I want to put each of those sheets into one main sheet in a main
workbook mainly for read-only access that can be refreshed with the
data without any to much work (maybe just a refresh button push or
built in code refresh).

What I have tried is using connections (using Microsoft Office 12 Beta)
but these will go on computers with Microsoft Office XP. When I used
connections I was able to import 'most' of the data that I want.
However, you cant control what data comes and how its displayed. I
want control to the point where its a mirror copy of what is on
Workbook A1:Sheet 1. I also know of manually typing in the code to
pull data from a cell in another worksheet to an exisiting worksheet
and that will give a mirror of the data in the cell. I have A LOT of
cells to do and I really dont want to have to resort to that if
possible. Anyone can think of a better way than the ones that are
already expressed?

Thank you,
John Philips
Business Manager
Mid Pacific Transportation Co.

 

[Peo Sjobom]

You can copy the whole range, then do edit>paste special and select paste
link, that is equal to typing in

=Sheet2!A2

for instance

but you can do it in one fell swoop with multiple cells

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Z]

thank you for the quick response, looks real good

Thank you