I have a spreadsheet listed by day as follows.  I need the
data from column B, C & D summarized by month. How do I do
that?
Col A      Col B   Col C  Col D

I have a workbook with a large number of wooksheets, but I want to open to
the same one each time.  I have closed the file while on this worksheet, but
it always opens to another one (about midway).  I thought I used
tools/options in the past for this, but can't seem to find a ...

how can I ban right clicks on my pages  -  I dont really
want people to click wrongly on buttons. also how would I
stop the code for me to work on it though!!
Amy

Hi, How can i prevent duplicate of data in a coloumn using data validation

How do you Subtract a total from a balance?
A7    $100
A8    $200
A9    $200

Thanks Julie
What I meant was that I have two different worksheets on different disks.
One is 2nd quarter reporting and the other is a 3rd quarter reporting with
the same template.

How do I copy one excel worksheet and into another worksheet to make it 1 worksheet?

Is there a simple way to make a cell blink or flash or otherwise be very
distinctive from other cells?

I have a workbook with 50 sheets, each of them with the same structure and
the same 34 macros.  When I type numbers in cells, there is a two or three
second delay before the number appears.  Does the number of macros on a sheet
slow down the entry of numbers and calculations?

It used to be you'd just grab the colum and move it.  Now all it seems
I can do is select the column and then do all kinds of machinations to
get it to move.  How do I just put, column A right after column B
without deleting or adding any columns (I know, of course, that column

After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty ...

Thank you.  Now I want to take the sheet that summarizes
the individual dates divided into the 3 times groups - and
total them by month.  How can I do that without having to
manually choose each range for each month?

Following is an example of the type of data I have in Column A of my
spreadsheet.  This is just one record there are hundreds that are
similar.  I would like to extract the Address and Owner and the 3
lines below that to another column, worksheet or workbook (it doesn't

I would like to get my workbook to open to a certain
worksheet and focus on cell b2.
how do i make it do this.
thanks

I just need to do a count on the data below:
Any client # that begins with JE - I need to know the
total # of JE's for each day of the year.
For the JO clients - I need to know the total # for each