Hello all, Im trying to get Excel to grab data from a specific cell on an
external spreadsheet through a pastlink and populate that data to 2nd
spreadsheet that will be tag as a read-only document (for view purposes
only). The data in the first sheet will change when new lines are inserted
above or are placed at the original cell location.

example: First spreadsheet cell A5 has the number 5 in it, that data is
pastelinked to a second (read only) spreadsheet where it is displayed. Now at
row A4 I insert 4 new rows to allow room for the new data that will be copied
here. The new data in the same A5 cell is 10 and needs to display 10 on the
second spreadsheet.

How do I stop excel from following the first A5 and populating that data on
the second external spreadsheet. I only want it too give me the data that
will be in the A5 cell even after the lines are inserted above. I have tried
using the =$A$5 but when the lines are adding the cell that carries the
formula adjust to the new lines add and the calculated cell reads =$A$9. So
is there away to lock-in on a specified cell and it not adjust to the new
inserted lines.

Thanks

In need of help

Use the INDIRECT function:

=INDIRECT("A5")

Hope this helps,

Hutch

"*Kenneth*" wrote:

Hello all, Im trying to get Excel to grab data from a specific cell on an
external spreadsheet through a pastlink and populate that data to 2nd
spreadsheet that will be tag as a read-only document (for view purposes
only). The data in the first sheet will change when new lines are inserted
above or are placed at the original cell location.

example: First spreadsheet cell A5 has the number 5 in it, that data is
pastelinked to a second (read only) spreadsheet where it is displayed. Now at
row A4 I insert 4 new rows to allow room for the new data that will be copied
here. The new data in the same A5 cell is 10 and needs to display 10 on the
second spreadsheet.

How do I stop excel from following the first A5 and populating that data on
the second external spreadsheet. I only want it too give me the data that
will be in the A5 cell even after the lines are inserted above. I have tried
using the =$A$5 but when the lines are adding the cell that carries the
formula adjust to the new lines add and the calculated cell reads =$A$9. So
is there away to lock-in on a specified cell and it not adjust to the new
inserted lines.

Thanks

In need of help

Where would the INDIRECT function go in the following syntex string:
='U:\IT Documents\[W D Manor - Tracking Log For Copiers.xls]44171 - FONT
LOBBY'!$D$4

I'm trying to grab the data from a cell in an external spreadsheet, where
rows inserted above the ='U:\IT Documents\[W D Manor - Tracking Log For
Copiers.xls]44171 - FONT LOBBY'!$D$4 cell of the external spreadsheet in
paste in the new data. The inserting of the rows is changing the cell value
by the number of rows inserted.

For Example; if I insert 4 rows above the D4 cell of the external
spreadsheet the cell looking at D4 now reads D8 and I what it to lock in on
the D4 cell all the time. Is there a was to have it always lock-on to the D4
cell and not change even if rows are inserted above it.


"Tom Hutchins" wrote:

Use the INDIRECT function:

=INDIRECT("A5")

Hope this helps,

Hutch

"*Kenneth*" wrote:

Hello all, Im trying to get Excel to grab data from a specific cell on an
external spreadsheet through a pastlink and populate that data to 2nd
spreadsheet that will be tag as a read-only document (for view purposes
only). The data in the first sheet will change when new lines are inserted
above or are placed at the original cell location.

example: First spreadsheet cell A5 has the number 5 in it, that data is
pastelinked to a second (read only) spreadsheet where it is displayed. Now at
row A4 I insert 4 new rows to allow room for the new data that will be copied
here. The new data in the same A5 cell is 10 and needs to display 10 on the
second spreadsheet.

How do I stop excel from following the first A5 and populating that data on
the second external spreadsheet. I only want it too give me the data that
will be in the A5 cell even after the lines are inserted above. I have tried
using the =$A$5 but when the lines are adding the cell that carries the
formula adjust to the new lines add and the calculated cell reads =$A$9. So
is there away to lock-in on a specified cell and it not adjust to the new
inserted lines.

Thanks

In need of help