Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Table
Please, Excuse my poor English. What is Dynamic Table? What is her (his) utility? How can I make one Dynamic Table? THANK YOU. -- kaokao1 ------------------------------------------------------------------------ kaokao1's Profile: http://www.excelforum.com/member.php...o&userid=35005 View this thread: http://www.excelforum.com/showthread...hreadid=547813 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Table
If you mean a Dynamic Range Name.... That refers to a Named Range that automatically resizes to reflect changes in the number of items in the range. A common use of a Dynamic Range Name (DNR) is to use one as the basis for Data Validation. When items are added/removed from the list, the DNR grows/shrinks to reflect the changes so the validation list always shows the complete list and won't show extra blank rows. For instructions on how to create a DRN, see Debral Dalgleish's website: http://www.contextures.com/xlNames01.html#Dynamic Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=547813 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Table
Ron, thank you very much. If you want to see in the Excel Menu In spanish: Datos Informe de tablas y graficos dinamicos Tabla Dinamica In english, I guess: DataTabs and Dynamic graphics Dinamic Tabs Thank you. -- kaokao1 ------------------------------------------------------------------------ kaokao1's Profile: http://www.excelforum.com/member.php...o&userid=35005 View this thread: http://www.excelforum.com/showthread...hreadid=547813 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Table
I use Excel 2002. I don't have those options on my menus. Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=547813 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Table
Ron: When I can find knowledge about Dynamic Tables (Tablas de Dinámica de Datos), I will send a message to you. *I know that is one of the strongest tools of Excel.*They let us manage one data table in order to view all data in many diferent presentations. I hope we can talk again very soon. Thanks.:) -- kaokao1 ------------------------------------------------------------------------ kaokao1's Profile: http://www.excelforum.com/member.php...o&userid=35005 View this thread: http://www.excelforum.com/showthread...hreadid=547813 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
vlookup data in a dynamic pivot table? | Excel Worksheet Functions | |||
pivot table with dynamic base data | Charts and Charting in Excel | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |