Office Software Forum - solved topics
- Excel (9,803)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
copy Excel 07 sheet to other & keep formulas? Solved/Closed
Hello, 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 Solved/Closed
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 ...
-
Many Columns return into fewer columns. Solved/Closed
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...
-
MSOffice 2010 Solved/Closed
Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.
-
how to send emails Solved/Closed
Hello, Please tell me how to get the blank form up to type & send an email on OE Configuration: iPhone / Safari 4.0
-
Short cut to merge cells Solved/Closed
Hello, If there a short cut on the key board to merge cells in excel?
-
How to convert a numeric value into eng. word Solved/Closed
Hello, How to convert a numeric value into English words in Excel plz show that formula
-
Formating Date Solved/Closed
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. ...
-
How to recover deleted .ost and .pst files Solved/Closed
Hello 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/Closed
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...
-
Match barcode between 2 sheets Solved/Closed
Hello, 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/Closed
Hello, 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 Solved/Closed
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 ...
-
Convert number into words in excel 2007 Solved/Closed
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...
-
converting number into words (Excel) Solved/Closed
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 ...
-
Help with VBA Solved/Closed
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...
-
Copy data into next empty cell in new sheet Solved/Closed
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...
-
Auto filter problem Solved/Closed
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...
-
Splitting list of names with formula - can you spot what's wrong Solved/Closed
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 ...
-
IF FUNCTION in excel Solved/Closed
Hello, 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/Closed
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 ...
-
Cut/Copy in VBA Solved/Closed
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...
-
Covnvert numbers to single words Solved/Closed
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...
-
WD My Book reset password Solved
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...
-
Compare and copy data from one column to another Solved/Closed
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 ...
-
move item from 1 listbox to another listbox Solved/Closed
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...
-
excel formulaes Solved/Closed
Hello, If there are two conditions, how to use the IF formulae. Regards
-
Help on generating a number series using a macro Solved/Closed
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...
-
dynamic range and named ranges Solved/Closed
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...
-
file conversion message Solved/Closed
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...
-
multiple data in one stacked column Solved/Closed
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...
-
VBA for deleting data in row but not formulas Solved/Closed
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...
-
Automation of running excel macros Solved/Closed
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...
-
Comparing two cell in different spreadsheets Solved/Closed
Hello, I'm currently struggling to do the following: Spreadsheet A Sheet1 Name Expenses Date ...
-
Comparing Two Lists of ID Numbers in Excel Solved/Closed
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...
-
excel i want to sum only numeric values except alphabetic values Solved/Closed
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 ...
-
change cell color based on input in a range of cells Solved/Closed
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...
-
Nested if's Solved/Closed
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 ...
-
Excel date format won't change Solved/Closed
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...
-
excel,problem with if function Solved/Closed
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"...
-
forgot password Solved/Closed
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...
-
Highlight Cells Based on Drop Down List Selection Solved/Closed
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...
-
Saving Papers Solved/Closed
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 ...
-
Excel 2003 days before a certain date Solved/Closed
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 ...
-
Add range if number is 1 to 10, 11-21,22-30 ...and so Solved/Closed
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...
-
Insert Line Number for Two Columns Document Solved/Closed
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...
-
Create drop down list on certain cells Solved/Closed
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...
-
acrobat reader Solved/Closed
Hello, pls send me acrobat software. Configuration: Windows XP / Internet Explorer 6.0
-
Macro for finding dates Solved/Closed
Hi guys, Is there a macro that would give me the the cells in a column in which there are dates between 2012 and 2013. It can be easily filtered b...
-
Please provide the key for Microsoft Office P Solved/Closed
Hello, Please provide the key for Microsoft Office Publisher 2010 Configuration: Windows 7 / Chrome 20.0.1123.4