I've a workbook with several sheets :
Sheet 1 : serveral data
Sheet 2 : I want to copy two colums in a printable format.
In "Cel A1" (Sheet 2) I've a formula : "='Sheet 1'!D2"

I have a sales forecast workbook that has 4 different tabs, one for
each quarter.  In those tabs are columns like:
Customer Name
Revenue Type (product vs. services)

I am trying to create a Purchase order form in which the first colum is to be a drop down box of the list of available products. Once they make their selection other fields are the spreadsheet will auomatically fill, such as product ID number, product type and so forth.  I've ...

Total Excel virgin here (and proud of it - LOL).
I'm putting together a sheet that will have a lot of cells that a
client will enter the values in, and then send to HIS client to fill
in the rest.

I'm working on a spreadsheet that has a column listing "number of payments
left" in an "Add-On" type loan. The column is set to reference the number of
payments in the loan up to 60 months. If I have it set as a 24 month loan,
it shows negative numbers in the column for the "Number ...

Is there any way of referencing every other column, to each row in a
another spreadsheet without hard-coding it?
E.g.
We want cells A1, A2, A3 ... in sheet 2, to contain, the values of

Am using MS Excel 2002.
Simply, I have the following columns:
May-04 | Jun-04 | Jul-04 | Aug-04 | Sep-04 | Oct-04 | Nov-04
Above this a user can choose to view the spreadsheet by any combinatio

I have many worksheets, each worksheet has student ID, marks for each parts
of assignment and total mark.
For example:
Worksheet 1:       Student ID: 232, part one: 4, part 2: 6,  part 3..total

I have TextBox1 with this Value = 57.7
I need do something like this
MyNewVar = CDbl(TextBox1) .... but this is Type mismatch error 13
I need transform text value to number value.

Hello, All,
I have a spreadsheet with invoices being taken from a standar
amout of money.  I have gotten it to do everything correct except on
thing.

I have created a spreadsheet and locked certain cells so that users cannot
change the information apart from one column.  I then want to be able to
filter the data using the editable column.  Can this be done?  Even using
the Allow Users to edit ranges (with a different password) I ...

I'm trying to lock the scroll area on my worksheet.
In VB I've got:
        Private Sub Workbook_Open()
        Worksheets("Board").EnableSelection = xlUnlockedCells

I am trying in vain to find a function within Excel 2003 that will enable us
to calculate the monthly investment required to achieve a given amount after
X number of months at a known rate of return. i.e
"How much does one need to invest monthly @ 6% per annum interest in order

I suspect this is relatively easy but I'm not sure how to accomplish this.  Is there a way to count the "non blank rows" in a specific column.  We need to know the number of rows that have been filled in within each column....thanks

In a workbook, I have many worksheets. Each worksheet is a detail of a
person with ID and grade. These worksheets are called "Detail worksheet".
(for example, in a worksheet, cell A1 has 232 for ID and cell A3 has a grade
of 9. In another worksheet, cell A1 has ID is 321 and cell A3 ...