I know next to nothing about Excel. I am a graphic designer that needs
to be able to use a client Excel file (pulled from her Quick book
files) to create a catalogue. She admits to being computer illiterate
so she can't help me much here either.

I have written a quite simple VB script, and have got a section that I
would like to "tidy up"
If anybody could offer any suggestions they would be greatly
appreciated. The section of script is below:

I've encountered a problem which I can't solve in Excel. Can someone
please help with this?
I have 2 columns: A and B. A contains Year information, while column B
contains Losses, e.g.:

I have a number of Workbooks, each containing a single Worksheet.
Each WS contains similar data, i.e. uses the same column headings, but
is of variable length.
Column C in each WS is 'Location'(L1 - Lx).

I am being plagued by a problem which I cannot resolve, so I turn to
the Repository Of All Knowledge.....
I have a procedure in a VB application (not within Excel, but an
application I've created myself). It contains the following code:

Ive got a sheet which draws data in via a web query,
It then pull all the info and puts it into my sheet down the sheet in
rows....
Depending on which page of my site it draws it from.. depends where the

How can I protect a worksheet so that any user can do anything desired, except
change the formatting.  Using Excel 2002.
Thanks for any suggestions
Paul

Could someone please help with a macro or any other suggestion to format an
Excel sheet. Basically data is downloaded from a bank every week and the
size of the file can vary but the formatting is constant. That is each
record is 7 lines. So first record is line1-7, second record is ...

Our problem is  we have 6 XL spreadsheets that have a total of
140,000 records.  Each record has a control number and we need to
combine all the records or be able to look across all the records to
verify that they are within a certain time frame and also delete

I have made a user form in excel vba.  In it I have a multipage form
"multipage1" with two pages: "partsPage" and "inventoryPage."
When I run my script, the multipage tabs show up, however the contents
of the first page do not automatically show up (ie the first page looks

In excel I have created a user form, in which there is a label
("nonfincalcLabel").  I am trying to change the Caption of the label
based on a calculation using Vlookup when a change is made to one of
the comboboxes.  The lookup table range is defined as "nonfinRange" in

XL 2003
Below is a summary of sheet information
SHEET NAME     CELL    AMOUNT           LINK
Summary by deal    B32    4,000,000.00     B32

I have a spreadsheet where I want to count the occurences of a value
on a certain date and then use the resulting information in a chart.
My spreadsheet looks someting like this:
Column *A* contains the ID of the defect

The state government department where I work uses the following method
to calculate the percentage of Equal Employment Opportunity goals
achieved by other state agencies. I was wondering whether it is
possible to do this automatically in Excel.

Could someone please help with a macro or any other suggestion to format an
Excel sheet. Basically data is downloaded from a bank every week and the
size of the file can vary but the formatting is constant. That is each
record is 7 lines. So first record is line1-7, second record is ...