Assigning names to a spreadsheet that updates

[Chance]

I have this issue with my spreadsheet.
I have a spreadsheet that I update via Refresh Data.
Before I refresh the data I have names assigned to a ROW. When I update the
data
I get more data added and the names are no longer assigned to the correct Row.

how do I go about keep those names assigned to the Row?

Thank you,

 

[David McRitchie]

I do not think you have defined your problem sufficiently; however,
please take a look at my page on use of OFFSET
http://www.mvps.org/dmcritchie/excel/excel.htm

If your problem is from inserting/deleting rows then that probably
would explain and solve your problem; otherwise, you will have
to provide an example of what you start with, what you do and
what you got, and of course what you thought you should get.

Or may be submit the question to ELIZA
http://www-ai.ijs.si/eliza/eliza.html starting with
I have this issue with my spreadsheet

 

[David McRitchie]

I see your question is really about defined names.

If I select row 5 and assign it a name of row5
the definition for my test is ='Sheet 24'!$5:$5
then insert rows before row5 the row will move down
and row 6 will be the named row5 and the definition
will be ='Sheet 24'!$6:$6
what do you want to happen and how are you actually
using defined names.

If for instance you wanted to use row 5 regardless
of any kind of insertion or deletions you could use
=SUM(INDIRECT("5:5"))

But for more specific information as to what you actually
want to do you would have to provide detail.

 

[Chance]

David,

Thank you for the quick response. I am not an Excel person at all, but I
will try.
I am connecting to a database where I get my information from. It populates
my cell with the information. The information is basically my groups tasks.
For me to keep track I would like to assign a person to that task. If I
update later again new task are added or deleted. First part is that when the
new task comes in the spreadsheet gets updated and the names get out of sync
to the task their were assign to. By that I mean if column 1 has all the
information and at the last row I put a name John then new data comes in John
is now assign to that task. His name does not follow the correct column.

The other part is when I update the data and the ticket is close John is now
link to the wrong column. I hope this makes more sense now.

Thanks again

Kenny