I am new to macros, not to excel.  I have a recap worksheet that gathers
information from various password protected worksheets.  When I update the
recap worksheet, I have to enter each password every time before the data is
updated.  How do I automatically have the passwords ...

Dear Experts,
Can you set up excel to capture data at particular times?
Scenario:
University students sit exams and their results are recorded in excel.  So

Find and Delete
I have asked this before, the answer I believe unfortunately was wrong after
3 hours of work
I have 7436 Numbers in Col A some of which are duplicated

I am having a problem setting up a formula for a spreadsheet. Column A of the
sheet contains several rows of names, columns B-AF are for days of the month
and contain different letters (A, T, L, E, R, B, M, N) each letter is equal
to a value of either 1, 0.5 or 3.  I am trying to ...

 I am attempting to sort data based on the values in three columns.
I have Column D, I, and N, which represent species codes of fish.  The
three columns represent different sites (1, 2, 3).  I need to line up
the species codes but not every code in (for instance) site one is

I have a worksheet with 6 columns, 4 of which receive data via an indirect
function fron another open worksheet (i don't know the formula for indirect
function with closed worksheet!).The other 2 columns are manual input and not
referenced.

can anyone helpme...figure out a formula that counts the "bussiness days"
excluding weekends and holidays?....is anything like this available in
excel?...thanks in advance
ps

I am using a Form Spinner Control, and I want the maximum number to be the
(variable) number in a particular cell, but I can't seem to find any way of
setting a maximum number other than actually manually typing a specific
number into the 'Format Control' dialogue box.

I have 2 worksheets.  Column A in both is SSN.  I want to compare the data in
column L of worksheet 1 to column H of worksheet 2.  I basically need a
formula that will compare the data in worksheet 1 column L to worksheet 2
column H, and correspond to the correct SSN.  The values ...

I need to have the content of a cell highlight and bold if the product/sum is
+/- 10% of the target number.

Need help with a formula.
Want to sum the total of a range of cells, then if it is less then a
specific number the value should be "Fail", if greater then that number then
value should be "Pass"

I previously only needed a horizontal split in my worksheet, now I need the
vertical, but it is missing.  How can I get it back?

i need to make a formula that will show a commission rate of 5% sales over
15,000 with a 3% sales commission for lesser sales.  Could someone please
help me with this.

I can not remember how to make a specific cell within a spreadsheet to make
it very easily identifiable.

I have searched through the archives and threads and thought I found the
solution but to no success.
I want to find "DC Office" across cells AW2:BK2, if one of those cells
contains that text I need it to populate BL2 with "Washington, DC"