The discussions
Outlook - "unknown error" ox800ccc81
SolvedHello, re https://ccm.net/faq/5929-outlook-unknown-error-ox800ccc81 would you have a fix for this with Outlook Express? thanks Configuration:...
Adding the same action to every second line
Solvedhi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...
If, then formula
SolvedHello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...
Convert date into month name
Solved/ClosedHello, suppose date has mention 1/1/09 and no month name then how to get the month name
Copy excel 07 sheet to other & keep formulas?
Solved/ClosedHello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...
Excel - active x combobox, selecting sheets
SolvedHi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...
Many columns return into fewer columns.
SolvedHello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns. Howeve...
How to send emails
SolvedHello, Please tell me how to get the blank form up to type & send an email on OE Configuration: iPhone / Safari 4.0 -- Dick McD...
Short cut to merge cells
Solved/ClosedHello, If there a short cut on the key board to merge cells in excel?
How to convert a numeric value into eng. word
Solved/ClosedHello, How to convert a numeric value into English words in Excel plz show that formula
Formating date
SolvedHello, I have date in a cell now i want to see the next cell red color if the next cell is not filled up by the next 10 days from 1st cells date. ...
How to recover deleted .ost and .pst files
Solved/ClosedHello friends, Outlook.pst file deleted. Now I am unable to configure outlook now.... Pls suggest...how to do now...? How to recover dele...
Product key for ms publisher just downloaded
Solved/ClosedHello, Configuration: Windows XP / Chrome 23.0.1271.95 how do I get the product key after down loading MS Publisher from your web site(X16-32...
Match barcode between 2 sheets
Solved/ClosedHello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...
Deleting a progress bar from powerpoint presentation
Solved/ClosedHello, I used the following method to add a progress bar to my PowerPoint presentation - now I don't like it. https://ccm.net/faq/937-insert-pr...
How can i eliminate #value in calculated cells
SolvedHello, I am building an Excel calculation sheet for cookeries for christmas. In cell H$7 I have the input for how many times I would like to ...
Convert number into words in excel 2007
Solved/ClosedHello, i'm trying to convert number into words in excel 2007. i've written coding in VB module. But I don't know how to get it in my function list...
Converting number into words (excel)
Solved/ClosedDear friend, Pl.provide me a formulla which can translate currency number into words i.e. 12,34,56,78,910.91 into Twelve Arab,Thirty Four ...
Help with vba
SolvedHello, I'm trying to program a macro in Excell 2010. What I need it to do is look in a Range for the NotEmptyCells and change their property fro...
Copy data into next empty cell in new sheet
SolvedHello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell shoul...
Auto filter problem
SolvedHello, when i am filtering any item for adding value in that item, it will gets filter but the blank cell coming at last is much further behind th...
Splitting list of names with formula - can you spot what's wrong
SolvedHi everyone, I have a list of 1805 names which are gathered in a single column. These names range in length and "format" (e.g. John Smith, John C ...
If function in excel
SolvedHello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of ..........
Comparing two excel worksheets
Solved/ClosedHello, I am trying to find an easy way to compare and extract data from two excel worksheets. This is the scenario.. I have an excel worksheet ...
Cut/copy in vba
SolvedHello, I am fairly new to Macros but I am trying to write vba code in Excel 2003 version that will enable me to cut/copy a table from one worksh...
Covnvert numbers to single words
SolvedHello, In excel 2010 i would like to convert numers to words i.e. 123.00 (one two three point zero zero) or 1006235.23 (one zero zero six two thre...
Wd my book reset password
SolvedHello, We recently had an employee leave our company. Her files are backed-up on a WD my book essential external hard drive. The program to resto...
Compare and copy data from one column to another
SolvedHello, I'm trying to compare column A in Sheet 1 with column A in Sheet 2, then copy corresponding values in column N from sheet 1 to column N in ...
Move item from 1 listbox to another listbox
SolvedHello, need help on an excel listbox using vba. i've got 2 listboxes on a form. listbox1 is being populated from an excel sheet. i need to move...
Help on generating a number series using a macro
SolvedHello, I would appreciate your help with a macro I am trying to create in Excel 2010 my Data is as below Column1 Column2 Column3 (Name) (start nu...
Dynamic range and named ranges
SolvedHi, I have a list of students in Sheet 1,2,3 where being updated regularly. They are named ranges "Boys" & "Girls" in Column A & B respectively. In...
File conversion message
Solved/ClosedHello, I use Microsoft Outlook 2003 for my emails. I cannot open any attachment that comes as a Microsoft Word document. I get the message "File Con...
Multiple data in one stacked column
SolvedHello, i am trying to plot a column chart and I want multiple data to appear in one column. example: I am plotting all the submitted inspections...
Vba for deleting data in row but not formulas
SolvedHello, I am working on a spreadsheet where I have to copy data over to a new sheet, once the data is copied I want to delete the data in the row f...
Automation of running excel macros
SolvedHello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automati...
Comparing two cell in different spreadsheets
SolvedHello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...
Comparing two lists of id numbers in excel
SolvedHello, thanks in advance for reading this. I have a list of student ID numbers which I would like to use as a student check-in. Column A is the num...
Excel i want to sum only numeric values except alphabetic values
SolvedHello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total ...
Change cell color based on input in a range of cells
SolvedHello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using cond...
Nested if's
SolvedHello, I would appreciate if somebody could help me in solving this problem. I am trying to make exel decide in an scheduled soccer games which team ...
Excel date format won't change
Solved/ClosedIf I enter a date into a cell in my Excel spreadsheet using the shortcut (CTRL+;), I can no longer change the formatting (right-click, format cell). T...
Excel,problem with if function
SolvedHello, i am working with excell with follwing formula- =IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33=AB,"E"...
Forgot password
Solved/ClosedHello, I am alin i have been using kaksoft folder lock protect the folder...but i could not use the folder so that i forgot the password so how wi...
Highlight cells based on drop down list selection
SolvedGood day, I would like to have a row highlighted in color based on the drop down list selection. I have inserted the following in Worksheet but I e...
Saving papers
SolvedHello Everyone, I hope someone could help... I have list of Check Numbers on Column A and Their Amount on Column B and it runs on almost a ...
Excel 2003 days before a certain date
SolvedHello, I am making a spreadsheet which has, for example, a given date of 1/1/2012. When I enter that number into cells A1, I want it to return ...
Add range if number is 1 to 10, 11-21,22-30 ...and so
SolvedHi , I am new to this forum. Looking for small help.. if 1 to 10 is in column A i want to add the numbers which are column B. A B 1 34...
Insert line number for two columns document
Solved/ClosedHello, I have a problem to do a process of line numbering in MS Office 2007 Word Document. I have a document, it has 2 columns and I have to inser...
