I have a spreadsheet which I am using as a master document from which I want
to generate many copies of a single worksheet (I only want that particular
worksheet to appear in the copies, not all three worksheets that exist in the
master). The master spreadsheet contains a ...

Can someone help me decipher the code I need to use below?  I don't
understand how to customize it.  I am a finance manager and do not have
any coding experience.  My spreadsheet basically looks like this:
                          Jan           Feb         Mar

I inserted an object "Calender Control 11.0" and I'd like to delete it from
my spreadsheet.  How do I do this?

I have a worksheet with 98 columns and over 500 rows.  I am looking for an
automated way to create another worksheet (in the same workbook) that has 42
(of the 98) columns and a subset of the 500+ rows, based on certain criteria.
I don’t think creating a PivotTable is the answer ...

In Excel 2003, I need to simulate a "login/logout" function within Excel
document, without requiring user intervention, preferably through
Login/password pop-up screen. Based on the login information (match of
user/password with predefined values within the workbook), content of

I'm trying to sum up values in a table based on a subtraction calculation on
the row heading and column heading of a table.
For example:
If the data is something like

Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates.  This would be used with one address ...

I have just opened a spreadsheet and tried changing data in my C Column but
noticed the results of the SUM formula did not change. I pressed recalculate
F9 and still no change. Suspect some update has broken the SUM functionality
- looks pretty serious to me. Can anyone enlighten ...

I have a spreadsheet with (random - i.e. no pattern) dates in Col A and the
relevant total mileage of a car in Col B.
Calculating the average overall annual mileage of the car is easy (total
mileage / no of days since purchase * 365).

Hi. Spreadsheet A in Workbook 2 has various columns which match the cell
values in Spreadsheet H of Workbook 1.
Column O is a control list of Suppliers names so spelling etc is exact
throughout.

Hellow friend,
There is a limitation of 7 (Seven) levels for Nested function ( IF function)
in Microsoft Excel .
Will you please let me know, how to increase this nesting limit of ‘IF’

Hi - can a spreadsheet name within a workbook be told to reflect a cell
value please?
I have a list of suppliers in a column on a control sheet. this list is
dynamic due to adding new suppliers and i would like a spreadsheet for each

I have recieved a comma deleted file which I need to save as an excel
doc. Having opened it with excel all the data in shown in the first
column. There are several columns of info.
I have tried to format the text to no avail.

i am trying to figure out two formula's
1. a formula to place the number of rows in a range into another cell. ie. ?
rows in range A38:C97 to be put into cell A5...
2. as above but how many cells instead of rows, but.. the cells can be both