I have a Start Date and an End Date, need to calculate the number of
months in between. Conditions: Start date <=15th includes the month,
End date >= 15th includes the month.
Examples: between 14-04-05 and 15-06-05: 3 months, between 16-04-05 and

Have an excel spreadsheet that has a record length of over a 1000+
characters.  Export it as a 'prn' extension, but when I look at the prn file
I find that it has been broken up into 3 segments.  This is not a problem
with wordwrap as that is turned off.  I have even verified in ...

Could you please help us with an excel query.
We have an excel file with fields in a random order.
The values in these fields have to be picked up and arranged one below the
other in a separate area. The values to be picked up always have a fixed

How do you associate adjacent cells in two columns so that when you sort
column B the value of the cell in column A follows the cell in column B?

Im importing data into my workbook from another excel sheet and in a colomn that data is in format xx.xx% so whit my regional parameter set to decimal on "," i replace everything,
at this point all seem ok but the data seem in stand by for something , the only way to make my data ...

In my spreadsheet ther is a field that has a dependent in an other
worksheet.
How can I find that.
the VB property 'dependents' will only return dependents on the same

I want to export data from excel by VBA and specify to use ',' as delimitor.
but I can only export a file rename to .csv. but when I open it, it still a
excel file, but not a text file.
How can I do it? Million thanks.

Is it possible to use forms to enter data in a worksheet?
Type of data is school marks for different subjects
can any one help
Khalil

I've been given a great opportunity at work to work on a system that all the
team leaders in my office will use as a sort of booking system for staff
leave and monitoring of staffing levels kind of thing.
Essentially say there are 5 teams with 10 people in each. Each team leader

cell range condition
--A---B---C---D---
1 X   P
2 X   P

Can someone help me how to insert row simultaneously in 2 or more
worksheets. If  I insert a row in one worksheet than the other worksheet
should also insert a row at the same location..
Thank you

I have a master file  and 4 workbooks where individuals enter info daily. I
need to update the master file workbook at the end of the day with the info
from the 4 individual notebooks.  How would I merge this data? I tried the
"shared workbooks" process but it wouldn't let me do ...

A                 B
1        X                 P
2        X                 P
3        X                 P

I Have A Column A,b, And C
A-----b--c
Jan-1 1  1
Jan-2 1  2

I have a 60k row worksheet that has three columns
company      customer     num_orders
Microsoft    Maryland     150
Symantec     Maryland     110