The 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: 1, 2, 3, 4 and 5
In B3 down is: 2, 3, 2, 6 and 8.
In D3 is a parameter which show a value of 8.

I have created a report for our company that covers each day of the month - a
31 page workbook. It looks great, but I now need to protect it. I realize
that I can protect it one worksheet at a time, but this is a bit tedious. I
also know that I can protect the entire workbook ...

I have a spreadsheet of data and a number of the columns have data that is
preceeded by a hidden apostrophe.  The apostrophe can only be seen when you
click on the cell.  I have looked and can't find a post that addresses this.  
Can anyone out there tell me how to remove this.  I ...

Could someone tell me how to make address labels in Excel? I have a list of
people and addressees and need to make labels for all of them.

A cell (say B6) has a formula that reads the text value from another cell
(say D10).
so:
B6 has the formula =D10

How do I count the number of records within a date range.
eg 1/1/2003,1/5/2003,1/10/2004 Using countif between 1/1/2003 and 31/12/2003
= 2

Every user is have a warning message when they start up excel. The
warning is about compile error from a addin/macro (xla file) that a
third party application integrated into Excel (We are running excel
2000). I would like to disable it when Excel is launched, however, there

How to Split the contents of cells across multiple cells
Hi ,
I’m trying to split address from one cell across multiple cells with no
success  with Data / column to Text and then  wizard   if the suburb was only

I am using Excel 2007 in a vista premium home esition. I have 3 worksheets,
Sales Order, Companys, Product.
On the sales order, I have a box I want to call company ID #, I want to
select the company and I want it to populate the Companies address,  I have

There are two columns on sheet1 A & B having different figures. And on
sheet2 I am getting sum of these two columns. After applying track changes,
if I change value on sheet1 it shows and accordingly sum get changed on
sheet2 but it doesn't highlight neither show comments. I want ...

I'm using a vlookup function to import data from a pivot table but I'd like
to import the format as well. From previous posts this is apparently not
possible unless you use codes. I'm unfortunately not familiar with coding. Is
there maybe a site you could direct me to where I would ...

I am creating a data entry form that contains 2 controls: one is a combo
box and the other is a list box.  I am populating the control box using
the .AddItem method (property?) during the Form.Initialize Event and
have successfully accomplished this.

I am reading a book on Excel 2003 VBA programming.  It gives a short
synopsis on how to set up the code for the workbook_open macro but
doesn't really go into how to do it.  Can anyone help me with this?  I
am using Excel 2007.  I plan on writing the code on a Vista OS and

I have a problem designing a Pivot Table.
Example :
I rent appartments.
Many tenants rent many appartments in many cities.

Sorry if this question stumped the experts.  Or maybe no one saw the
question.  I'll try posting it again.
Using Excel 2003 and am having trouble getting a formula to extend to
new rows.  I ran a trial formula that simply adds the number in A1 to the