I have a workbook that has 2 worksheets.  The first worksheet called
"pricelist" is a list of items and prices in multiple columns, and the first
column is a unique identifier.  The second worksheet is "invoice".  I want to
be able to type in the unique identifier in the ...

I am trying to set up a formula each time the data changes in column A
without having to do it manually.
The formula would be using two other columns of data for the rows involved
with the same company.

I use fill color to highlight a cell. The color does not show on the screen.
It only shows up in print preview.

I can not find the "list" or "create a list" command from the data dropdown
menu on my toolbar. How can i find it?

I have a spreadsheet that has conditional formatting where as when you press
enter it goes into a specific cell (throughout the whole spreadsheet). I have
some people that it works with and others that it won't work with. I have
updated the ones that don't work with the latest ...

i have a spreadsheet on jobs estimated.  i have columns a to g to input
data into.  in columns h ai i have formulas for this data.  i have
formulas in 2000 rows (and i need this many rows).  in column g, if the
job has been closed, we put an "x" in that column.  i would like to

I would like to create a form that would be visible and remain open by
default every time I open my work book. Amongst other controls, I want a
combo box from where I can choose another work sheet and a command button to
open the sheet I selected. Can anybody explain to me how ...

Lets's day A1 has the letter B in it and A2 has the number 3 in it.
Is it possible to have a formula display the contents of B3 using
references to cells A1 and A2?
Thanx

i am linking cells in a workbook to another workbook.  the link gives me the
$c$45 format which does not allow me to copy to other cells that are
contiguous.
how and where do you change the format so it gives you c45 as the reference

Hi--
I tried to use the following:
=HLOOKUP((MAX(G6:J6)),G6:J6,2:2,FALSE)
What I want to do is pull the highest value in range G6:J6 and have that be

I'm Looking for a formula that will allow me to select a starting cell (B49),
then find and select the second to last active cell in that row. I have a
living spread sheet that grows and shrinks based on user input and want a
formula to calculate the days between the start (B49) ...

I have a spreadsheet that I want to insert a page break after each row.  Is
there a way to do this faster than just highlighting each row and going to
Insert -  Page Break?  I need to do this for about 100 rows.

I need some good information on using different formulas, specifically
"if,then". I have used them in past and generally understand the logic, but
do not know the exact structuring of these formulas.

Say if I want to do a search and replace:  for example "Marriages -
Public License" and I want to replace the word "Marriages" with the
same word only in red and bold, can I do it without the whole thing
being red and bold?  I tried to do it but the whole thing turns red and

I have a worksheet that has a lot of information in it. I am trying to find a
formula that will look up logged hours based on 2 criteria. First i am
looking for a specific agent that has an ID.(9876) Then i want to find a
specific date (9/16/2006). I then want it to return the ...