I have spreadsheets that I need to update weekly and have been creating a new
copy of the spreadsheet each time I update it.  I was wondering if the is a
tool either within Excel or external that will allow me to log changes
similar to CVS or Subversion does with text files, so ...

My Data Validatio drop down has 30,000 rows.  I need to do the following
1.Increase the number of rows shown from 8 to 50
2.Allow users to type in the drop down to filter their search.  For example
when they are in the drop down and type "B" it brings up those list choices

I'm using the following formula for my mail monitoring spreadsheet:
=IF(N13<=L13,"Yes",IF(N13>L13,"No", IF(J13=No,"")))
Column J is the "Response required?" column
Column L is the "Target Date" column

That seems to have fixed one problem but now there is another one on how to
set  ws v ariable.  Since it is a userform I probably don't need to activate
it since it is already activated?  All I need to do is set the worksheet
patients.  I don't know if it needs to be the active ...

When I activate page 2 I want the screen to becaome larger. That is the
problem.
By hiding sheet tabs and navigating to sheets with macros it is possible.
However the user can unhide sheet tabs.

I have about 10 different excel files in a folder. Each file has 1 worksheet
whose data i want to pull in different sheets in 1 consolidated excel sheet.
I do know how to pull the data from different sheets by recording a macro.
What i would like to know is how do i rename the 10 ...

Can you help me out.  The "set range" line doesn't compile.  I just need the
used range in column A.  It needs to be relative because the user can change
it.
thanks

In column J from J2:J46 I have percentages and tomorrow I will add another
percentage which will go in J47 and this will continue everyday.  I would
like a formula in cell J84 to find the last cell that has a percentage and
have that percentage show up in cell J84.  So today it ...

I have a Large Spreadsheet and i use Auto Filter to find the Info i require.
No Problems.
In the Original Spreadsheet some CELLS i have BOARDERS arround.
Auto Filter places them correctly.

i have facing a problem in excell auto filter option, i have over 1000 data
when i filter on SR no. and filter on it there is showing only 1000 SR no.

How do i represent ARCCOS in exel spreadsheet

I need help with a simple question:  what is the formular for not equal to 0?
I need to have a formular for =IF(A1:E1 not equal to 0,F2+1,0).  Please
help.  
Thank you,

We have a number of excel workbooks on a shared network drive.  Normally if
you open a workbook and another user is already working in it/viewing it, you
receive a file in use message with read only/notify when available etc
options.  However on a recently created workbook this ...

I WOULD LIKE TO CHANGE THE DEFAULT TEXT AND SIZE OF THE COMMENTS

Hi there, wonder if anyone can help. Relatively new to loops, and can't get
it to stop looping!!
Here's the code, trying to insert a row after every cell that has "Total for
department" (number of occurences vary each time), and whilst the row gets