Office Software Forum - solved topics
- Excel (9,871)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
high and lower case text in the "if" functions Solved/Closed
Hello, I am working on a basketball spreadsheet. I am keep track of the home teams straight up(SU) wins. Home teams are capitalized(higher case), ...
-
Populate data in Excel according with n Solved/Closed
Hello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...
-
Conditional formatting using dates in different cells Solved/Closed
Hello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...
-
Problem for creating MS word on tablet Solved/Closed
Hello, I find very difficult downloading MS word, Excel and VZO video chat.
-
snding sms from excel sheet Solved/Closed
Hello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...
-
Dropdown lists in excel 2007 Solved/Closed
Hello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...
-
What is the Most Appropropriate Way to Recover PST File Solved/Closed
Hello i m using MS Outlook my PST file was oversized which got corrupted after subsequent retrieval. Tell me what to use?? Inbox PST repair tool...
-
converting date to year and month text Solved/Closed
Hello, I have a cell date entered as 8-Nov. Excel reads this date as 11/8/2010. The cell entry actually means Nov, 2008. I need to change that ...
-
Using Vlookup to return insted of 00/01/1900 Solved/Closed
Hello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...
-
Formula for Between to Dates Solved/Closed
Hello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...
-
Stop #N/A appearing after a vlookup Solved/Closed
Hello, I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value. Anyway I can make it ap...
-
one cell will turn green when the two other cells match Solved/Closed
Hello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...
-
=month(d2) Solved/Closed
Hello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...
-
Macro to email picking up email address in one cell using lookup Solved/Closed
Hi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...
-
returning value from column b in column c, in a cell ajacent to Solved/Closed
Hello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...
-
Recovery my work and restart microsoft excel Solved/Closed
Hello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...
-
compare data in seperate columns to find likely matches Solved/Closed
Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...
-
No tool bars or address bar on my browser Solved/Closed
Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...
-
Code for macro that conditionally inserts rows Solved/Closed
Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...
-
excel for mac opens all files on desktop Solved/Closed
Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...
-
Can't open Excel file Solved/Closed
Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...
-
IF statement errors and using multiple IF statements. Solved/Closed
Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...
-
merging more cells into one cell Solved/Closed
Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...
-
how can calculate days between twodates Solved/Closed
Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...
-
Transferring data from one sheet to another Solved/Closed
Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...
-
Time calculations on a 24-hr clock Solved/Closed
Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...
-
Auto notify or mail when Excel sheet updated. Solved/Closed
Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...
-
I have a problem with Microsoft Office starter? Solved/Closed
Hello, I would respctfully ask anyone to help me with this problem which is: someday I have open the Microsoft Office starter and then I have been ...
-
Excel 2007 resetting cells to Date format Solved/Closed
Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...
-
conditional Formatting Solved/Closed
Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...
-
Simply cannot find an answer Solved/Closed
Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...
-
VB issue with delete rows with specific values Solved/Closed
Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...
-
Macro Help: Copy Data from a Range of Sheets to a Master Sheet Solved/Closed
Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...
-
Tagalog Solved/Closed
Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...
-
How to convert number into text in Excel Solved/Closed
Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"
-
Adding a new entry into a list - Excel 2007 Solved/Closed
Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...
-
VLOOKUP range question Solved/Closed
Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...
-
Outlook - "Unknown Error" Ox800CCC81 Solved/Closed
Hello, 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 Solved/Closed
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...
-
If, Then formula Solved/Closed
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...
-
convert date into month name Solved/Closed
Hello, 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/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...
