I have data where I using with pivot table. I have more than 1000 data in
sheet1 and pivot table in sheet2 when I delete some data from sheet1 it
should also delete from sheet2. but it’s not delete from sheet2.
Pls help me.

Hello, I wonder if you might be able to guide me in the right
direction.  I am a physician and need a bit of help.  One of the
medications I prescribe is limited to prescribing it to only 100
patients at a time.  This number is based on the script activity.  For

I have data in 10 columns.
In a column I have data related to some codes take an example of
routing numbers.
Suppose user provided 10 routing number in a specified column.

Hi,
I have about 50 files in a folder and I want to run my macro on each file.
Is there a way to automate this?
Any help would be appreciated.

Hello;
I would like to reference a cell in a workbook that is on a hosted server.
The following URL for instance:
http://www.chapinchristiancounseling.com/Test/test.xls

Hi All.....
I have a little Query macro that works just fine on my computer, but
unfortunately has the path to the source file hard coded inside.  I would
like the Query to always look to the default directory that the Excel

I have a sheet with cells auto updating there contents by linking to a
data source out of excel
can I use them as data source for a graph and how?
Or saving them in another sheet by time for instance:

This is going to sound like an odd problem but I would be interested to see
if anyone else has the problem.
I have written a DLL in C++ using Visual Studio 2003. I can call the DLL
from Excel under XP on my desktop but when I set the same up on my laptop I

I am having some problems with this code. This is part of a macro.
This part is working fine
   ActiveCell.FormulaR1C1 = "=SUM(RC[" & -Sheets.Count & "]:RC[-2])"
But I want to include this part

Arrgh please help
I have a spreadsheet that has two tick boxes.  The second tick box
mustnt show until the first has been ticked.  How do I do it.
Many thanks in desperation

I've dropped a button on a UserForm. The UserForm is user-resizeable
(thanks to Bullen's FunForm.)
What height property or other vertical quantity do I access in order
to programmatically position the button flush against the bottom of

I did have a worksheet set up with vba to find a value in a particular
column in all workbooks in a set folder, but i must have deleted it somehow.
IF a value was found it copied the sheet in the workbook into the current
workbook for viewing.

My UserForm has a TreeView. A node is selected, has blue background
color, and is fully alive.
But if I minimize the form (thanks to Bullen's FormFun) then restore
it, the node is still selected (.SelectedItem.Selected = True), but

Is there a way to arrange the icons on the taskbar?  For instance,  I open 5
excel files and I want them in a certain order on the task bar.  How can I
change the order of the icons on the taskbar?
Thank you,

All,
I'll apologize in advance for the long post--please bear with me on
the explanation of what I'm trying to do.  My work requires that I
spend a fair amount of time wading through very large Excel indentured