The discussions

Adding the same action to every second line


hi 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...

8 replies Last reply on 15 Jan 2013 by

If, then formula


Hello, 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...

2 replies Last reply on 14 Jan 2013 by

Convert date into month name


Hello, suppose date has mention 1/1/09 and no month name then how to get the month name

Last reply on 14 Jan 2013 by

Copy excel 07 sheet to other & keep formulas?


Hello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...

Last reply on 13 Jan 2013 by

Excel - active x combobox, selecting sheets


Hi, 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 ...

5 replies Last reply on 12 Jan 2013 by

Many columns return into fewer columns.


Hello, 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...

15 replies Last reply on 8 Jan 2013 by

Msoffice 2010


Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.

1 reply Last reply on 6 Jan 2013 by

How to send emails


Hello, Please tell me how to get the blank form up to type & send an email on OE Configuration: iPhone / Safari 4.0 -- Dick McD...

3 replies Last reply on 31 Dec 2013 by

Short cut to merge cells


Hello, If there a short cut on the key board to merge cells in excel?

Last reply on 31 Dec 2013 by

How to convert a numeric value into eng. word


Hello, How to convert a numeric value into English words in Excel plz show that formula

Last reply on 22 Dec 2012 by

Formating date


Hello, 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. ...

9 replies Last reply on 19 Dec 2012 by

How to recover deleted .ost and .pst files


Hello friends, Outlook.pst file deleted. Now I am unable to configure outlook now.... Pls to do now...? How to recover dele...

Last reply on 14 Dec 2012 by
Zohaib R

Product key for ms publisher just downloaded


Hello, 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...

Last reply on 13 Dec 2012 by

Match barcode between 2 sheets


Hello, I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2...

Last reply on 13 Dec 2012 by

Deleting a progress bar from powerpoint presentation


Hello, I used the following method to add a progress bar to my PowerPoint presentation - now I don't like it.

Last reply on 10 Dec 2012 by

How can i eliminate #value in calculated cells


Hello, 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 ...

14 replies Last reply on 9 Dec 2012 by

Convert number into words in excel 2007


Hello, 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...

Last reply on 8 Dec 2012 by

Converting number into words (excel)


Dear 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 ...

Last reply on 5 Dec 2012 by

Help with vba


Hello, 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...

2 replies Last reply on 2 Dec 2012 by

Copy data into next empty cell in new sheet


Hello, 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...

15 replies Last reply on 1 Dec 2012 by

Auto filter problem


Hello, 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...

1 reply Last reply on 1 Dec 2012 by

Splitting list of names with formula - can you spot what's wrong


Hi 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 ...

4 replies Last reply on 30 Nov 2012 by
Zohaib R

If function in excel


Hello, my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"") I want in place of ..........

5 replies Last reply on 30 Nov 2012 by

Comparing two excel worksheets


Hello, 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 ...

Last reply on 28 Nov 2012 by

Cut/copy in vba


Hello, 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...

3 replies Last reply on 26 Nov 2012 by

Covnvert numbers to single words


Hello, 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...

3 replies Last reply on 23 Nov 2012 by

Wd my book reset password


Hello, 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...

24 replies Last reply on 21 Nov 2012 by

Compare and copy data from one column to another


Hello, 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 ...

4 replies Last reply on 20 Nov 2012 by
Zohaib R

Move item from 1 listbox to another listbox


Hello, 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...

2 replies Last reply on 18 Nov 2012 by

Excel formulaes


Hello, If there are two conditions, how to use the IF formulae. Regards

3 replies Last reply on 16 Nov 2012 by

Help on generating a number series using a macro


Hello, 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...

2 replies Last reply on 15 Nov 2012 by

Dynamic range and named ranges


Hi, 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...

8 replies Last reply on 13 Nov 2012 by

File conversion message


Hello, 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...

Last reply on 11 Nov 2012 by

Multiple data in one stacked column


Hello, 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...

3 replies Last reply on 7 Nov 2012 by
Zohaib R

Vba for deleting data in row but not formulas


Hello, 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...

7 replies Last reply on 31 Oct 2012 by

Automation of running excel macros


Hello, 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...

11 replies Last reply on 31 Oct 2012 by

Comparing two cell in different spreadsheets


Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...

5 replies Last reply on 29 Oct 2012 by

Comparing two lists of id numbers in excel


Hello, 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...

3 replies Last reply on 28 Oct 2012 by

Excel i want to sum only numeric values except alphabetic values


Hello, 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 ...

2 replies Last reply on 22 Oct 2012 by

Change cell color based on input in a range of cells


Hello 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...

2 replies Last reply on 22 Oct 2012 by

Nested if's


Hello, 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 ...

3 replies Last reply on 21 Oct 2012 by

Excel date format won't change


If 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...

Last reply on 19 Oct 2012 by

Excel,problem with if function


Hello, 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"...

4 replies Last reply on 17 Oct 2012 by

Forgot password


Hello, 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...

Last reply on 10 Oct 2012 by

Highlight cells based on drop down list selection


Good 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...

4 replies Last reply on 8 Oct 2012 by

Saving papers


Hello 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 ...

3 replies Last reply on 8 Oct 2012 by

Excel 2003 days before a certain date


Hello, 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 ...

2 replies Last reply on 5 Oct 2012 by

Add range if number is 1 to 10, 11-21,22-30 ...and so


Hi , 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...

6 replies Last reply on 4 Oct 2012 by

Insert line number for two columns document


Hello, 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...

Last reply on 3 Oct 2012 by

Create drop down list on certain cells


Good day, I wanted to create a drop down list from data in Sheet2. I have tried the following codes but the outcome seems to be incorrect. Instead...

6 replies Last reply on 1 Oct 2012 by
Results 1351 - 1400 out of a total of 2,608