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.

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Copying template from one worksheet to another 2
Copy a range data from 1 sheet to multiple selected sheets 1
Stop linked cells from changing when insert new row? 1
Excel VBA 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top