Office Software Forum
- Excel (9,843)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (184)
- Word (2,189)
-
highlight cell if the finish date of a task is less than x days Closed
Please could somebody help me with this problem. I have a spreadsheet and i would like make some cells to go yellow if the finish date of a paticular...
-
Function or Macro to read cells in a column and color them Closed
Hi Guys, I need to write a VBA macro or a formula/function, which actually reads the value and color of cells in column and in turn color other cel...
-
how to calculate number of days between dates Closed
Please I need ideas of how to get the number of days between to sets of dates in an excel column. The preceeding dates all the way to the end of the l...
-
outlook won't open word attachments Closed
Hello, I have Microsoft office 2003 and Windows XP home. When I try to open an email attachment that is a word document Outlook crashes. This happens...
-
VB code to email at File Save is nnot auto-running Closed
Hello, all, I hate to rehash this old message, but since Microsoft never stops messing with things, I suppose threads like this will never die. Ma...
-
VB macros extract data containing ".CF from a particular cell Closed
Hi, i would like to know how to extract data containing ".CF from a particular cell and to a different workbook with the entire values of the row.....
-
comparing 2 excel with diff length Closed
I have two columns of numbers A B 123 223Abc 223 334ssd 334 368def 456 456def i want to compare n...
-
If date range, then % commission. Closed
I am trying to create a formula that will look at a group of rows and calculate a percentage of a particular date range of money. The rows have a dat...
-
formula that allows it to calculate the sum of Closed
Hi ! I'm looking to create a formula that allows it to calculate the sum of.. =SUM(D3*E3+D4*E4+D5*E5+D6*E6)... but it needs to do this from ro...
-
determine percentage via formula Solved/Closed
Hello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me determi...
-
VBA - insert pictures into excel Closed
Hi there, I am trying to write code to insert pictures based on the file name in column B4, with the picture to be displayed in Column C4. This con...
-
Help Creating Macro Closed
Hello, I hope someone can help me since I don't have the knowledge to do it. I'm trying to build a macro that check the value in an excel cell ...
-
Copy data from two columns to third columns on a condition Closed
Column A1 containing the current day =today() From B4:B33 the dates from the beginning of the month till end of the month From C4:C33 the first ...
-
How to calculate percentage of savings Closed
Sir, Im going to invest in a gold saving scheme .12 months scheme 100 per month at last they are giving 50 as free .how to calculate the percentage...
-
Excel invoice w/data from spreadsheet 1 and update spreadsheet 3 Closed
Good morning experts, I sincerely hope that you can help me out. Currently, we use an Excel template to write invoices (a modified Excel 2010 ...
-
How to calculate the average of a range day by day? Closed
Hi all, How to calculate the average of a range day by day? A is the column for the day, and the average should go at the top of each day. I've done ...
-
Change the rows font colour based on one cell Closed
Hi I would like to create a rule to change the whole rows font when something is put into any cell in column V - who do I do this?
-
two values to find on the same cell Solved/Closed
Hi, Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell E2180; =IF(ISNUMBER(SEARCH("(dr)",E2180)),"1",IF(ISNUMBER(SEA...
-
date convert in text Closed
how to convert date value into text value.so, what we can convert that value. For e.g. 2/2/2013 than convert into second February two thousand thirte...
-
where can I get MS Office publisher for free Solved/Closed
Hi, any body can help me, where I can to get MS office publisher for free?
-
Help- how to add prefix on Spreadsheet Closed
Hello, I am pretty new to using spreadsheets. I have a large spreadsheet with part numbers and I want to add a FJ prefix at the start of the part num...
-
convert number to text Closed
Hello, i wanna ask how to convert number to text in MS, since i found only in English like {=123\*cardtext}, but i need your help for arabic tex...
-
convert numbers to arabic words Closed
hi , can you help me to find a way to convert numbers to arabic words, since i use the ctrl F9 to convert to English , and asking if you can help me t...
-
problem in renaming a ms office word 2007 document Closed
Hello, when i tried to RENAME THE file name of ms office word 2oo7, a dialogue appears that if you tried to change file name extension it may bec...
-
problem in renaming the ms office 2007 word document Closed
When I tried to rename the ms office 2007 word document, a dialogue box appears that if you change the file name extension, it may become unusable, ar...
-
Macro to delete row after certain condition found Solved/Closed
Hello, I am an Excel newbie; I am trying to write an Excel macro that will search a certain column to find a blank value. It would then delete the...
-
issue with date formatting Closed
Hello, For some reason, when I insert date formatting into Excel on my work computer, the numbers that appear in the spreadsheet are completely diffe...
-
if then (text or no text) Solved/Closed
Hi, I hope someone can help me with this. I would like to create a formula that says this: if a certain cell contains ANY text, then write "6.2"...
-
Microsoft office 2007 excel files are not shown Closed
Microsoft office 2007 excel files are not shown in microsoft office 2003 & 2010. what can i do to see my excel files again.
-
Excel - insert data to many lines based on a set of ID numbers Closed
Does anyone know what type of macro could help with my problem. I have a spreadsheet. Column A has an ID (example Test and Apple). Each ID has a se...
-
Add IF Excel 2013 formula to sum all those items with code Closed
Hello, I am Dr Kunvar Harsh from India I wanted to know if there is any way I can put formula to sum all those items with code e.g E C, H C, K ...
-
CHANGE CELL BASED ON TWO OTHER CELLS' VALUES AS COORDENATES Closed
Hello, I am new at this website and in vba programming and I am looking for some assistance with my vba code. I'm trying to right a code that makes ...
-
Excel vba that will change color according to another cell's col Closed
Hi I am trying to change a cell color according to the color of another cell, tried diffarent ways to do this but failing could someone help please...
-
connect two worksheets together Solved/Closed
Hello, I am trying to connect two worksheets together. If text found in one cell in sheet1, make the same cell on sheet2 different color. Ther...
-
Conditional Formatting: Highlight cells based on two values Solved/Closed
Hello, I have a merged cell (C5-N5) that I want to change the fill color, based on the combined input of two cell values. I'll just call it "C5" f...
-
True/False Statment Using Four Values Closed
Hi everyone! I'm working on a spreadsheet that will drastically reduce the time our staff have to do paperwork, and I'm oh so close but I can't get...
-
Auto populate sheets based on main spreadsheet Closed
Hello, I am having some trouble creating a building floor directory. I would like to have one main spreadsheet with everyone's name, title, departme...
-
Code of copy paste data Closed
Hi all of you I have my data spreaded from A2 to K2 and the huge long block of data. I wanted a solution like this. Consider The first block of ...
-
VBA Macro Conditional Formatting Closed
I need to find out how to write a macro that includes Conditional Formatting. =if(and(Column A has the word "Dial")and(Column F has the word "Booke...
-
False value, other than the weekly total Closed
=IF(C1716="","",IF(COUNTIF(C$2:C1716,C1716)=1,COUNTIFS($H$2:$H$11999,1,$C$2:$C$11999,$C1716)=1,"")) I enter the above formula to calculate the tota...
-
Hacked e-mail account Solved/Closed
how to retrieve my hacked hotmail account. I tried 3 attempts by using the Microsoft forms to reset my password but it failed. Missing some security ...
-
FALSE statement Closed
Hi, The below gives me a FALSE statement. I took off the second "" at the end but makes no difference: =IF(OR(AQ2246=0,AY2246=0),"",IF(COUNTIF(AJ$...
-
CHANGE CELL VALUE BASED ON TWO OTHER CELLS' VALUES Closed
Hi, i'm trying to right a code that makes a change and then try to applies it on other tab by taking the value of one cell that returns the number of...
-
Large size PDF file printing Closed
Hello, Dear All, I am have trouble shooting with printing documents I have a file PDF with 30 mb when i printing it to Canon printer, the status ...
-
date format Closed
Hello when i work in excel format 2007 like dd/mm/yyyy when i import the data some date are convert wrongly like 5/3/2014 (March 5th 2014) May ...
-
i cant open excel file Closed
Hello, i cant open excel file. message :there was a problem sending the command to the program. Configuration: Windows 7 / Firefox 28.0
-
Selecting Cell based on a criteria and copy selected row Closed
Hello, I am working on VBA for the following Selecting cell based on criteria and the copying the selected row to another sheet. Then deletin...
-
fonts in excel Closed
I want to reply to the comments in cells in a color which have alrady been typed in another color. Ex: if i get a comment in red color , i want my rep...
-
Maximum and minimum values of a column Closed
Hi, I have a rather large database of experimental values and rather that giving the average of a particular set, I would like to give a range as it ...
-
Lining up group of cell values in Excel 2007 Solved/Closed
Hi I have two group of cells D6 to D8 and other G12 to G15 Need a code with two conditions that can line up the details of the mentioned cells in ...