I have created a spreadsheet for filling in details in a section and I want
the user to input the data as and when it's needed.  It contains the field
headers to guide the user to fill-in the correct data)
I created a macro to copy the section of the spreadsheet  i.e. rows 3 to 10 ...

I'm trying to create a material order form where in the 1st column I
would have a pulldown list to choose a category of material (ie:
Piping, Ducting, Fittings, Accessories...) and then my 2nd column
would have another pulldown list of material based on the selected

I have an on-line MySQL database and wish to have a table in it
available for Excel.
I can use some php to get the data and then put it into Word and edit
the file to put each record onto a new line and then open the text

I want to create a pulldown list to select various material based on
size (ie: 1/2" x 1", 5/8" x 1", 3/4" x 1", etc...).  I then want to
use VLOOKUP to find the associated price.
The problem is that my list of material is not in alphabetical order

Some sort of excel glitch here. I have a pivot  and a dataset. The
pivot shows the item selected but the data is not shown. And when I
select only that particular item its all zeros. I checked my data set
and its there. Do I have to redo the pivot. I actually just pasted

cusID = Worksheets("db").Cells(intRow, 5).Value
       cus = Worksheets("db").Cells(intRow, 4).Value
       qty = Worksheets("db").Cells(intRow, 8).Value
       Worksheets("nvT").Range("a" & Columns.Count).End(xlUp)

I'm unable to understand what use a "+" sign has if it is put before a formula.
For ex: +(C13*(1+$M$10)+J13)/(1-$M$12) gives the same result as
(C13*(1+$M$10)+J13)/(1-$M$12).

In a workbook, I have 2 sheets ( sheet1 & sheet2)
Sheet1 –
        A             B              C              D         E
1    Codes       Date          Grade    Action  Status

I have 2 columns that have dates. In column 1 I enter a date. Column 2 is
linked to the first column. If there is no date in column 1, column 2 then
(for I don't know what reason) has "Saturday, January 00, 1900". I want
column 2 to look exactly like column 1. How can I get ...

The code below shows:
ColA
Qty1
Qty2

I am creating an Equipment Status worksheet for my job. Is there a formula
that I can use to change the background color of a paticular cell if I type
the word of that paticular color in it? I.E. in the status column I type the
word "red" how can I make that cell's background ...

I am using MS Excel 2007, the draw function. I have some freeforms and curves
that I must modify, but can't find the equivalent of 2003's "edit points"
feature/tool.
Can someone tell me where to find it?

Trying to find an updated version of the above.  Current version will not
work with last couple of Excel versions.

Just now I downloaded what is supposed to be an Excel spreadsheet from Amazon
Advantage. It is actually an XML file with an XLS extension, so I assume that it
should have been an XLSX file instead of XLS for Excel 2007. Is there a
converter to enable opening the file in Excel ...

I have a very large number (8 digits, perhaps) in a cell and wish to
increase marginally that number (add 2, say) without re-typing (almost)
the entire string of digits.  Is there an easy way (maybe holding down a
simple key-combination then hitting "2") that will achieve my aim?