General

Automatically update a number when printed
Hi, I am trying to make a report with a report number at the top on excel. I am trying to figure out if I can type in a report number ie. 1001 and then everytime I print it, it updates so I dont have to change it to 1002, 1003 etc. Thanks for any suggestions ... 30 Apr 2010 06:12

SUMPRODUCT help with dates
I've got a list of dates dd/mm/yyyy in column A and a list of the numbers in column B which is related to the number of occurrences of something on each date listed. There are some gaps in the dates ie. it is not a continuous calendar list. What I need to do is count the total number of occurrences in April 20... 30 Apr 2010 10:36

formating of text file
i have problem while formating a text file into excel containing the below matter i want the "Bank reference", "Amount", "Information", "Customer details " and "bank clearing ID" in first row and the corresponding information below the corresponding headings. i have tried the use the custom in the filters a... 30 Apr 2010 05:07

Keyboard shortcut to flick from sheet to sheet in Excel?
Is there a keyboard short cut to flick between sheets in an Excel Workbook? E.g ALT & TAB for flicking between windows. ... 30 Apr 2010 01:52

Microsoft date and time picker control
The drop down calendars i have created continue to lose their formatting, whenever i close the document. When i re-open the document i am forced to go back into design mode, and resize the objects. Any ideas on how to fix this? ... 30 Apr 2010 00:47

Finding Unique records
I am using Excel 2003, I have a column of records which may duplicated. How can I extract the unique records to a list by using a formula not advance filtering Thanks -- eva cheng ... 30 Apr 2010 09:29

Excel VB application
I am working on a VB script with the goal to import data from a raw file (using userforms) into the spreadsheet. Is it possible to develop this in Excel AND create it as an EXE file? Thank you in advance for any help. NJ ... 30 Apr 2010 02:56

Count number of cells with "CAC"
I have a spreadsheet. One column has cells that have either A, CAC, or Other. How can I have Excel enter the number of each type of cell in ONE cell? -- Janet A. ... 29 Apr 2010 23:41

from "date" to "text"
Hi there, I have cells formatted as date (e.g. 11/9/03) and I'd like to change the format to text. But when I do it, the values change as well (e.g. "36472"). What can I do to avoid this? Thanks ... 30 Apr 2010 10:36

Help me find a circular reference cells located in unknown multita
When I open my xls file (2003) I keep getting a circular reference error message. I can't find the cell among the numerous sheets. ? Also I found it once & checked it using the precedents button & it looked alright but I keep getting the error. Is the circular reference error message always always right ? ... 29 Apr 2010 21:29