View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.links
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Adding Row in Linked Data

Apologies, I had mis-read earlier ..

It's simpler if it's just between sheets in the same book

In Sheet2,

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

Use 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
---
"holmesoz" wrote in message
...
I am a bit confused - I linked the data using Copy, Paste & then chosing
Link
Cells under Paste Options. When I click on a cell on the Linked Data
sheet,
the cell reference is "Activity!A1", and so on for each cell. I did not
use
a formula.

The linked data is all in the same Book - just linked between two Sheets.