It seams to work perfect on my test sheet.
What I don't get is why don't you just link the cells. Like in sheet2 A1

=IF('Sheet1'!A1=0, "" , 'Sheet1'A1)

"Natalie" wrote:

I have two different worksheets, they look something like this:

Sheet1:
Column A Column B Column C
Study #1 Company Name Company Study #
Study #2 Company Name Company Study #

Sheet2:
Column A Column B Column C
Study #1 Company Name Date Study #1 Report Received
Study #2 Company Name Date Study #2 Report Received

The first two columns of the 2nd worksheet have this formula, so that it
copies from Sheet1 and adds rows when added in Sheet1 as well:
=IF(OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1))

But when I enter rows in Sheet1, the entire row does not enter in Sheet2 and
I get this:

Column A Column B Column C
Date Study #1 Report Received
Study #1 Company Name Date Study #2 Report Received
Study #2 Company Name

So the info in Column C no longer matches up to columns A & B.

Is there any way to fix this so that the complete row is entered on Sheet2?

Thanks for any help!
Natalie

Because when I add a row in Sheet1 it doesn't carry over to sheet two...

"AKphidelt" wrote:

It seams to work perfect on my test sheet.
What I don't get is why don't you just link the cells. Like in sheet2 A1

=IF('Sheet1'!A1=0, "" , 'Sheet1'A1)

"Natalie" wrote:

I have two different worksheets, they look something like this:

Sheet1:
Column A Column B Column C
Study #1 Company Name Company Study #
Study #2 Company Name Company Study #

Sheet2:
Column A Column B Column C
Study #1 Company Name Date Study #1 Report Received
Study #2 Company Name Date Study #2 Report Received

The first two columns of the 2nd worksheet have this formula, so that it
copies from Sheet1 and adds rows when added in Sheet1 as well:
=IF(OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1))

But when I enter rows in Sheet1, the entire row does not enter in Sheet2 and
I get this:

Column A Column B Column C
Date Study #1 Report Received
Study #1 Company Name Date Study #2 Report Received
Study #2 Company Name

So the info in Column C no longer matches up to columns A & B.

Is there any way to fix this so that the complete row is entered on Sheet2?

Thanks for any help!
Natalie