Hello, I'm using the =Yearfrac formula to calculate tenure. It returns the result in years and fractions of years; e.g., 5.5 yrs. Is there any way that the...

Sorry, I forgot to add that the tabs that do not appear in the "place in this document" list are charts. Can't one create hyperlinks to charts? Thanks.

Help Please! I'm not sure how this happened! I had various cells in my worksheet with validation functions/drop down menus. The reference lists are still...

I have just started learning how to use the Control Toolbar features to create components of a form...verrrrry cooool! I've figured out how to changes some...

Is there a way to prevent the selection of certain areas of a form, based on the value of an entry in one cell? Say, if B1 is less than 3, then I want the...

Hello..thanks for your help in this.. I have a workbook with many tabs (worksheets). The last is a spreadsheet (let's call it Tab#10) with each row drawing...

Is there a way, using formulas, or validation settings to restrict entry in one cell based on what is entered in other cells? Example. If values in Col A are...

(sorry, forgot to mention that this is about Pivot tables) Is there a way to prevent the creation of a new worksheet for a drill down, unless I want it to...

Hello, I am using the "=YEARFRAC(A1,B1,1)" formula to calculate tenure, where a1 is the hiredate and B1 is a cell containing the "=today()" formula. The...

I have a spread sheet with product prices. One column has old prices, another has new prices for some products. I need a function to look and see if there is...

Using excel 97, I use to be able to consolidate multiple workbooks into one workbook. The single workbook would have several sheets named after the workbooks...

Please help me write a formula that calculates the percent change when: The current result is 11% The prior result is -1.89% I am attempting to compare the...

I would like to express the percent difference change between 2 Ratios (expressed as percents), and the divisor is negative. for example: 18.40 /...

My worksheet has 14 charts that each reference the same company name (Title) and "Y" axis scaling. Can I reference a 'Name' in: Chart Options-...

I would like to enter values in a single cell and have it update each time the next consecutive empty cell in a cell range. For example, cell c5 is the data...

Please help, I hope there is a macro. Every time I enter a value in cell j29, I would like it to post to the next empty cell in range b139:b150. For...

How can I update the next consecutive empty cell in a range each time a value is entered in the same cell? For eample, I enter bank account balances in cell...

I am trending a bank account balance. Every time I enter the current value in cell c3, I would like it to update the value in the next empty cell in range...

Hello everyone, I have several colums (A to F) and hundreds or rows of data, strickly numbers. My rows start from the 19th row and can carry on for several...

I have been looking all over this site trying to find the answer and came up with nothing. I have a spread sheet that contains three columns: Date Cost ...