In a column of my spreadsheet there are only VLOOKUP functions, all working properly.
But now I want to replace that function, with the value found by that VLOOKUP function.
I found something like doube click (in-cell editing) and then F9, but that only works for one cell
at a time ...

Step1:
Worksheet KPI: I want to find out the number of appointments made fo
AMK on 1Sept.
[image: http://img.photobucket.com/albums/v99/selfobsessed/excel1.jpg]

COUNTIF problem - I hope this makes sense!
A10 heads a column of box sizes:
40
50

Hi, everyone,
I need only 30 rows, 7 columns in my worksheet, and I want column H, I,
J, ... row 31, 32, 33, ... to "disappear" from my worksheet, even the
column/row indicators (i.e. H, I, J, ... at the top, and 31, 32, 33,

Dear all, I still cant get the correct formula for this.
Please help me. Thaank you.

I'm not a big fan of Excel's default chart colors.  I can change them as
needed & experiment w/ what looks best, but are there any downloads that
would allow me to conveniently reset the colors in one fell swoop?  Thanks.

How can I add comments to a protected worksheet (office 2007 beta).
Darrell

i need block paper for math

When I execute the code below on the second iteration reading the file
I get run-time error 1004.
Can someone help me correct this problem? I don't understand what I'm
missing.

 I have a spreadsheet with about 180 tabs.  I've done a Macro to complete a
few tasks on the 1st Tab. I now need to complete those tasks on most of the
remaining tabs.  Is there a way to do this without copying the same Macro
and then changing the tab name?  There are about 5 ...

I like to import a XML file into excel. In the header of the XML file is a
URL for the validation of this file. However the url in the header is not
there.
This valdiation (XSD) is on my local drive. Is there a possibility to tell

Having used the "Text to Columns" tool once on a worksheet (to separate by
spaces), I find I can't switch it off. Every subsequent time I try to copy
and paste some other text from a single cell, for some completely different
reason, the pasted data gets spread over many columns ...

Lets say you have a 15,000 line spreadsheet covering about 8,000
different items.  Some items have multiple lines devoted to them.  Each
line is a separate transaction related to that item.
After sorting the list by the item name, I now wish to have excel

I have copied the following data from a web page that has it listed
as shown below:
311.000     AM      STRATCOM primary
321.000     AM      STRATCOM secondary

Is it possible to scan barcode and enterformation to excell spread sheet all
at one time?