dear all, can help me to clear my doubt. thanks alot 1) all data in bracket for cells and range must be string? cells 2) i do not understand if the row data...

Is there any way of placing re-curring values in footers for workbooks with multiple sheets. For example a version number or project title. I do not want to...

I've created a pivot table off of data from two other pivot tables. One pivot table has $millions by product by quarter, and the other pivot table has volumes...

I have Outlook 2003 and have set up contact subfolders, however when I synchronise using Active Sync, the only info that gets copied is that within the orignal...

HELLO, IN A WORKBOOK NAMED RECIPEC I ENTERED 5 SHEETS CONTAINING 5 DIFFERENT RECIPES IN EACH SHEET. EACH SHEET CONTAINED, COLUMN A; VOLUME OF...

Hi, Still struggling with the pivot tables. I copied and pasted a pivot table a few rows below my original table. I have now pasted 4 pivot tables -...

Guys, I have a spreadsheet with timestamps on col A, then Col B contains the values correspond to timestamps in ColA (Col C thru Col M are similar to Col B as...

This is what i currently use to auto protect sheet, but i want to add a password to this, (2468) so that the protection is password protected, but i do not...

How do I show percentages of a total on a line chart.

I have created a spreadsheet to keep track of stock in engineers vans. There are 7 sheets (one for each van) and a total sheet, which is an order form. Each...

hi, Two questions, i created my own invoice template. 1) How are invoice numbers automaticaly applied in ascending order above previous invoice.

I was hoping someone who has taken the MOUS test for Excel knows how to do the copy and fuze thing, if i spelling it right.

I want to run a regression comparing various columns to a single column. I want to be able to drag copy the format while keeping the first column the same. I...

My Workbook is 5 sheets, Ranging Between 100 to 600 rows and max of 13 columns each. It is 87 MB!

I have a summary sheet where the cells are automatically updated. I cannot create a chart with that information. The value is shown as zero when table data is...

I have an Excel document that links to several others. I want some links to update automatically but some to be manual. (I will still have the prompt...

I have found a function that I would like to be able to call from any spreadsheet in Excel. Currently, it only operates in a particular spreadsheet. Could...

I want to use check boxes so that the only information that will show is the information that is related to the checked item. ex check - bond 36" and I get...

I am struggling with a spreadsheet listing 50 presentation start and stop times and duration. I need a formula(s) so when a duration for a presentation...

I am doing a sln report and need to figure out how to put the sln information into a data table that shows straight- line depreciation and annual rate of...