On GameSpot: TGS 2008: No More Heroes 2 announced
1 Resources for

main worksheet

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Dynamic Rpt_Worksheet Change Event
Currently, I have an Excel Spreadsheet that I plan to populate via a MS Query that "pulls" data from an Oracle Database (version 8.1.7). In essence, the spreadsheet is setup to provide a "dynamic" Variance Report that will be used to monitor underpaid customer accounts. The report will...
Tags: lacwill@..., main worksheet, MS Query, spreadsheet, windows, worksheet
Discussion threads 2004-12-31

Additional Resources

Vocabulary Worksheet Factory (exe)
Improve and reinforce the vocabulary skills of your students with challenging and motivating worksheet activities created with Vocabulary Worksheet Factory. With the ultimate in worksheet generation technology at your fingertips, the creation of lesson-enhancing support materials for the classroom will be a lot more enjoyable and a lot less work....
Tags: Microsoft Windows, Microsoft Windows Vista (Longhorn), Operating Systems, Software
Software downloads 2007-05-07
Excel 2000 - Using hyperlinks in IF statements from another worksheet
I have two worksheets. One has a cell with a validation list followed by a number of cells containing a table of contents list. The other worksheet has 2-4 tables of hyperlinks, which corresponds with the table of contents on the first worksheet. The user can select...
Tags: Microsoft Excel, irocu26, worksheet, Table B, cell, hyperlink, first worksheet, table of content
Discussion threads 2007-04-26
Excel: Formatting Worksheets
Creating a basic worksheet is only the first step toward mastering Excel. If one plans to print the worksheet, email it to colleagues, or show it off to friends, one needs to think about whether the worksheet is formatted in a viewer-friendly way. A careful use of color, shading, borders,...
Tags: O'Reilly Media Inc., Microsoft Excel, Microsoft Office, Office Suites, Software
Book chapters 2005-01-14
Insert Tab Name into a worksheet
Is there a way to insert the tab name of a worksheet into a cell in the worksheet itself as a function?See this article:http://www.xldynamic.com/source/xld.xlFAQ0002.htmlCheers.RW Poster rated this answer. This question was closed by the...
Tags: worksheet
Q&A 2004-12-30
How to transfer a hyperlink from the cell a lookup formula locates in Excel
I have a database in worksheet 2 in a Excel 2007 workbook. In worksheet 1, I have a combo box that lists the project numbers listed in the worksheet 2 database. As a person selects a project, several other cells in worksheet 1 are populated with the data, associated with...
Tags: Storage, Microsoft Office, dan.pelch@..., cell, database, hyperlink, lookup formula, Microsoft Excel
Discussion threads 2007-09-20
date formulas in excel
i have a cell in worksheet number 1 that has a starting date for the first invoice of 60 subsequent invoices. i need to know how to have the same cell in each invoice calculate the future date based on the sequence of the worksheet. i.e. worksheet #2 would be...
Tags: cell, invoice
Q&A 2005-08-19
Keep embedded charts off your worksheet printouts in Excel
You can print an embedded chart in Excel without its worksheet by simply selecting the chart and choosing File | Print or clicking the Print button, but did you know that you can print a worksheet separate from its embedded chart in Excel? Even if it's a large worksheet, Mary...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, worksheet, Microsoft Office Suite Excel Tips Newsletter, Chart, Office Suites, Software
Technical articles 2006-04-18
My Excel Plug Numbers (exe)
Many times, when you build your excel worksheet you base your model on plug numbers such as exchange rates, inventory values, and stock prices. Each time that you run your worksheet you plug new values of this plug numbers and analyze the results. My Excel Plug Numbers is an Excel...
Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
Software downloads 2006-09-26
Formating an Excel list
I'm using Excel 2003, I created a list on a separate worksheet, and named the list, then I used Data > validate to apply the list to a series of cells on a separate worksheet. I want to apply a color to the cells or fonts in my reference list...
Tags: Microsoft Office, rthomas@..., worksheet, Microsoft Excel
Discussion threads 2007-09-25
Change your Excel worksheet defaults to fit your working environment
Default Number of Pages in WorksheetAnother Default I change is the number of sheets or pages in a worksheet. Why open three worksheets when I normally only need one woksheet.1) Select Tools + Options2) Select General Tab.3) Change "Sheets in new Workbook:" setting to 1.4) Select OK button to save...
Tags: Change, default options, excel, Excel Worksheet, hardware, Microsoft Excel, microsoft office, SELECT, sysadmin-tzone
Discussion threads 2006-08-07
Search for worksheet name in Excel
I am trying to find a way to search for a particular worksheet name if the spreadsheet has many worksheets in the file. Is there a way to do it? I appreciate any help anybody can give me.Thanks!
Tags: Search, jamesa@..., software, Microsoft Excel
Q&A 2006-04-05
Excel Look Up
I want to take 2 worksheets and be able to insert information regarding specific cells from one to the other. 1 worksheet has our inventory items listed and the Quantities used in a given time - the other worksheet has all the inventory item descriptions and data but does...
Tags: dnelson@..., Microsoft Excel
Discussion threads 2007-03-28
Link to 2 diff worksheets same workbook
I need to create 2 hyperlinks for an intranet web page each of which will open to a different worksheet in the same Excel workbook. I have created labels for each of the A1 cells. So, worksheet 1's A1 is labeled "StepItUp" and worksheet 2's label for A1 is...
Tags: A1, C. Boyd, cell, Microsoft Excel, programming, workbook, worksheet
Q&A 2005-04-26
Function to comparing data on Separate Excel Worksheet tabs
Guys,I am trying to compare two sets of data held on separate excel worksheets. Worksheet 1 has UAT data, worksheet 2 has PROD data. I want to use an excel function to help verify the information held in both large worksheets tie up.I have been trying to use the...
Tags: lou1s@..., Microsoft Excel
Discussion threads 2007-03-20
Excel 2002 Add-in: Open Database Connectivity (EXE)
The Excel Add-in: Open Database Connectivity ODBC contains the SQL.REQUEST worksheet function, which can connect to an external database and return a query to the worksheet. The Excel 2002 Add-in: Open Database Connectivity ODBC contains the SQL.REQUEST worksheet function. The SQL.REQUEST worksheet function is used to link to an external...
Tags: ODBC, Microsoft Excel 2002, Microsoft Excel, Databases, Microsoft Office, Office Suites, Software, Enterprise Software, Data Management
Software downloads 2007-10-03
Workbook TOC (exe)
Workbook TOC is a table of contents generator for a Microsoft Excel workbook. This Excel Add-on will create a new worksheet listing the names of the worksheets in the workbook. The worksheet names are also hyperlinked to the worksheet to allow quick navigation of a large workbook. The trial version...
Tags: Name, Workbook TOC, Microsoft Excel, Microsoft Office, Office Suites, Software
Software downloads 2007-06-19
Excel 2003 Sort restrictions
Is it possible to "protect" an excel worksheet/document so that users can access, add/edit line items, but NOT be able to sort the worksheet?
Tags: Excel 2003, windows, excel, office 2003, jgdavis, Microsoft Excel
Discussion threads 2006-04-12
Regarding 871W Worksheet (DHCP, cable modem)
After using this worksheet, I can't use the SDM to look at my settings. I am wanting to use the SDM to view other settings. Can anyone help me? Thanks in advance.GL
Tags: Modems, glee0815@..., SDM, cable modem, DHCP, modem, cable
Discussion threads 2007-07-15
Import and convert Web text to columns in an Excel worksheet
Armed with a Web query and some conversion options, you can bring Web table data into a worksheet in a format you can use. This example walks through the process. by Mary Ann Richardson
Tags: Web, Microsoft Excel, Channel Management, Microsoft Office, Office Suites, Software, Marketing, Mary Ann Richardson
Blog posts 2008-08-19
  • << Previous
  • page 1 of 1
  • Next >>


Cisco IOS Command Chart (IOS v.12+)
Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.
Buy Now
Quick Guide: Windows Group Policy
One way for help desk technicians and network administrators to reduce help desk calls and protect their networks is to limit the damage curious users ...
Buy Now