Copy data from 1 work sheet to another automatically
 

I work with Excel 2000 and was wondering if there is a way of copying data
from one sheet to another so that any changed made will reflect onto the new
worksheets.
--
Thank you for reading my post. Hopefully you can answer my querie

Copy data from 1 work sheet to another automatically
 

In Sheet1,

You could place in A1:
=IF(Sheet2!A1="","",Sheet2!A1)
then copy across and fill down to cover the extent required
The formulated range will return the contents of Sheet2 to the extent covered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shazza" wrote:
I work with Excel 2000 and was wondering if there is a way of copying data
from one sheet to another so that any changed made will reflect onto the new
worksheets.
--
Thank you for reading my post. Hopefully you can answer my querie

Copy data from 1 work sheet to another automatically
 

Why not just use a simpler formula?
=Sheet2!A1

"Max" wrote in message
...
In Sheet1,

You could place in A1:
=IF(Sheet2!A1="","",Sheet2!A1)
then copy across and fill down to cover the extent required
The formulated range will return the contents of Sheet2 to the extent
covered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shazza" wrote:
I work with Excel 2000 and was wondering if there is a way of copying
data
from one sheet to another so that any changed made will reflect onto the
new
worksheets.
--
Thank you for reading my post. Hopefully you can answer my querie

Copy data from 1 work sheet to another automatically
 

Max presumably didn't want to display zero when Sheet2!A1 was blank?
--
David Biddulph

"Stephen" <none wrote in message
...
Why not just use a simpler formula?
=Sheet2!A1

"Max" wrote in message
...
In Sheet1,

You could place in A1:
=IF(Sheet2!A1="","",Sheet2!A1)
then copy across and fill down to cover the extent required
The formulated range will return the contents of Sheet2 to the extent
covered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shazza" wrote:
I work with Excel 2000 and was wondering if there is a way of copying
data
from one sheet to another so that any changed made will reflect onto the
new
worksheets.
--
Thank you for reading my post. Hopefully you can answer my querie

Copy data from 1 work sheet to another automatically
 

"Stephen" wrote:
Why not just use a simpler formula?
=Sheet2!A1

Because it's inferior to the classier:
=IF(Sheet2!A1="","",Sheet2!A1)

The simpler one will return ugly looking zeros for any blank cells in
Sheet2, while the classier one replicates it better by returning neat looking
"blanks" for any blank cells in Sheet2. It also pre-empts the possible
follow-through question by the OP on the extraneous zeros being returned. Why
not kill 2 birds with one arrow?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Copy data from 1 work sheet to another automatically
 

I think Max is right, it's more elegant. But Stephen is right too. Simpler
is better. I use the simple format, then I go to tools, options, and turn
off the show zero values.

"Max" wrote:

"Stephen" wrote:
Why not just use a simpler formula?
=Sheet2!A1

Because it's inferior to the classier:
=IF(Sheet2!A1="","",Sheet2!A1)

The simpler one will return ugly looking zeros for any blank cells in
Sheet2, while the classier one replicates it better by returning neat looking
"blanks" for any blank cells in Sheet2. It also pre-empts the possible
follow-through question by the OP on the extraneous zeros being returned. Why
not kill 2 birds with one arrow?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Copy data from 1 work sheet to another automatically
 

If simplicity is what you want why not just copy and special as link. Having
said that I would go for Max;s solution any day


--


Regards,


Peo Sjoblom



"Dwight N" wrote in message
...
I think Max is right, it's more elegant. But Stephen is right too.
Simpler
is better. I use the simple format, then I go to tools, options, and turn
off the show zero values.

"Max" wrote:

"Stephen" wrote:
Why not just use a simpler formula?
=Sheet2!A1

Because it's inferior to the classier:
=IF(Sheet2!A1="","",Sheet2!A1)

The simpler one will return ugly looking zeros for any blank cells in
Sheet2, while the classier one replicates it better by returning neat
looking
"blanks" for any blank cells in Sheet2. It also pre-empts the possible
follow-through question by the OP on the extraneous zeros being returned.
Why
not kill 2 birds with one arrow?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Copy data from 1 work sheet to another automatically
 

"copy and paste special as link"


--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
If simplicity is what you want why not just copy and special as link.
Having said that I would go for Max;s solution any day


--


Regards,


Peo Sjoblom



"Dwight N" wrote in message
...
I think Max is right, it's more elegant. But Stephen is right too.
Simpler
is better. I use the simple format, then I go to tools, options, and
turn
off the show zero values.

"Max" wrote:

"Stephen" wrote:
Why not just use a simpler formula?
=Sheet2!A1

Because it's inferior to the classier:
=IF(Sheet2!A1="","",Sheet2!A1)

The simpler one will return ugly looking zeros for any blank cells in
Sheet2, while the classier one replicates it better by returning neat
looking
"blanks" for any blank cells in Sheet2. It also pre-empts the possible
follow-through question by the OP on the extraneous zeros being
returned. Why
not kill 2 birds with one arrow?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---