If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with assigning variable names | ad | General Discussion | 13 | October 8th, 2004 12:15 AM |
Excel spreadsheet column names | corsier | General Discussion | 1 | October 6th, 2004 08:13 PM |
Updating spreadsheets from another spreadsheet | Mitch | General Discussion | 1 | September 28th, 2004 04:50 PM |
Linked cells | Seaside Mark | General Discussion | 4 | September 28th, 2004 12:29 AM |
unsorted names and unique id's | Randall Senn | Worksheet Functions | 4 | June 4th, 2004 12:32 AM |