How do i use subtotal function results from one  worksheet  in anothe
work sheet. I am able to work out average price of raw materals brough
but would liked it automatically linked to my profit forecast and actua
sales worksheet.

I wonder how I can expand the length of digits allowed before it goe
into that scientific notation. So far I can get up to 11 digits:
12345678901
before it converts:

Hello Friends
I am new member here ... right now i am struck with one prob in excel
We have 2 structures 1 st product structure & another is locatio
structure

hi this is my first post, i'm fairly new to excel & i was hoping someone
could help me out.
i'm doing some computer work for my uncle & as i was going through
everything that needed doing & i came accross this excel problem. I'd

I tried to format a new spreadsheet to print gridlines on all cells with page
setup.  When I then click on Print Preview, gridlines do not show.

Is there such a feature? What I need is to have column A1's value alway
multiple by 100 in a worksheet, however, I don't know the range of n fo
A1:A'n' , can Excel do such a multiple action while importating th
worksheets

Thanks again to anyone who has helped me with this spreadsheet so far.  I'm
sure this will be my last question.
I have created a spreadsheet with a command button that leads to a form to
remove a child from the spreadsheet.  I have most of it working but cannot

My request is due a printer problem, happens that I have to print a report
of 52 pages, every time I print them as a group I only got a few pages OK
the rest is garbage, I have reinstalled the system and same thing.
What I wanted to do was to set up a macro (after I choose all the ...

I have a workbook with 12 sheets, approximately 3000 rows & 10 columns
each. The sheets contain only raw data, no formatting.
Is there any way I can reduce the size of the file.  At present it is
over 3MB & I'm wondering if it can be reduced in any way.

Running Win98SE :-( and Excel 2000.
Is it possible to get assistance with the following formula.
I am currently determining the Profit Margin Percent with the following
((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin %

I have tried every sequence that I know.  The painter will not paint columns,
rows, cells.  Any suggestions?

I have an annoying problem with Excel that I can't solve for the life of me!
In my workbook, I currently have several sheets that have identical
formats. I use the formula "=Sheet1!A1" to copy text data from one sheet
to the next.

i have 2 col
- fisrt and second col contain value (exiset already)
How to use VBA to minus them an drag down at third col to end of row o
col 1 or 2

I have a pivot table based on a medium sized set of data (5500 rows). In the
left column of the pivot table I have regular dates wich gives me almost the
same number of row in the pivot table. When I try to group the date field, I
get the error message "Cannot group that ...

I have the following data
1/1/06    50
2/1/06    40
3/1/06    30