software

I have set up many files using the Workbook_Open code when a file is

I have a different sheet for each person in an Excel workbook, and I have
named them in the format: quot;Last Name, Firstquot;. Is there a way to arrange them

I tried converting a spreadsheet with a mix of Thai characters and
English to a unicode text files. I had work on an assumption that the

First of all a happy happy Holiday greetings from a grateful reader here.
You guys are the best.....I'm wondering if it is possible, if Excel can

How can I hide a series (or several series) in a legend, but still have the
data series graphed on a chart? Thanks for your help

When I import data to Excel, 1 column is a for hyperlink to html file. But I
have to double click each one, then click somewhere else, then click back on

Whats the significance of $ symbol in the above formula. What action it
performs.

At this site, you guys helped me out on some code to automatically name tabs
from an entry on the worksheets. Works great, thanks!

When I use random number generator, is there a way to make specific random
numbers remain the same based on data in other cells?

I opened the Personal Macro Workbook (by Unhide it) so i can delete the
macros that I don't need. Now, i want to create new macro, the computer kept

I am looking to populate a list box on a userform.

I have a range of numbers that I need Excel to perform a function based on
the conditions. The formula I wrote works fine for what I need it to do, but

Hi Guys,

I want to filter rows on the basis of color of the cells.Excel provides
'Filter Function' but it filters rows, only on the basis of value in that

Hello,

Hi recently had to install Windows 97 on my computer for my new employer. I
had to delete Windows 2000 to do it. Anyway, everytime I go to open an

This sounds awfully basic, but for the life of me, I can't figure out

I need Excell to execute the following:
If B5 is = zero then C5 is = to E5In cell C5, enter

Is there a formula that I can use to see if numbers (some are Alphanumeric)
match. ie

I need to do the calculation according to the availability of data as
following example.