how to compare two string values, if the string values r from inputbox
in VB
eg A=inputbox(" enter name1")
  B=inputbox("enter the name2")

Hi, I have data in sheet (see below)
ROW     A           E        F-----col
1          3080     G16     11
2            500     G16     12

Does anyone know of a way that I can have my sreadsheet update MLB
team records automatically?
Currently I'm punching the Wins and Losses column every day.  haha...a
little cumbersome.

I'm trying to write a macro that will select a certain range of cells.  The
problem is, new rows will be added to and subtracted from the worksheet.  But
i still want to be able to have this macro select a certain range, all in one
column and then clear the contents of that range ...

I have developed a spreadsheet in Excel 2003 which attaches to an analysis
services cube, using the analysis services add-in function "cubecellvalue"
plus appropriate mdx statements to build the sheet in the format required.
However in Excel 2007 this only works if I alter the ...

Hello- Is it possible to use VBA to loop through files and folders published
to a SharePoint server? Does VBA lose any functionality if files are
published to a SharePoint server? Thanks.
Filo

Can someone tell me a simple way to count the number of occurences of
a text string "abc" that are in adjacent columns in a row? In other
words, in row 2, starting in column "B" I have "abc". It appears again
in column C, and so forth. At some point, the contents of the cells in

Although I consider myself fairly good with Excel (I use 2003) I have
never used VBA.
I want to achieve something and feel a macro is the only way I can
achieve it.

I have two sheets in excel,
sheet1 is the source data, where the count of the data keep changes.
sheet2 is the pivot sheet, where pivot is allready created.
I need a excel macro code, to update my pivot every day, when i run macro.

I need to accomplish the following in a workbook:
-Force to run maximized and not allow form movement within the screen
-Disable Save and Save as
-Disable shortcut keys

Dear All Excel Experts
Is it possible to open text file in Excel and split using Text Import
Wizard as per Required column breaks
Please Suggest

I found this small macro which copies the data from my source worksheet
("Data4") Range("A1:C1000") to a different workbook ("C:\Destination.xls").
What it does is that it will look for the next empty row and then copy the
data into it. Now I would like to alter the macro so ...

Can I use IF EXISTS inside CASE block in SQL (MS SQL SERVER 2000)?
if yes, how??? if you have example, it will help.
Thanks
Mayur

I have the following in cell a2: AB/9999/08  The number of characters before
the first / can increase.  The number of characters between the slashes can
range from 1 - 5 characters.
I have used the following functions in my sheet to break down the info (with

I have two columns; A and B with names in them.  
I would like to compare the names in column A with column B and
If I find a match, highlight the name in cell B.
And then go down one cell in column A and repeat