Add a row,incase of any updates

Closed
diva - Dec 16, 2008 at 04:59 AM
sunfreaks Posts 9 Registration date Saturday September 13, 2008 Status Member Last seen April 16, 2009 - Dec 16, 2008 at 05:47 AM
Hello,
I have to sheets, sheet1& sheet2 in my excel.
both the sheet has the similar kind of cells
I have to add a new row in sheet2, whenever any updates happen in sheet1

Could anyone give me a solution?

1 response

sunfreaks Posts 9 Registration date Saturday September 13, 2008 Status Member Last seen April 16, 2009 2
Dec 16, 2008 at 05:47 AM
You should hence write the cell addresses instead of having to shift the contents. Letâ??s take your example:
If you want to shift the contents of cell X1 from your Sheet 1 to Sheet 2, then in Sheet 2, you should write

Sheet1!X1

To be able to have the exact same contents updated from Sheet 1 to Sheet 2.
Hope it has helped you buddy.
0