copy cell from one worksheet to another worksheet in exel

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

Guest

I know how to get the cell from one worksheet to another but when I insert a
row the inserted row will not go to the new worksheet
 
luvs_choc8 said:
I know how to get the cell from one worksheet to another but when I insert a
row the inserted row will not go to the new worksheet
Click to expand...

Here's one play to try ..

In Sheet2,
Instead of using simple link formulas in A1, eg: =Sheet1!A1
with A1 then copied across / down

Put instead in A1:
=IF(OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1))

Then just copy A1 across / down as required. This returns the same kind of
links as the former but with the added flexibility that any new row
insertions in Sheet1 (within the linked area) will now be reflected in
Sheet2. Test it out and see for yourself.

---
 
Back
Top