Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chance
 
Posts: n/a
Default Assigning names to a spreadsheet that updates

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,
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chance" wrote ..
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,



  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm




  #4   Report Post  
Chance
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I lock column and row names on spreadsheet Cheryl D Excel Worksheet Functions 2 March 23rd 05 05:01 PM
creating spreadsheet with colunms for names adresses & zipcodes neilabu Excel Discussion (Misc queries) 4 March 4th 05 01:53 AM
Ok i have a spreadsheet with names Help me with this spreadsheet assignment Excel Discussion (Misc queries) 1 January 5th 05 10:46 PM
How do I create spreadsheet that automatically updates numbers/va. bunyip Excel Discussion (Misc queries) 2 December 8th 04 12:54 PM
HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS. Allen Wright Excel Worksheet Functions 1 November 5th 04 04:45 PM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"