Hello, i am trying to set up a drop down list on a form that looks up a
column on a table and populates 10 linked cells from the row on the table
into the form with the drop down.
Example.

Using Excel 2003 and working in a large file with many tabs, is there a/any
search option that would automatically search all tabs and return results?  

I have made a pivot table. Works great. I have grouped a date field
(Year, Month, Days) and that works fine as well. I did not check the
'Auto starting at and ending at check boxed. When I look at the
spreadsheet my 'Day' field lists chronoligically. I am networked with

When I preview in Excel, I do not have - in lower left - "preview: page # of
#"-how do I get that to show

Here is a formula that I have working (it is long with lots of IFs and
repeated many times in my spreadsheet):
=IF(VLOOKUP($B10,'[Another
File.xls]R'!$B$2:$W$20,22,0)="Remediate",1,IF(VLOOKUP($B10,'[Another

when i am open workbook directly from icon or excel file i cant it is hiden
but i cant open it from tool bar open button(with path)

Here's what i am trying to accomplish.
On Sheet2 I have name of the person in column A, name of the queue he has
worked on in column B, time in column C and count in column D. It is
possible to have one name upto 11 times if that guy worked on all the

i have to calculate from a results sheet if there is more than a 10%
difference between two results (simple numeric results) calculated from
experimental data to determine wether or not to run a third sample. The
results are in column format and are typically numbers from eg: 0 ...

soI am trying to use the filled upright triangle in a VBA code. The VBA
editor does not show the symbol when I try to copy - paste it from the
windows character map. However I am able to copy it to an Excel sheet.
Also the code returned by the function for the triangle is 63. ...

I'm using a shared, protected workbook, with AutoFilter enabled, that allows
users to make edits in certain columns. When users edit the workbook and save
it, their AutoFilter settings are being saved as well, even when the Filter
settings box is unchecked in the Share Workbook ...

Oh Wise Ones,
         I have week ending dates in B6:F6. In F1 I have the formula
=LOOKUP(NOW(),B6:F6) which finds the correct date in D6. In G2 If I have
=OFFSET(D6,2,0) I get the value from D8- it works. Why doesn't

I need to create a lookup formula that will find all employees for a given
store location. My data is organized as follows:
Store #           Employee name
10                   Bob

Does anybody know if it is possible to create a lookup formula, which
returns all values if more than one?
For instance:
1  Tom

would anybody please tell me steps how to run this macro:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
On Error Resume Next

I would like to know, if is possible to combine sumproduct and subtotal, eg
=sumproduct(--(a2:a1000="rev")*(b2:b1000="jan");(subtotal(9,c2:c1000))
regards