Office Software Forum

Ask a question
Search
Close
Results 5851 - 5900 of about 16,600
  • Conditional formatting for cells depending on other cells ranges Solved/Closed

    First off, I am not even sure if i worded my question correctly, so sorry if i have. What i want to do is... have for cells b4:b7 to have on green ce...

    Derrall | Excel | Latest reply: Derrall Apr 16, 2014
    3 replies
  • macro extracting data from different sheets within a workbook Closed

    I need help creating a macro to copy data from multiple sheets within a workbook into one master sheet. I have tried several times and remain unsucces...

    ESal | Excel | Latest reply: venkat1926 Apr 16, 2014
    1 reply
  • How to see if a particular cell in a table has date data or not Solved/Closed

    Hello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...

    vinaymaithani | Excel | Latest reply: vinaymaithani Apr 16, 2014
    4 replies
  • formula calculate daily income in excel Closed

    I'm using excel to calculate my income and expense on monthly basis using sum() but I need to calculate daily basis. my data as follows A1 = 1-Ap...

    swathisuda | Excel | Latest reply: TrowaD Apr 15, 2014
    5 replies
  • Highlight the linked cell depends on drop-down list choice Solved/Closed

    Hello, I have a question. Let say I have a table containing number 1,2,3,4 and 5 in A1:A5. In another worksheet, I have "Student" in A1 and "Asses...

    Natasya | Excel | Latest reply: Natasyamn Apr 14, 2014
    2 replies
  • Conditional Formatting: Merged cell color Solved/Closed

    Hi, This is probably an easy solution but for the life of me cannot get this to work. I have a situation whereby I have a line of information th...

    Ricky588 | Excel | Latest reply: ricky588 Apr 14, 2014
    2 replies
  • pdf to msword converter Closed

    I a want freeware program to convert from pdf to ms-word

    mijbas | PDF | Latest reply: TrowaD Apr 14, 2014
    1 reply
  • Calculating Due date based on multiple criteria Closed

    Criteria 3 products, choose one classification, one category, all time frames are different Products: HBX, Flex, NYM Categories: Complaint, Gvn...

    fixthemystery | Excel | Latest reply: TrowaD Apr 14, 2014
    1 reply
  • duplicate values at the bottom, not at the top Closed

    Hi , The below formula gives me the results for AT column at the top of each duplicated code in column AJ. How could I make it to give me the results...

    jutulu | Excel | Latest reply: TrowaD Apr 14, 2014
    3 replies
  • Array formula to nest several optional values from same cell Closed

    Hi, All the OR statement formula below refers to the same cell AL2362. How could I make an array formula to put all the OR values in one without r...

    jutulu | Excel | Latest reply: jutulu Apr 13, 2014
    10 replies
  • Counting cells containing only numbers Closed

    Hi all, counting cell containing only numbers Is there a formula to count only cells containing any numbers in general? Moreover, is there a formul...

    jutulu | Excel | Latest reply: jutulu Apr 13, 2014
    4 replies
  • Copy data from current work to another Closed

    Hi I am using the below code to copy data from Current Work To Another Sub RunMe() Dim lRow As Integer lRow = Range("A1").End(xlDown).Row R...

    Sushil.gaikw... | Excel | Latest reply: venkat1926 Apr 13, 2014
    5 replies
  • compare three columns contain same characters Solved/Closed

    I have three columns of form security access in an application for different classes. The security characters may be in any order. I need to compare...

    sspenguin | Excel | Latest reply: ac3mark Apr 11, 2014
    5 replies
  • Still learning Closed

    I have an excel invoice made up with guest details. I need to place information into another spread sheet, this gets rather tedious to do every day, ...

    8AJB8 | Excel | Latest reply: ac3mark Apr 10, 2014
    1 reply
  • How do I automate my Excel worksheet Closed

    Hello, I have a workbook that contains two worksheets, sheet 1 is my budget worksheet and sheet 2 are the invoices paid. I want to take sheet 2 and h...

    Sherrelle | Excel | Latest reply: ac3mark Apr 10, 2014
    2 replies
  • Excel: Partial Matches in 2 Different Cells Solved/Closed

    Hello, I've been mulling over this all afternoon and need some help. Here is what my sheet looks like: K L 3 ...

    kaiwalls04 | Excel | Latest reply: kaiwalls04 Apr 10, 2014
    2 replies
  • Copying the entire row using VBA Closed

    Hi! I need a code that will automatically copy the entire row to another sheet (same file) when a condition has been satisfied. See the sample be...

    ScullyMulder | Excel | Latest reply: ac3mark Apr 10, 2014
    28 replies
  • Can't send emails from Outlook Closed

    I'm unable to send emails but able to receive. I've followed the protocol that others have suggested but a window keeps appearing that my password is...

    firemanlou | Outlook | Latest reply: ac3mark Apr 10, 2014
    1 reply
  • 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...

    v022695 | Excel | Latest reply: venkat1926 Apr 10, 2014
    1 reply
  • 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...

    jain.prashant31 | Excel | Latest reply: venkat1926 Apr 10, 2014
    7 replies
  • 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...

    VickyAliri | Excel | Latest reply: ac3mark Apr 9, 2014
    4 replies
  • 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...

    cmg | Word | Latest reply: whiggins Apr 9, 2014
    19 replies
  • 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...

    geelsu | Excel | Latest reply: geelsu Apr 9, 2014
    1 reply
  • 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.....

    Rohit47 | Excel | Latest reply: Rohit47 Apr 9, 2014
    0 replies
  • 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...

    sabrinadwitch | Excel | Latest reply: sabrinadwitch Apr 9, 2014
    0 replies
  • 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...

    ace350 | Excel | Latest reply: ac3mark Apr 8, 2014
    5 replies
  • 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...

    RivkaJ | Excel | Latest reply: RivkaJ Apr 8, 2014
    2 replies
  • 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...

    kaiwalls04 | Excel | Latest reply: kaiwalls04 Apr 8, 2014
    3 replies
  • 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...

    jlljacintado... | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • 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 ...

    joaopedr1 | Excel | Latest reply: TrowaD Apr 8, 2014
    3 replies
  • 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 ...

    tarek-kamel | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • 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...

    sunilantonz | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • 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 ...

    LearningLife... | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • 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 ...

    jutulu | Excel | Latest reply: TrowaD Apr 8, 2014
    1 reply
  • 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?

    RDyman | Excel | Latest reply: Mazzaropi Apr 8, 2014
    1 reply
  • 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...

    jutulu | Excel | Latest reply: jutulu Apr 7, 2014
    2 replies
  • 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...

    jaygohel | Excel | Latest reply: TrowaD Apr 7, 2014
    1 reply
  • 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?

    spectator | Open Office | Latest reply: spectator Apr 7, 2014
    2 replies
  • 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...

    ChilliRed | Excel | Latest reply: ChilliRed Apr 7, 2014
    4 replies
  • 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...

    mohamedchihime | Word | Latest reply: mohamedchihime Apr 7, 2014
    0 replies
  • 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...

    mohamedchihime | Excel | Latest reply: mohamedchihime Apr 6, 2014
    0 replies
  • 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...

    p.v. krishna | Word | Latest reply: Ambucias Apr 5, 2014
    1 reply
  • 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...

    pvkrishna | Word | Latest reply: xpcman Apr 5, 2014
    1 reply
  • 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...

    wendelly | Excel | Latest reply: wendelly Apr 4, 2014
    6 replies
  • 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...

    HDW | Excel | Latest reply: ac3mark Apr 4, 2014
    1 reply
  • 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"...

    hikkup | Excel | Latest reply: hikkup Apr 4, 2014
    4 replies
  • 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.

    pettertom | Excel | Latest reply: dluv28u Apr 4, 2014
    1 reply
  • 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...

    mvillamarin12 | Excel | Latest reply: mvillamarin12 Apr 3, 2014
    2 replies
  • 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 ...

    Kunvarharsh | Excel | Latest reply: ac3mark Apr 3, 2014
    1 reply
  • 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 ...

    dbsimoes92 | Excel | Latest reply: dbsimoes92 Apr 3, 2014
    2 replies