Copy data from 1 work sheet to another automatically

[Guest]

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.

 

[Guest]

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.

 

[Stephen]

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

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.

 

[David Biddulph]

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

 

[Guest]

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

Because it's inferior to the classier:
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?

---

 

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

"copy and paste special as link"


--


Regards,


Peo Sjoblom