I hope someone can help.
I have a column of cells.  Each cell contains some text, and then a
number in parenthases, then a comma, and then come text, and then a
number in parenthases,  This repeats probably as many as 5 times,

Hi.  Is there a way to set up a pivot table so it will automatically
update when its source data changes.  It seems that by default, I need
to explicitly tell it to refresh.
Thanks!

I am trying to copy conditional formatting using formula instead of
cell value.  I cannot get it to progress down the column.  I attached
a file to illustrate.
I have oversimplified the illustration but in it I would like to apply

I have two colunms. Colum A has a list of names and colum B has a list of
dates.
I would like to count the number of times a certain name name in colum A
appears with the same date once or more.

Hi,
If I have a list of random numbers down columnA, how would I write up a
formula in another cell that calculates an average of the figures
greater than a certain figure (say, 0) but less than another figure

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&B have the corrdinates of the devices. Column C has
the formula to calculate the distance. I figured out how to get the distance
from the source to the first device then to the ...

Does anyone out there know if it's possible to apply a filter to several
worksheets at once?
I have a spreadsheet for tracking the progress of a portfolio of projects.
There are 7 tabs in all, and each tab shows different elements of the project

Hi... we have a work log at work (obviously) and I was wondering if i
is at all possible to set up the workbook so each individual user ca
edit in his/her assigned worksheet ONLY!!  Ideal scenario I want i
that we can all edit this shared file but only edit our assigne

i m using this function =IF(SUM(F6:Q6)>0,SUM(F6:Q6),"") but when i enter
number in h6 or it found blank range it is returning #ref!. I just want it
should return blank. How?
same function i m using in another sheet and it is working properly. why so

Sir/Mam,
Please let me know about ERP. Is it like Windows operating system?
RRS

I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are taxable
on both, others only on 1, is there a way to automatically charge 1 or 2
taxes on the total.
Thank-You

OK I have two spreadsheets. One spreadsheet (out of stock) shows model
numbers that have been taken out of stock. The other spreadsheet
(stock) shows the same model numbers and a quantity field.

Is there a function opposite to Workbook_NewSheet???
I have a menu that list all the sheets in a workbook that updates itself
everytime a sheet is added, I would like it to update when a sheet
is deleted as well.  Any way it can be done?

Hi.  I want to make a pivot table using two columns from the same
table/worksheet.  However, the two columns are not not next to each
other.  How do I tell the Pivot Wizard to use data from these separate
columns?

i want to know how to design one for a project i have but do not know how
please tell me.