Can I link the worksheet tab name to a cell so that it automatically updates the tab name accordingly ? -- tenaj

I am trying to create a formula that will “count� a set of given numbers. I want to hand out numbered raffle tickets and have the ability to track how...

Hi, I want to omit the right part of a text string that starts with "(" and ends in ")" while returning the left part of the text string. I would have a cell...

I have a similar situation, but I am limited to not using macros as the spreadsheet is to be sent to customers and we don't want to force the customer to...

How do I make the last formula times by 1.5 then add all formulas...

I am trying to automatically add hours weekly from date. IE: 1/11/2008 hours 56.21 + 2.31 A1 B5 would like to automatically...

Hello all, who can help me: i have a data sheet with customer orders and production months. how can i make report in which i can count: a: orders per customer...

how can i make an event macro to update the value in C3 when a new value is entered in B3 without the need to click an update button. thanks, fryguy.

I have a Quantity column and a Unit Of Measure (UOM) column. I just want the the SUBTOTAL of the Quantity for a particular UOM but not all of them. Is there...

Can any body write a formula to spread the services charge. For example Annual charge is $12,000/ colum Jan to Dec monhtly 1000/- if start date is 16th Jan...

I have a formula calling for an average in a workbook that refers to a cell group that is sometimes not used. To keep the cells from averaging, I insert an...

Hi: I want to set up a hyperlink to a named range. I have to set up about 2000 hyperlinks and I need to have the hyperlink obtain the range name from a cell...

Hello How can I disable excel when copying from exp. Cell C4 and past special formulas into C5 that copy the same cell number exp C4 and not C5. p.s. –...

Is there a way to dynamicly link worksheets, such that new inserted lines in the source sheet are also added to the linked sheet?

I need help with the following: On Sheet 1, I have a list of about 100 employees: A= Last Name, B=First name, C= (blank). On sheet 2, I have a list of all...

I want to import the text from a cell into the criteria portion of a DSUM formula (=DSUM(database,"field",criteria) I am trying to do: =DSUM(DATABASE,...

Hi, I would like to enter "equal formulas" that would keep the value and format of the cells of origins from another worksheet, so that when I change a value...

What is : 5 or 13 characters, or 10 or 26 characters using digits 0 - 9 and letters A - F? Some say i should use the DEC2HEX formula, but i still don't know...

I am trying to use Excel for a grade book, but can not figure out how to get the average function to not count blank cells as zeros. The following function...

When creating an amortization schedule in Excel from scratch (i.e., not using the templates) can Excel differintiate between actual/360 amortization and...