Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I lock column and row names on spreadsheet | Excel Worksheet Functions | |||
creating spreadsheet with colunms for names adresses & zipcodes | Excel Discussion (Misc queries) | |||
Ok i have a spreadsheet with names | Excel Discussion (Misc queries) | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) | |||
HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS. | Excel Worksheet Functions |