I have two columns of data:
Date      Value
1/1/05    9
1/1/05    10

I've learned to add an accumulator to multiple cells using the
code on http://www.mcgimpsey.com/excel/accumulator.html
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
     Static dAccumulator As Double

In Excel I have a customer list of Name/Address/ Contact info etc - which
individually appear in  text boxes in User Form1 when scrolling down  the
list  -works OK. For security reasons I want to issue each customer a permit
to show on entering the premises. I have opened a new ...

(dd/mm/yy) upon opening the spreadsheet and automatically update the
same way Microsoft Word's AutoUpdate feature does. I have searched this
forum up and down and cannot find anything that tells me how to do this.

I have a survey whose answers were recorded in Excel. The answers for a
particular question extend from Q6 to Z505.  I need to count the people who
did not answer the question (that is, the people, entered in rows 6 to 505
that left columns Q through Z blank). I'm not sure how to ...

I am using MS Excel 2000 and I want to password protect a worksheet to
protect the format and formulae but still allow users to use the filter
facility. Is this possible?

I generate 100-200s .csv files end of each month for my company.
Each of these .csv files have numerous data that I need to sum up for a
report.
(Example: 1.csv have 3 columns with things like, item A, item C, item D etc

I have several Workbooks in a folder. Each Workbook has only one Worksheet.
How can I copy all the Workbooks into one Workbook with as many worksheets
as there were Workbooks in the folder?
Thanks.

We have an Excell addin. On one machine the addin is in one directory but on
another a different directory. When a shared workbook is accessed then if
saved on the first machine the second will always ask to update links. What
is the best way to update these links or for the ...

Using Excel -  In column A I can enter 4 different cash values e.g. 30 / 13
/ 10 / 5
using the formula in column B/C/D/E =IF(A3=Rate_30,A3,"") 30 shows in the
cell B3  cells C3 / D3/ E3 for that row shows zero

I have a monthly budget which I have been using for a few years. And for
those years I’ve tried to write a formula so that a row does not show the
last number all the way down the row.  For example I allow myself $100 a day
for frolic and fun. So I have a  column “spent daily” ...

Pls tell me what macros are, and what benefit(s) do they serve?
I use office 2003

On A User Form I have a Frame with 6 Text Boxes within the Frame - is it
possible to just print the Frame and the Text Boxes within the Frame - and
nothing else on the User Form.
Any help much appreciated

I am running into a warning message when I try to print within a
workbook.  The warning message is: No more new fonts may be applied to
this workbook.  Can someone tell me why I am getting this message and
how I can get rid of it.

cpearson directed me to working code to correctly parse the time and date
formats.. it works great when only either date or time is used as a
worksheet_change. How can I add a second worksheet_change for the cells that
have date?  (the time cells already have the procedure)