How do I use data from a pivot table in a formula outside of the pivot table, and autofill down?

I am creating a workbook and plan to have a help sheet located within the workbook. I don't have any problem linking each sheet to the help sheet with the...

I have a list of 600 names that need to be entered onto a form. Each form is located on it own excel sheet. Each form needs a different name on it. Can I...

In 2003 I was able to save the workbook usin a Exit Macro and with the VB protected. Now is saying that I have to unprotect the Modules to be able to save...

Do we any patch or add in for excel 2003 so that we can have more that 256 columns in excel 2003 -- MOHANCHANDRAMISHRA

I'm currently using the following in a column of cells: =IF(SUM(I3:L3)=0,"",SUM(I3:L3)) However when using a pivot table on this workbook I am getting a count...

My data worksheet is only 1,404 rows and 13 columns (not all data being used) - but every time I try and add a formula I get an message: "There are too many...

Following is a sheet where I enter data: 1 2 3 4 5 6 7 Date Acct # Scheduled ...

Excel 2003 had an EDIT FILL JUSTIFY feature for justifying text. How does one do this in Excel 2007?

I am new to Excel 2003 and would like to know how I can find the total number of records / rows in a particular file without scrolling down until I see the...

When others view a spreadsheet, how do I enable them only to see the cells with data? I would like to keep them from scrolling through the 64,000 rows of...

I have a dollar amount in B1 ($97,903.85), a dollar amount in B2 ($95,504.38)...with ups and downs through B25. In a separate column, I would like to show...

Did the site get hacked? I can't download the add-in, and when I try to go to the main page, well, I can't repeat that here... -- ** John C **

i WANT TO REPEAT THE SAME TEMPLATE ON UPWARDS OF 200 PAGE WORKBOOK. ESSENTIALLY I HAVE A FORM ( W/ BLANK ADDRESS AND COMMENT CELLS)THAT I WOULD NORMALLY...

I want to build a macro which will produce a pivot table. The catch is the number of rows in my data will vary. I started by recording a macro which built...

Is it possible to split individual cells into 2 separate cells? I have a worksheet that basically has 2 sections: the top part alternates between wide...

Hi guys, I need to get a solution for this. If write a data in Cell A1, how can I get in cell B1 the time on what this data was writen. Thanks in...

What does a double hyphen do in a formual? e.g. =SUMPRODUCT(--(Sheet2!$A$2:$A$100=$A2),--(Sheet2!$H$2:$H$100="H98")) I saw that as a response in a different...

My version of excel used to function such that when I would be selecting my data range for a vlookup, as I was holding and moving my cursor, a box would...

Help! My boss wants some stats. In order to get her what she needs, I will have to open several hundred password protected workbooks (each workbook has five...