![]() |
|
|
|
#1
|
|||
|
|||
|
Regarding the data validation and the drop owns, the way I had it set up is it refers to a range specified in typical Excel RC format e.g. A2:A20. A more robust way is to refer to a named range. I have done that on the file attached (see a few posts down) and also included a list for Investigators. I will attach the file after I respond to everything here. To add new list items, there are a few ways to do it: * See that little doohickey on the bottom right of each list table? Grab it and drag it down. * Select a cell or a group of cells, right click, and select Insert: Table Rows above. The number of rows inserted will be the number of cells selected. * Once you have added your new items, sort the table. * Don't leave blanks or they will appear in the list. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Excel, transfer data from Master Sheet to sub sheets, using key word from column
|
anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
| Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
Need help in automating data from multiple sheets into a single sheet
|
veedee | Excel | 1 | 06-11-2014 04:01 AM |
| Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
How do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |