Please any suggestions.
In a workbook, I created many public subs, I protected it from
viewing.
But when I open another workbook at the same time, I still can go the

I have the following:
Selection.AutoFill Destination:=Range("BE2:BE567"), Type:=xlFillDefault
   Range("BE2:BE567").Select
I would like to change the code to include all possible used cells to fill.

I have three columns in sheet1 that need to copied into sheet2 when a new row
is created in sheet1.

I need to extract stock symbols from a web query into their own cells.
Here are some examples of the raw data that is imported:
ACAS|AMERICAN CAP, STRATETIES LTD|Q|Y|N|
CT|Capital Trust, Inc.|NYSE|Y||

I need to cut and paste the result of data that's been subtotaled.   After
hitting #2 and cutting the data, when I try to paste it, the entire data is
pasted and not just the subtotal results.  Is there a way to cut/copy and
paste only the subtotal's?

In Pivot Tables you have your data that you drag and drop as page, column and
row separators for your data.  In the actual data field you can have sum,
count , average,... fields to choose from for what you want to see.  This
information always shows results by row.  I want to ...

I have to create an invoice in Excel with lookup functions that will pull
necessary info from the lookup table to fill in the fields for the customer
on the invoice as needed. I also have to create nested functions, validation
options, macros, etc.

- My report has a 'Data(Raw)' tab and 'Dashboard' tab.
-I'm trying count the date values located at 'DATA (RAW)'!BH:BH but only if
it is less than, greater than and equal to value located on Dashboard tab
cell "AD3" (AD3 is equal to today's date)

I have a Pivot Table, in which I have set set the formats to %'s on the
majority of columns.  
However when I double click on a cell, which creates a new worksheet showing
the expanded data, the data shows as decimals.

I need help with two formulas.  The first is I want a formula that would take
column A below and add the totals that are in column B that are between
3/1/08 and 3/24/08 in column A.  The total I would like in C1.   Also is
there a formula that can be written to take the date on ...

When you apply a filter in an Excel 2007 sheet and wish to change only data
in visible cells you need to select visible cells only. This can be done by
"Ctrl+G", Special and then "Select visible cells only". - This is too much to
do. Is there any way that you can set that option ...

if i have the first  column with multiple repeating numbers and i need to get
the highest number from each of the set of numbers how does the formula read
or get typed?  ie.. column A2 has the number 272, a3 has the number 272, A3
has the number 272,, then in column B each entry ...

I'm entering the following formula:
IF(COUNT(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2:D$160,""))=12,(PRODUCT(1+(IF(YEAR(SCGU!$C$2:$C$160)=$A9,SCGU!D$2:D$160,0))/100)-1)*100,"")
But am getting zero's instead of a blanks.  There are no contents in the
cells that it is referencing so ...

Is there any possibility to add new formats at "Number" tab in format cells
dialog box apart from bult-in formats .
I wanted to add Indian currency (Rs) symbol in currency format list.
Advanced Thanks,

I would like to sum more than one column on a given row that matches my
critera.
My data is set up with sales information by style/store like this:
     A              B             C            D