Hope all is well.
I have an excel that has a formula exceuted when pressing on a button-like
symbol. Is it possible to find out, view the actual formula inside this
button? It's not behaving as it should & I'd like to modify it.

I'm using a datefeed that needs some attention to before uploading.
When the feed comes the one field is in HTML i need to put "!!<" at the
start of the Field and ">!!" at the end of the field so it reads HTML
when uploaded.. So i need to add this to one field with 250 records

I an not very computer literate so I will need step by step instructions on
how to create a list, then alphabetize it.  Any help would be greatly
appreciated.

Every time I make a new bill i would like for the invoice number to change
automatically. What can i do to make this possible?

I have two ranges of cells named range1 and range2 but I am unable to add
them together as =sum(range1+range2)  gives me an error
Any help would be appreciated.
Mike

In one cell in the SS, I have a comma delineated group of numbers
eg 23,4,5,36,2
Is it possible to determine that another cells contents resides
within this number set?

Can anyone tell me the math behind these Excel functions using the
parameters listed?  I am writing some software and I am unable to use
Excel to calculate these but I still need the same result.
Thanks for the help.

I would like to convert a date (eg; 05/01/2005) to text so that in one
column it shows 05 as text, in the next column Jan as text and in a 3rd
column 2005 as text.
Can anyone help me with this

Just a quick prob someone might be able to help with. I've got a master file
linked to numerous subfiles which extracts data to form a matrix.
Essentially it looks for a matching date in the subfile and returns the
appropriate entry using:

I have a summary sheet that pulls info from approx 10 other excel
files.
In one column of the summary sheet, the links perform just fine.  Each
cell in this column is the sum of an entire column in another

I can't seem to find the 'Draw" menu in Excel VBA...
Am I correct in assuming that there is none?
And that the Frame is the only way to group stuff on a Form??
thanks

Ok, trying to build a script so that I can automatically as much as I
can import other excel files over the local //network/ to my local PC,
and I got it to work, if I specify the file name directly, but since
the file names changes on a daily basis, I wanted to have a pop-up box

Is there a way to protect your vba code in an excel app?
thanks - tmb

I have put together a simple spreadsheet that contains some visual basic
(ie: pop up calendar).  It all works fine at home (where I created it).
Sent it to my workplace, tried to open it and got an error message telling
me that Personal.xls couldn't be found. I can close out of ...

I have two customer lists with a names and customer numbers.  They are
currenlty in the same spreadsheet.  I'd like to create a list of
duplicate customers who have the same customer number.  One list has
over 10,000 customers.  The other list only has a few hundred.