I have an Excel spreadsheet where some of the rows are not visible as they are auto-filtered out. I have a column of 20 cells from another sheet that I want...

I am trying to use countif to count the number of times within a month that my fire department has a call, meeting, truck check. I have the dates in...

the following code is supposed to print sheet2 if there is a sheet two, then delete sheet2. So the first part checks if there is content on sheet2("A1") and...

hi there How do I output to the same position in a Text file everytime? I want to dump data for a given Date so I'd like to put it in the same row for that...

Any Key strokes / mouse instructions do not get any response from the software

I have a column of dates F6:F148, the dates have been entered in the following formats all entered as text "21.01.2009","21.1.2009","21 Jan 09" & "21 Jan...

I have an XML file with a few elements such as employee number, employee name etc. I have added the xml file into an Excel spreadsheat as an XML Source. ...

My wife had copied & pasted some bullet-point text from Word into a single cell in Excel 2003, 9 or 10 points, roughly 1,500 characters overall. She then...

This scenario is a bit tricky, but I hope someone can figure it out. On worksheets 2, 3, and 4, I have lists of tasks which, for the purposes of this...

I left an Excel document open, not realizing Windows update would be restarting my computer while I was gone. When I got back, my file had reopened...

I am having a compability issue with going back to 97-2003 for my palm pilot Is there a way to find out what cell is he culprit so I can look and make...

I am looking for a way to use script to say if there is data in A place =B1+C1 in D of the same row.

How can I control the name of a new workbook opened from template? Such as using MyWorkbook.xlt to open MyWorkBookToday.xls instead of...

Is it possible to hide the worksheets within a workbook, and still have the workbook calculate formulas based off of the hidden worksheets. The reason i ask...

I am typing text in a cell and then I get to a point and it just turns it to a bunch of # signs...##################### Why is that happening??? Thanks in...

I have upgraded from Excel 2003 to Excel 2007 and have a question about the AutoFilter function. In 2003, when you filtered a column, you would choose from...

okay, so I am looking at a spreadsheet (not created by me) and I need to pull out some information in the spreadhseet. The problem is they put all the...

We have about 10 people sharing a workbook which involves a column for notes everyone can track / edit. Periodically, when you open the workbook, some of...

I am trying to perform a ascending sort and keep getting an error ... this operation requires the merged cells to be identically sized. I have a table 3 top...

Excel 2007 all MS updates Is it possible to delete rows without ANY data automatically? Currently, I have a 2000+ row spreadsheet that has 250+ blank rows. ...