copy cell from one worksheet to another worksheet in exel
 

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

copy cell from one worksheet to another worksheet in exel
 

"luvs_choc8" wrote:
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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---