Hi, I have the text "Enter date here" in cell C1. A user needs to override this with a date before clickling a button on the sheet to run a macro. How can I...

I'm using Excel 2003. I have a workbook with over 200 worksheets. (Each tab named for an individual in a group.) I'm trying to set up a summary sheet which...

Running Office 2003 student and teacher edition. I can open Excel, use the worksheet, and save. If I re-open the worksheet, I have a blank grey screen, and...

Hi When formatting the same type of data frequently, I design a template with three sheets, the first to paste the raw data, the second a temporary for...

I've made a custom header / footer how do I get it to print on each page of a work book without having to re-create on each page -- Stephen Connolly

I am making a line graph (chart) with 31 numbers. However, the graph plots only the most recent (lowest from the column) 21 numbers. How can I ensure the...

I am trying to find a way to "data-sort" in real time. I have a league table set up for my football team which lists team name, games played, games won, games...

I have a spreadsheet created from Project which lists all tasks, the associated resources, hours etc. I need to take the spreadsheet and generate a time...

can not open a specific excel file, too many different cell formats message appears on my screen. the file contians about 85 work sheets

Hej med jer, Er der nogen af jer der ved hvor jeg kan finde en template til en lønseddel?

Hi When you need to view totals for various groups, then for such cases I sometimes use SUBTOTAL function and autofilter. P.e. header row is row 3, and you...

What formula should I use to calculate vacation cost over 10 years at 3% inflation.

I want to have a macro that will add a comment box to all the cells that the interior color index = 6. Anyone have any ideas? TIA, Kim

I have data on disks that are in SuperCalc that I would like to convert to Excel, but I don't know how to do that.

I am trying to copy and paste selected rows from varios workbooks into one master workbook. When I copy and paste a range of cells I find the rows collapse and...

Hi Does the value in spinbutton properties have to be numeric or can it be a day eg mon tues wed etc if so how do I dio this Thanks tina

I want to insert carriage return in the middle of a text formula to force the resulting text to wrap at a specific point. It would be the same thing...

I want to calculate time as per my sheet have data like - a1 a2 a3 a4 a5 a6 a7 Time In ...

Can someone gives me help with this excellent code? Print dialog shows on sheet numer 5, and I want to stay at sheet number 1, because command button is sheet...

Is there any way in which I could arrive at a trend on reducing percentage Starting with 13% for 2000 & Dropping to 8% for 10000 So basically, when I put any...