![]() ![]()
There’s a bit of setup involved – in re-designing your Word document/template, and in structuring your Excel data. This article focuses on a set of tools that can be used to configure Word and Excel to help you get more out of Office by more quickly and accurately updating Word documents with Excel data. In fact, we have less time these days, for analysis and real business thinking, because we have to do more and more administrative tasks to either get our jobs done, please the boss, or both. When we finally get the data side of the equation in order (generally, in Excel), we still have to tediously enter data in Word – sometimes reading off Excel and typing in Word, and sometimes copying and pasting. Sound familiar? I don’t know about you, but each of these demands sounds like they could be full-blown IT applications, and yet we’re stuck holding the bag, manually delivering these results, day in and day out. #Excel for mac auto enter list items updateThere are many approaches you could take to building an autocomplete routine using data retreived via ODBC from the data source.You have an impressive, massive Word document that is used as a template to report company performance, each month, and you have to pull together 50 Excel data-points and 5 charts, then update the Word document in key places, saving and distributing the document by email, within 24 hours of “business close” for the prior month. If you are willing to have the data in one workbook, and put the the worksheet on which data validation is needed into its own workbook, you could use ODBC via a parameter query to validate the input. I did a quick search but could not verify my suspicion. ![]() My memory says that it's limited to 5,000 rows, so your data may not be able to be displayed by this control. However, an overriding concern is the maximum number of rows that are suppored by the combo-list edit control. If you prefer, you could use a UserForm control instead of the dialog, but there's no combo list edit control in Userforms, so you would need to do a workaround. You would need to trap an event (double-click a cell, for example) to trigger the dialog. First, the combo-list edit control is available only on dialog sheets (Insert > Sheet > Dialog Sheet). #Excel for mac auto enter list items how toI think if you hunt around you can find examples of how to make a combo-list edit control work using autocomplete. There are various form controls available. Solutions you find should work as is or with minor tweaking provided the solutions do not rely on Active-X controls, which are not supported on the Mac and won't be until someone ports them (they're open source). The search I did was: įirst, VBA is supported in Excel 2011. I might be wrong, and I am about to test some of the solutions provided. From past experience, I recall VBA solutions will not work on Mac. I did find many discussions about this functionality, but as far as I can tell the answers all related to using VBA on Excel for Windows. What I'd like to know is if there is any way to convert the validation list into some kind of complete-as-you-type drop-down list? With many thousands of entries, it is very tedious to search through the list for each entry. ![]() What I was mistakenly anticipating is that as I start typing "av" (for example) the list will drill down to the "AVL - Another One" entry. In a cell I have that list set as a Validation list. What I was expecting is that when I set up those lists as validation lists for cell input, I would be able to just start typing and the list would move to any valid entries. I have lists with in excess of 10,000 entries. #Excel for mac auto enter list items proso I am hoping an Excel pro can prove otherwise. I found nothing, so I am thinking it's not possible. I've looked high and low for a solution to this. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |