Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
I would like to create a list of items with approximately 7 columns that
would be used by 3 other worksheets in the same workbook. The problem I have it that the items in the list are deleted on occasion and other items are added. When a row is deleted, the rows in the three other worksheets no longer link correctly to the list. Also, there could be anywhere from 10 to 15 rows of data. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
Have a look at the INDIRECT function - this might help you. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=562189 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List
That is exactly what I needed.
Thanks for the help. "mrice" wrote: Have a look at the INDIRECT function - this might help you. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=562189 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
data validation--multiple dependent list | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |