Lock Cells Together

[brihowe]

I'm working on a spreadsheet where half of a row is pulled from
database and the other half is entered manually.

I run into problems when I refresh the data pulled from the databas
and if a row has been entered or deleted, then the manual and dynami
portions become out of sync.

Is there any way to lock cells together so that if I refresh th
database and a row has been deleted or added, then the manually entere
data in the row moves up or down along with the corresponding data fro
the database?

Thanks in advance for any help

 

[Andy B]

Hi

I couldn't think of a way of doing this when it the same thing happened here
a couple of months ago. We thought of 2 ways round.: Either sort the data as
it comes in (ours was by date - so it was easy) which puts the newer stuff
at the end, or import the data into a separate sheet and use VLOOKUP to link
the two sheets (like a relational database)

Hope this helps.

 

[brihowe]

Thanks for the suggestions, but unfortunately neither of them will wor
in our particular situation.

Any other ideas