I have searched the forum for a clue to answer my own question with n
luck.
I am a novices compared to all of you.
I have parts spareing work book that creates a recommended parts lis

I need a sample spreadsheet that sorts by month/yr (I have the day included
but that's not needed) and then sorts by 2 additonal fields within the
month/yr.  I need subtotals on the fields once sorted.

I have a table on left column is name of a server on the right are columns as
to their backup status the list of servers is about 100. I would like it if
an user could click on that cell and my doing so macr would sect the contents
and using that data to use on a custom filter on ...

Hi Someone very kindly made this for me but there is a narly little
problem, example best explains it...
Lets say this represents two rows of data
1 would be in position A1

Using Excel 97.
I run a macro to put the header on a worksheet.  Prior to the header, VBA
code is run to filter a list.  The problem I am having with the formulla is
that it counts all records, not the records based on the filter that had been

I recorded a macro in Excel that will import data from a SQL Table .  The
data imprted will be between two dates.  Does anyone know how I can set the
two dates in two seperate cells on a worksheet and then run the macro.  I
have tried several things and had no luck.  I included ...

I need a MSG box to come up if any cells from A1:A10 AND/OR C1:C10 contain
BOTH a "Y" and a "N". They can contain ONLY either "Y's" or "N's"....not both.
Any suggestions?
Thanks,

hi,
i have a problem with changing the styles in the cells.
Suppose a cell contains some text, say "<F><Center 354><N><F><U>Test
String<G><N>"

When I input =if(ab5=ab6,"yes","no")
I continually get a "no" because ab5 = 10.00001
                                      and  ab6 = 10.00002
Although I have both cells formatted for 0 (zero) decimal places, i.e. they

I a particular macro I skip several times between two workbooks. As the
name of the mother sheet differs often I would like to replace the name
that I use in the statement to a fixed code so that I do not have to
change the name in the macro each time that I would like to run it. ...

I have accidentally put in some code which I now cannot stop from running.
Can someone please help me.
How do I get into the script editor when a message box keeps coming up:
I can't even get in to post my code.

When I walk through the following statement I get a run time error 1004
that says that the particular file couls not be found.
I used the following statement:
sFilename = Dir("H:\Risk_Management\Special_Review\Upload_files\*.xls")

Hi i have always used the following loop statement in my code.
Do
''stuff
'' have a range setup

I'm pretty new to Excel VBA programming. I'm trying to make a
subroutine that will iterate through the rows removing all duplicate
rows (using a column A for the unique cell values) and taking and
concatenating all the String values from a different column (F) in rows

Hi All....
I have the following macro in a program to prompt the users to occasionally
Archive the file.  It works fine, however, when someone opens the file, if
another user already has it open, I would like the pop-up not to appear.  How