Folks:
I have a simple 1-column Excel spreadsheet containing the ticker symbols of
a variety of stocks.
Now, manually I can go to a website

Is there a way in office 2000 to sort rows by color?  I'm not good with code
and cutting and pasting over 1000 rows is becoming tiresome.
Thanks

I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER
# D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this
formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0)) so the
description comes up automatically in the invoice.  Now what i ...

I am a newbie to the excel world. I have requirement of analysing some
data that I will obtain from symbian profiler. I will be having a .txt
file with values seperated with tabs so that it can be directly open
in excel. In that I have around 25 colums, first being sample interval

I need make a excel so that when i click a
Button it will Add 1 to B3 etc
So each time we sell a product we can just press + or - to add and remove a
figure from that field

Sussed out how to work vlookup. However when the source cell is nil 'hash
N/A'shows. I then have delete the unused vlookups to make printed document
look acceptable. Is there a way to make an emty cell appear when the source
cell is empty?

I had written a vb code to create multiple charts in a single Excel
sheet.
The issue which I face is that in a single sheet the charts are
getting formed ( 9 charts in a single sheet) but all the charts appear

I am trying to use Excel 2000 to create a map of our boat storage areas.
There are a number of Locations such as Boat Compound and Mast Shed. There
are currently 8 such locations.
I have an MSAccess database that stores each area, combined (spaceno and

Hi Folks - I track monthly sales in separate worksheets (Jan, Feb, Mar,
etc.). At the end of the year, I need to analyze the monthly sales figures
on a yearly basis. So, I create a new sheet and copy the individual monthly
sheet data to the new sheet. This is a little time ...

I have Office 2007 so obviously Outlook 2007 and Excel 2007.
I have made up a newbie's Excel spreadsheet for my business. One thing to
open that has my entire financial year's data in it and my car logbook. One
thing I am going to add to it is parts. I want to know when parts need ...

i have a problem to solve:
I want users to be able to pick a project from a list (no problem) and
then i want excel to pick the project number according to the project
name automatically from a list. To make my problem clear let's say a

I am a newbie to the excel world. I have requirement of analysing some
data that I will obtain from symbian profiler. I will be having a .txt
file with values seperated with tabs so that it can be directly open
in excel. In that I have around 25 colums, first being sample interval

I am trying to create a pivot table matrix Big grin
Essentially, I am creating pivot tables using dynamic data sources,
defining the sources using offset and counta.
I need to get these tables in a specific pattern on a single sheet.

I've got a corrupt Excel file.  I've tried a few programs I found online.
Most couldn't do anything, but a couple were somewhat able to recover the
file, but in each cell it said 'lost string.'  I don't know what this means.
Is there any hope of recovering this file?  I'm not ...

Hello professtionals,
I need to use Pivot table using offline OLAP CUB as the data source to
analys a large amount of data. I would like to know:
What is the maximum size for a CUB file in Excel 2000?