Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use dynamic ranges to make your Excel spreadsheets easier to understand
- Mistake found... wrong reference for Order_DateOrder_Date should be =OFFSET(Sheet1!$A$1,0,0,COUNT(Sheet1!$A:$A),1)Not the stated=OFFSET(Sheet1!$A$1,1,0,COUNT(Sheet1!$A:$A),1).Must be a typo!Still getting a zero figure in the sum.I've made the change as specified by Edward, but it's still showing a zero value total.Any hints?----Ignore the last comment - helps if I enter into the right column -...
- Tags: Microsoft Excel, Microsoft Office, Edward C. Hsu, Excel spreadsheet, Sheet1!$A:$A
- Discussion threads 2007-04-04
Additional Resources
- Excel: can you reference cell output for a formula range?
- Hi;Here is my question. I want to fit a line to an exponential curve in excel, so I can't use the zero values that occur in my column data. In other cells in the spreadsheet I have calculated the row# of the column where my values turn zero, but I...
- Tags: planktonguy@..., Microsoft Excel, Linest, cell
- Discussion threads 2007-08-24
- A formula to return a formula in Excel???
- I have a situation in which several hundreds of sheets in the same workbook require the same formula to be enterred. Is there a way short of building a function that I can enter the formula once in a 'Legend' sheet, and then use a reference to that cell in...
- Tags: bubba_barnett@..., Cell, Cell A1, Sheet1
- Discussion threads 2007-04-24
- 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
- Excel row comparision
- Can the following be done with a macro or some other way in Excel 2003 ? I have looked at comparision utilities but most of them add and delete rows which I do not want. Compare rows in two spreadsheets in seperate workbooksHighlight the row in the second...
- Tags: Microsoft Excel, rdoucette@..., Sheet1, software
- Q&A 2005-03-24
- Excel help
- How can I reference link, from an Excel 2000 cell, the last used cell in a column.For example, a spreadsheet has rows of entries of debits and credits. A new balance is calculated in the Balance column for each row. In another sheet I want to reference the...
- Tags: CountA, Microsoft Excel, skat, software
- Q&A 2005-01-04
- Excel - linking cells between 2 sheets
- I have 2 sheets, sheet 1 look like this: Col A Col. BH due dateGVTH due dateGVSheet 2 has datesrow 1: 010207row 2: 020307I would like sheet 2 date data populated to sheet 1 where the cell says...
- Tags: cell, jessica_Gossett@..., e-mail, Microsoft Excel
- Discussion threads 2007-03-01
- Hyperlink in Excel with IF function
- I would like to know how to create a hyperlink within an Excel file that would move from either sheet1 or sheet2. For example, the hyperlink will take me to Sheet1 if the content in Cell A3 = A and the same hyperlink will take me to Sheet2 if the...
- Tags: chris.goh78@..., hyperlink, Cell A3, Microsoft Excel
- Discussion threads 2007-05-28
- Create an Excel chart that automatically updates with new data
- Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of data to your spreadsheet. If you add a row or two of data to your...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click Add, Microsoft Office Suite Excel Tips Newsletter, Data, Chart, Office Suites, Software
- Technical articles 2006-04-25
- Microsoft Excel 2003
- I have a workbook with several worksheets, within the workbook I have a master worksheet that has a compilation of all the other worksheets. What I need to happen is I want to add the total columns in the other worksheet and display the totals on the master worksheet; the...
- Tags: worksheet, tru.notoma@..., IBCT NG, windows, windows xp, security, software, career, it management, hardware, networking, excel, e-mail, microsoft office 2003, workbook, Microsoft Corp., Microsoft Excel, cell
- Discussion threads 2007-02-22
- "If CheckBox1.Value = True Then" what's wrong here?
- I have a problem using the checkbox since what I want to use is not the checkboxe's click event, i only need to use his value.I'll try to explain with the code: On Sheet1 I have a Cmdbutton, when you click it it does this, Private Sub Command
- Tags: checkbox value if...then... else..., End Sub, leocoppens@..., software, windows
- Discussion threads 2007-03-08
- Dynamic link
- How do I set up a dynamic link between 2 excel sheets.Type an = sign and then switch to the other sheet and click on the appropriate cell. It will look like:=Sheet1!A1/You can also name the range. Select the cell and type a name in the name box to...
- Tags: cell, demo@..., Formula Bar, software
- Q&A 2004-12-02
- Help users find information with an interactive Excel chart
- When you create an interactive Excel chart, the way to really make your users happy is by letting them find data they want according to their parameters. Learn how to do that by following these step-by-step instructions. Instead of creating multiple Excel charts that give different...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click Add, Click OK, Microsoft Office Suite Excel Tips Newsletter, Chart, Sales Strategy, Office Suites, Software, Sales
- Technical articles 2007-05-01
- Save time reformatting by using Excel's Fill function across worksheets
- You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You've just made some changes to the font color and the background of the...
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-05-27
- Forgotten Excel File Solution
- Hi, someone posted opening a new SS and type = (lockedss.xls)sheet1$a$1 and cell A1 and saving in the same folder as the file. I've tried this but don't know what to do next. Also found another poss solution whereby you use powerpoint to view contents
- Tags: off-topic, programming, it management, security, nicola.steenkamp@..., windows, feedback, Microsoft Excel
- Discussion threads 2006-12-27
- Forgotten Excel File Solution
- Hi, someone posted opening a new SS and type = (lockedss.xls)sheet1$a$1 and cell A1 and saving in the same folder as the file. I've tried this but don't know what to do next. Also found another poss solution whereby you use powerpoint to view contents
- Tags: off-topic, security, programming, it management, nicola.steenkamp@..., windows, feedback, Microsoft Excel
- Discussion threads 2006-12-27
- Forgotten Excel File Solution
- Hi, someone posted opening a new SS and type = (lockedss.xls)sheet1$a$1 and cell A1 and saving in the same folder as the file. I've tried this but don't know what to do next. Also found another poss solution whereby you use powerpoint to view contents
- Tags: programming, off-topic, security, it management, windows, nicola.steenkamp@..., feedback, Microsoft Excel
- Discussion threads 2006-12-27
- 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
- MS EXCEL
- How to link data of a cell in sheet1 to a cell of sheet2 in Ms Excel
- Tags: Microsoft Office, moharroy@..., Microsoft Excel, Microsoft Corp.
- Discussion threads 2007-05-07
- Excel display 2 sheets side by side
- In Excel, how can I display two sheets of the same workbook side-by-side. I would like to "jump back and forth" editing the two sheets.Save your workbook with a different file name and then open 2 instances of Excel. Tile your windows vertically.Save each sheet alone:- Activate the first...
- Tags: Microsoft Excel, rquisenb@..., software, File Name box, File Name
- Q&A 2006-05-24
- << Previous
- page 1 of 1
- Next >>
