| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Base, copy information one sheet to another automatically | Excel Discussion (Misc queries) | |||
| Copy and paste cahrt to new sheet-update data automatically? | Charts and Charting in Excel | |||
| How do I automatically copy data from one sheet to another? | Excel Worksheet Functions | |||
| GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
| How do I copy a formula from one work sheet to another? | Excel Worksheet Functions | |||
Linear Mode
