i want to maintain one main worksheet with ALL the info and separate it into
multiple worksheets.  when i make changes the the multiple worksheets (within
the same spreadsheet) i want the same changes on the main worksheet.... is
this even possible.

A cell shows 20. Formula bar shows 20. Formula bar should show 540/27.
How can I make the formula bar show the example formula 540/27?

I'm having trouble figuring out how to simply take data from multiple
worksheets and list it in one "total" worksheet all within the same workbook.
I want to have this perform automatically as opposed to me using the
copy/paste function and do this manually.  All the data will ...

I have to re-format product UPC's from 01-23456-78901-2 to 012345678901.  
And, the Concatenate and Left, Mid, Right functions just confused me.  Does
anyone have any ideas?  Thanks.

Good morning,
I have a very large worksheet, some 15,000 entries, and I would like to
delete all the rows with "no" in col G. Is there a macro for this?
Thank you in advance,

What is this function "Framta" stand for?

I want my column headings across the top to have actual words in there
instead of being just the alphabet all the way across. I like to have
my rows match up to the numbers on the left but if I make a column
heading starting in row 1, then my numbers are off on the left by one

I am trying to reset the hyperlink base in an Excel document to a network
drive.  It keeps defaulting to My Network Places.  I've followed the steps to
set the base address for the hypelinks in a workbook - but it won't reset.  
Any thoughts?

All,
This macro was supplied by a member of the group: Debra Dalgleish
Very helpfull
Sub ResetCaptions()

What is the Fuction if I want to place the function of one cell on worksheet
1 to worksheet 2? Thanks a bunch!

Is there a function or formula that will allow me to make a change in one
cell on the work sheet and the program will automatically change one or more
designated cells with that same change?

Dear Sir
Use an IF function and a VLOOKUP function to calculate the bonuses using
the following rules                               
A salesperson gets a bonus only if they exceed their target.                                 

Two workbooks totally independent of each other but each have the same anomaly.
I need to set up one sheet in either book, and to see if my set up is
satisfactory I need to select a print preview, but all I get is a warning
stating – [your file could not be printed due to an error ...

Trying to setup a column to show the Month to Date average. My data sheet
looks like this. I also need this not to average 0.0% values
DATE       RECOVERY      MTD
1/1/05        95.4%

Hello Gurus!
Here's the deal -- I'm trying to get a percentage value for column V
as presented below:
July 2005