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" <arthursdomain@gmail.com> wrote in message
news:1144961614.818507.3140@i40g2000cwc.googlegroups.com...
> 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.
>

[Z]

thank you for the quick response, looks real good

Thank you