I have a vlookup table and want to create a rule in the data entry sheet
(not vlookup source data) that when a Product is selected from the vlookup
dropbox (Price is included via vlkup), the user is required to enter data
into a non-vlookup cell on the same row but different ...

I am trying to set up a month-to-month data sheet.  Can I set it up so that
the accumulated total from one month carries over to the next?

I have a spreadsheet that contains macros.  When I go to windows
explorer and double click the spreadsheet file, depending on the
current state of excel, the spreadsheet is gains or does not gain
focus.  If excel is not running or is minimized, the spreadsheet comes

how do i find nonblank filters in excel when working with spreadsheets

I have an inventory spreadsheet with 125 tabs.  The tabs are numbered
1 through 125.  The are identical except for the data below the column
headings.  If I wanted to put a formula in H5 on every tab, can it be
done other than manually opening every tab and typing it?

I've done this before, but can't seem to revreate it.
I want t drop-down list that referrences my own data.
For example I want the drop-down to be in C4, and the data is in
"$O$2:$O$73"

i have 2 problem.
1)  iam using a vlookup formula, but when there is no value in the cell the
cell shows the ( 0 for date and jan for month) 0-jan. but i want to be 0
instead of the 0-jan, why its happening,

I have a excel add-in installed on my system. When i try to work on the
add-in i get the following error "activex component cant create object".
Please help on this.

Posted to microsoft.public.excel, microsoft.public.excel.programming
Copy from windows clipboard in VBA
Thank you each for even your time reading this whether or not you reply.
It was hard to shorten this. I want to paste [Notepad] text to a single

Greetings everyone
I\'m trying to use wild cards inside an array.
Column F contains error codes 1.1, 1.2. 1.3 etc
Column I contains dates in April; 2.04.07, 5.04.07 etc...

I put a lot of math formulas into PowerPoint from Excel because Excel
has better layout features (using the cells). Problem is both Word and
PP have quick access toolbar commands for sub- and superscript, but
Excel doesn't.

Really embarased to ask, but:
Using an old copy of Excel "97"
Where do I find the list of Functions that are available (on what pull-down
menu), and how do I display them, please ?  Just can't seem to find them on

what would the formula be for 1846
1846                           
1845    7    13    15    22    30    32    5
1844    5    13    21    25    31    33    3

Forgive the O.T. lean but this is the only repository I know for the
specific titans that I wish to ask - and it's in the interest of saving
some of you guy's/gal's [future] time due to my haphazardly keeping up.
<g>

I need a macro or something that automatically insert the file name of the
excel file into the header or footer, does not matter which, i dont need the
directory path.
Either this or  automatically insert into the header or footer the contents