Copy data from 1 work sheet to another automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Why not just use a simpler formula?
=Sheet2!A1

Max said:
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.
Click to expand...
 
Stephen said:
Why not just use a simpler formula?
=Sheet2!A1
Click to expand...

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?

---
 
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.
 
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
 
Back
Top