Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Excel - Combine 2 Dynamic Ranges
- I have 2 different ranges that are from different columns. Does anyone know how to make 1 range that contains everything from those 2 ranges? I am trying to use data list validation on some cells where you can choose from either of those 2 ranges.Thanks
- Tags: keithabid@..., Microsoft Excel
- Discussion threads 2007-08-02
- Navigator Utilities (exe)
- A Microsoft Excel add-in for power users--navigate through sheets, links, named ranges, objects and search with advanced find/replace. Also easily Trace through cell dependents and precedents keeping track of where you've been so you cannot get lost. Large and complex spreadsheets are tamed with Navigator Utilities. Find hidden sheets and...
- Tags: Netscape Navigator, Web Browsers, Internet
- Software downloads 2008-01-02
- One macro for multiple sheets
- I have 6 identical worksheets, named Mon-Sat, with data in ranges A3:B150 and C3:C150How to I create a macro to erase the data in these ranges in all the sheets with a macro in the first Mon sheet?Thanks,Jak
- Tags: jjoy2ce@...
- Discussion threads 2007-05-15
- Excel 2007 -- Internal Hyperlink AutoUpdate
- Hello,Currently, I am using Microsoft Excel with a small menu at the top of the window. This little menu simply points to various bookmarks range names I have setup for the spreadsheet I have created. This is what I want to do:Create a macro that asks for the...
- Tags: PRODUCTIVITY, oldoak@..., Microsoft Excel 2007, spreadsheet, Microsoft Excel
- Discussion threads 2007-10-02
- Reduce permissions to increase DNS security
- Running named as named:namedAt least on RHEL (named:named) and Debian (bind:bind) this is the default behavior, no need to mod anything.
- Tags: Operating systems, OPEN SOURCE, sirconquer+TechRepublic@..., DNS
- Discussion threads 2007-08-02
- Problems with dynamic ranges and Indirect function in Excel
- I have been using dynamic ranges for sometime and also separately using the indirect function to reference static ranges. Now I am trying to combine the two and for some reason they will not function. When creating the list in data validation, excel brings up the message box "the source...
- Tags: jeffrey@..., Microsoft Excel
- Discussion threads 2007-06-18
- Use named ranges for absolute references in formulas
- There are a number of ways to design absolute references in formulas. For example, in an order form, you might use a Lookup function to determine the shipping charges from a shipping table, as shown here. If you use the cell range for...
- Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-06-10
- De-Mystifying the SAS Libname Engine in Microsoft Excel: A Practical Guide
- This paper is a "How-to" guide exploring the SAS v9 Excel libname engine. It focuses on the application of the Excel engine including an introduction and some suggestions on its use. The practical advantages and shortcomings of the engine are discussed. Readers will learn how to use the libname statement...
- Tags: SAS Institute, Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software
- White papers 2006-02-28
- Partitioned Tables and Indexes in SQL Server 2005
- SQL Server 2005 offers a way to easily and consistently manage large tables and indexes through partitioning, which allows you to manage subsets of your data outside of the active table. This provides simplified management, increased performance, and abstracted application logic, as the partitioning scheme is entirely transparent to the...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Table, Databases, Enterprise Software, Software, Data Management
- White papers 2005-01-01
- Rifle Target: Rifle Shooting Database (exe)
- Rifle Target: Rifle Shooting Database by Enfilade Studios is the premier solution for coaching and plotting a rifle shooting team of the 21st century. Rifle Target is the solution to the needs of a target rifle shooting team or to an individual shooter who wants to improve their performance. Rifle...
- Tags: Team, Database, Rifle, Rifle Target, Team Management, Management
- Software downloads 2007-03-08
- Use dynamic ranges to make your Excel spreadsheets easier to understand
- Give your numbers more distinct meanings in Excel with dynamic ranges. By using the OFFSET function and naming feature, you can give labels to your formulas, making them easier to find and reference. You can make Excel formulas easier to understand by using named ranges. For example, the...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, Sales force management, Excel spreadsheet, Click Add, sales, Total Sales, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
- Technical articles 2007-04-03
- Finding Nemo's Friends (exe)
- The screensaver Finding Nemo's Friends contains 22 high resolution images of Clownfish. Clownfish are native to wide ranges of the warm waters of the Pacific and Indian Oceans; some species ranges overlap others. Clownfish are not found in the Atlantic Ocean. Clownfish live in a mutual relationship with sea anemones,...
- Tags: RateMyScreensaver, Clownfish
- Software downloads 2008-01-28
- Overcome quirky C++ imperfections with these practical solutions
- C++ is an established and powerful programming language, but it isn't perfect. Over the years developers have come up with some creative ways to get around those imperfections. In this excerpt from Matthew Wilson's book, Imperfect C++: Practical Solutions for Real-Life Programming, some of the most common practical solutions regarding...
- Tags: excerpt, filter, Addison-Wesley, developer, syntax, C++, Matthew Wilson, Practical Solutions, programming language, Web, Web site, programming, Imperfect C++, Real-Life Programming
- Download resources 2005-05-04
- PDF Split Merge ActiveX (exe)
- Using ActiveX component to split and merge PDF Files in your programs. Support VB, VB.NET, C#, ASP, ASP.NET, PHP, ColdFusion, and Java. Merge multiple PDF files or selected pages from one or more files into a PDF file. Generate a new PDF file by merging one or more PDF documents....
- Tags: Adobe PDF, ActiveX
- Software downloads 2007-09-20
- MVPspc (exe)
- MVPspc is an easy-to-use SPC charting and analysis program. This program is extremely flexible, providing analysis not available in any other SPC package. The program uses simple text files, or you may copy and paste directly from a spread sheet. Control limits calculations can be generated numerous ways. For example,...
- Tags: Deviation, Range, MVPspc
- Software downloads 2007-12-20
- Excel Keyboard Command for Paste Options
- Is there a keyboard command which will open the Paste Options icon which appears when one pastes in Excel? I copy/paste tons of data from one workbook to another regularly, moving around using only keyboard commands, and find it very rough to continually have to reach for my mouse...
- Tags: ddb64, keyboard, Microsoft Excel, Options, Paste, Paste Options, software
- Q&A 2006-08-02
- Import calendar from excel to outlook
- I have information in an Excel document that I want to import into an Outlook calendar. Any idaes on how I can go about this? I am using Office XP. Here are the fields that the Excel doc have that should map to the Outlook calendar.Excel ...
- Tags: Microsoft Office, Microsoft Excel, Microsoft Outlook
- Q&A 2004-10-27
- ExcelLite (msi)
- Easily create, convert, write, and read from Microsoft Excel files. ExcelLite is a .NET component that provides elegant and high performance way to write and read from XLS files BIFF format or CSV files text format without the need for Microsoft Excel on either the developer or client machines. Version...
- Tags: High-performance, ExcelLite, Microsoft Excel, Leadership, .Net, Application Servers, Microsoft Office, Middleware, Office Suites, Software, Management, Software Development, Software/Web Development, Enterprise Software
- Software downloads 2006-01-12
- PDF Merge-Split (exe)
- PDF Merge/Split enables you to merge or split PDF files, and to edit some of the document properties. When merging, you may combine entire files or selected page ranges in any combination. This also enables you to rearrange or reverse the pages in a single PDF file. When splitting, you...
- Tags: Adobe PDF, PDF Merge/Split
- Software downloads 2006-08-31
- << Previous
- page 1 of 1
- Next >>
