how can i get a sheet to copy a different sheet so when the original sheet
changes, the new sheet changes as well. i tried using = but then a zero is
placed in the cell if the original has nothing in it. i want a zero to show
if it is indeed a zero, but nothing to show if the original is blank.

the jist of what i am trying to do is:
Sheet 1: lists all data (A,B,C &D) and summation
Sheet 2: i want to list only data for A & B- including all the same detail
as the original. but now the summations will be different- A+B or B+D.... but
each of these groups are lists of data/values that could change or be added
to. but i dont want to insert a new row on each sheet-

as i write this is sounds stupid and not making much sense. any and all
suggestions are appreciated- this might be a job for access????

thanks

in doing this, i want my copied sheet to change as things change in the
original- ie inserting rows, columns....

In Sheet2,

Put in A1:
=IF(OFFSET(Sheet1!$A$1,ROWS($1:1)-1,COLUMNS($A:A)-1)="","",OFFSET(Sheet1!$A$1,ROWS($1:1)-1,COLUMNS($A:A)-1))
Copy across/fill down to cover the max expected extent of data in Sheet1,
inclusive any future inserted rows/columns
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"EWalters" wrote:
how can i get a sheet to copy a different sheet so when the original sheet
changes, the new sheet changes as well. i tried using = but then a zero is
placed in the cell if the original has nothing in it. i want a zero to show
if it is indeed a zero, but nothing to show if the original is blank.

the jist of what i am trying to do is:
Sheet 1: lists all data (A,B,C &D) and summation
Sheet 2: i want to list only data for A & B- including all the same detail
as the original. but now the summations will be different- A+B or B+D.... but
each of these groups are lists of data/values that could change or be added
to. but i dont want to insert a new row on each sheet-

as i write this is sounds stupid and not making much sense. any and all
suggestions are appreciated- this might be a job for access????

thanks

in doing this, i want my copied sheet to change as things change in the
original- ie inserting rows, columns....