I'm making an involved spread that starts with a master stock portfolio then
transfers portions to other worksheets. The master gets updated monthly but
it's structure is expected to change often as stocks enter and exit the mix.
This forces reformatting the secondary sheets to ...

   Im trying to make a chart in Excel, I have a list of addresses and
states, I want to make a pie chart of the states to show what percentage of
all the states each state is. But if I select the columns and click on the
chart and choose pie, in the end I just have a line. Ok im ...

Hi group -
I have a very simple task, but having trouble figuring how to do it.  I have
values in a range of cells, let's say A1:A10.  In cell A11, I have a formula
that sums that range.  In cell A12, I have a value that reads =$10,000.00.

I'm having trouble with a basic function.
I have an entire column of prices in the format $xx.xx
I need to take that entire column, say Column C, (titled "price") an
multiply each cell by a number and paste such that Column D become

I'm trying to use a cell value as part of a vlookup function. The idea
is to keep changing the lookup query based on a the contents of a
specific cell
This is the forumla I'm currently using

I've gotten the numerical problem handled, and now I have a differen
hitch in the getalong.
I have a table in Access and I need to get all the info from the Exce
spreadsheet into this table. It won't let me cut and paste the whol

Hi, I'm trying to create an appendix for a lot of resource
information. Having trouble with the text and alligning
the columns. Also, I want the grid lines to remain on the
printed version- any suggestions????

Is there a way to count the occurrences of a certain character within a
cell?
For instance cell A1 contains 1-20/2-12/3-9
I need to find how many times '-' or '/' occurs in A1

Is there a way to change the default font size for the comment box t
something larger than 8? These old eyes having trouble reading th
comments, especially if the sheet is shown on the screen at less tha
100% size. It is time consuming to have to individually change th

Can PDF file be converted into the Excel file, and added additional
formulas???
Thanks in advance

Using Excel 2002 on XP Pro, some of my network users (2 so far) have
reported that Automatic Calculation of their spreadsheets is not happening.
This seems selective in that some spreadsheets work and some don't.
Automatic Calculation IS turned on in Optioons, but does not happen.  ...

I'm setting up a grid with client names, addresses, phone numbers, etc.  Some of the information for each client takes up two rows, others three or four.  If I add a client in the middle, I'd like to be sure that all the information for each client moves forward to the next page ...

is it possible to create a macro that receives arguments? What I mean is
without using offset, for example:
one time to run the macro with cells A1 A2 as parameters and write the
result into B2

Guys
I have been given a very difficult task and I need help.
Please!!!!!!!!!!!!!!!!!
The issue has more to do with maths than excel.

I have posted to various groups that I think are applicable,
but please tell me if any of these are not.
Here is my question:
I have an Excel workbook with 6 sheets. Three of the sheets