User Profile
prprewitt
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: input from drop down list
Twifoo Thanks, the formula you gave me in your 1st reply works great. By the way, you need another ) at the end for it to work. Still does not update the list when you add new items. It apparently does not re-count the lines when you add new items. Is there a way to re-calculate the formula automatically?2.5KViews0likes0CommentsRe: input from drop down list
Twifoo Thanks, I finally got it to work. If the worksheet is named 'List' and the data is in column A row 2-10, the formula in the source box is =List!$A$2:$A$10 Unfortunately, if I add new items to the list it is not updated (I have Excel 2007). Evidently this has been addresses in version 2010.2.5KViews0likes2CommentsRe: input from drop down list
Twifoo In order to experiment with Data Validation, I created a new workbook with a worksheet named 'DV' that contains a table with (3) column headings; DATE, TRANSACTION & NOTE. I added a 2nd worksheet named 'List' that contains a table with the heading 'LIST' and several sample transaction names. Both tables were created using 'Insert > Table...' I successfully created a dynamic list named 'DLIST'. When I type =DLIST in the source box I get a 'Source evaluates to an error...'. If I type =List!DLIST (I am thinking that it could not find the worksheet with the DLIST) then I get a 'Cannot reference other worksheet...' error.2.5KViews0likes5CommentsRe: input from drop down list
Twifoo Thanks again for your help. As I go through the steps to add the drop down list using data validation, it will not let me go to the sheet where the list is. Also, where do I input the formula you gave me earlier? I have made many careful attempts with no success.2.5KViews0likes7Commentsinput from drop down list
I created a check register table that I would like to select the transaction name from a drop down list that uses a table from a separate sheet. I have looked at combo and list box - not what I wanted. Then tried Data Validation - did not work but closer to what I was looking for. I also use this workbook to track my credit card transactions and would like to use the same list table.3KViews0likes12Comments
Recent Blog Articles
No content to show