I've got Excel 2002. In my spreadsheet, column B is a lit of boxes that our
parts are packaged in. In column C, I want to list the dimensions for the
boxes listed in B. How can I write a formula so for all of column C, it will
read the B for that row and put in the correct ...

I need to delete 2 columns (with formula) and only display the last two
columns.
When I delete the first 2 columns,  the last two columns display  #REF!.
I know I can copy the info I need to a new sheet and paste special the

Using Excel 2003. Made copy of a matrix I built years ago. Now want to
update it and show which cells have changed by making the font blue rather
than black. Too many changes to make by just changing the color after each
adjustment. Can't find anything that will permit me to ...

Is there any way to turn off the dotted lines that show the print range area
within worksheets?
I don't know why someone would want them unavailable, but a co-worker of
mine insists "they don't turn on half of the time anyway, so why use/show

I'm generating excel documents via PHP, and am running into a wall
with the 255 character limit for a cell in Excel 5 (the format the
script exports in).  Is there any way around this?

Excel 2007
Any easy way to color alternation rows on an excel sheet?
And to make it more complex can I do the above within the constraints of
certain columns (color alternation rows onlw between columns 1 and 7 - for

I am trying to have excel open an HTML file that contains nested
table, the outer table contains fields that can be used to perform the
sort.  But this is not working, Excel instead converts "Line 1" and
"Zipcode 1" into merged cells as well as "Line 2" and "Zipcode 2" (see

Anybody know how to make a dial type (speedometer style) graph.

I was trying to plot the Scatter graph for a specified range in
different columns. I have 3 columns with specified ranges Col 1 X axis
and the col2 and 3 plotted on Y axis . I have generated a record macro
for the same and it look like the same below.

Does anyone have a good idea of a formula to convert US Dollars to Euros?
Dave French

I am trying to create a works requisition in Excel for our staff to use on
the pc and email to me so to make the progress a bit faster than snail mail.
what I need to do is have a 6 digit number starting at 400000 on the top
left hand corner of the page, that will go up by 1 digit ...

I am creating two columns where data is continually added.  In one
column I have units either lbs or kgs listed.  In the second column I
have a price. I want to create a formula that will pick the last entry
in the units column and depending on whether it was lbs or kgs

I'm wondering how BEST to accomplish this.
I have a EXCEL workbook which populates data to, and retrieves data from SQL
Server.
I currently have VBA code which effectively sends the data from the EXCEL

Hi I need some help to find out following
Select the range of a column depending on the last value of the same.
Then check the individual values of the column to match a threshold
value.

I am looking for the VB code for a button that places the time into
the cell? The time should be placed into a cell right of the cell that
is marked a the present date
A    B