Hi -- I was wondering if someone might be able to help me real quick :) I have a drop down list in Cells B4:B9 In Cell B7 they can choose between 2...

When I open my exel file .. this pop-up open .. circular reference warning one or more formulas contain a circular reference and may not calculate correctly....

I need a formula that says something to the effect of: IF the value in H=1 THEN transfer said row to sheet 2 IF the value in H=2 THEN transfer said row to...

Hello I need to paste data to a cell and keep the destination font and size, I know I can do the paste special and tell it to use destination settings, but...

Hi, I already have a worksheet which uses this calculation: =DATEDIF(B:B,H:H,"MD") In most cases it is in different rows like (B:B2, H:H2, "MD") but I want...

I am getting error on the add method on validation - Method Add of object Validation Failed - please help Me.Unprotect With Sheet1.Cells(1,...

Given range named "type" and "qty", i am trying to write a formula that will sum the "qty" of multiple "type"s together. I've...

I'm relaying this message for a friend who does not have Usenet access. He wants to use Excel as a database of members, the usual name, address, tel, email,...

I am making a bill of materials at work and have a master list I want to access from other sheets. The master list has all parts named and categorized, and...

Hi! Experts Is it Possible to Freeze the Row and Column both in one time in Excel 2003 thanks in Advance Hardeep Kanwar

I generate quiotations from a template and create a code name for each quotation in cells B7 to F7 as follows. TEMPLATE CODE XXX QUOTATION ...

Hi, I'm new to this, and not sure how to do this, I'd like to increment a field by one only if there's text in a particular cell. This is what I have, so...

Hi friends, i have a small query if you got little time. i have many numbers in an excel worksheet and i want to round them up only for decimal places and...

is it possible to locate a cell from coordinates such as 50, 75 or 100,98? I'd really like to be able to do this.

When I open my exel file .. this pop-up open .. circular reference warning one or more formulas contain a circular reference and may not calculate correctly....

I'm doing a project involving 10 cells, W10,W11,W12 which is a mathematical function, R10,R11,R12 is just plain text where in R10 would represent the cell...

I am given coordinates like 10,100 and 125,200 - is there a way to tell Excel to find the corresponding cell? Can I change the top row letters to numbers?

We have a worksheet that is maxed out to 65536 rows & also lots & lots of columns. No need for that we could use 1000 rows & 20 columns. How can we do this?...