Office Software Forum

Ask a question
Search
Close
Results 4001 - 4050 of about 16,600
  • Dynamic database Solved/Closed

    Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...

    Omar Tafnakji | Excel | Latest reply: omar Sep 21, 2015
    2 replies
  • Excel Macro to rearrange data- combine cells and move sheets Closed

    Hello, I am just starting to use macros and am lost on figuring this out. Any help would be appreciated, thanks. Inventory comes in a 9x9 bo...

    masayaanglibre | Excel | Latest reply: TrowaD Sep 21, 2015
    1 reply
  • auto start a specific row in second page from previous page Closed

    Hi i need auto start a specific row in second page from previous page in excel i hope your replay Configuration: Windows 7 / Chrome 45.0.24...

    Muneer | Excel | Latest reply: TrowaD Sep 21, 2015
    1 reply
  • sum different alphabets in an excel range. Solved/Closed

    some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...

    tahir147 | Excel | Latest reply: Mazzaropi Sep 20, 2015
    12 replies
  • Macro to copy rows of data off of a sheet into several different Closed

    Hello, i'm new to these forums and new to writing macros, I've been trying to find a solution to my problem but haven't found one yet. I need a ma...

    monizuni | Excel | Latest reply: vcoolio Sep 20, 2015
    1 reply
  • comparison of two table Closed

    Hello, I need to compare the two table values and return the result as true or false based on two table value in another table . It should be high...

    kowsi | Excel | Latest reply: Mazzaropi Sep 19, 2015
    1 reply
  • Auto-running macro when cell is changed. Closed

    Hello guys, I am using simple macro for one sheet (ControlSheet) to hide rows, in which certain cell (B11;B51) contains text "Corrective Action not ...

    Branok | Excel | Latest reply: RayH Sep 18, 2015
    4 replies
  • If Then rule with dates help Closed

    Hello, I'm trying to figure out a formula to calculate adding 84 days to an original date. However, if the calculated date does not fall on a Sund...

    Valkrie | Excel | Latest reply: Mazzaropi Sep 18, 2015
    1 reply
  • Transferring data to successive worksheets Closed

    Hi I have a excel workbook containing several worksheets. To keep things simple Sheet 1 contains a column headed Dates listing 36 weekly starting dat...

    1ne-2wo-3hree | Excel | Latest reply: TrowaD Sep 17, 2015
    1 reply
  • copy data and paste using vba Closed

    Hi, I've two files, I would like to copy the data and not able to do so. Source file: Multiple rows (some times has 60 rows sometimes 80 with fe...

    a_r_i_e_s | Excel | Latest reply: a_r_i_e_s Sep 17, 2015
    0 replies
  • How to change/replace an image in Word Doc Closed

    Im trying to modify some documents and have trouble with the pictures. In some documents, if I click on an image it will give me an option to replace ...

    sswdo | Word | Latest reply: sswdo Sep 16, 2015
    0 replies
  • Dynacom Renconciliation Closed

    Hi, i am using Dynacom. my previous months reconciliation were all balanced, but all of the sudden, without changing the cash account, they all becam...

  • Macro to rearrange data in excel- merge 3 cells and move sheets Closed

    I am just starting to use macros and am lost on figuring this out. Inventory comes in a 9x9 box with position 1,1 (rows, columns) in the bottom lef...

    masayaanglibre | Excel | Latest reply: masayaanglibre Sep 16, 2015
    0 replies
  • macro to delete rows matching certain column criteria Closed

    site: https://ccm.net/faq/6261-excel-a-macro-to-delete-rows-with-specific-values I have reviewed this VBA code and it keeps getting stuck when it ...

    kkrausetx | Excel | Latest reply: kkrausetx Sep 16, 2015
    0 replies
  • How to reference Excel information onto other sheets Closed

    Hi, I have imputed all the information onto excel sheet 1, now I need to consolidate all the information from this sheet onto another excel sheet 2...

    maryly_domin... | Excel | Latest reply: maryly_dominguez Sep 16, 2015
    0 replies
  • Help. Difficulty with adding a new row Closed

    Hello, so I am working on a payroll excel sheet which pretty much tallies up the number of hours that each employee does bi-weekly. On my first worksh...

    tatianaarg | Excel | Latest reply: tatianaarg Sep 16, 2015
    0 replies
  • Opening Word 2007 docs with Word 2010 Solved/Closed

    So I installed Office 2010, and removed Office 2007 from my computer (I had lost the product key, so it was in view-only mode, it's a long story) - ob...

    Notsmart | Word | Latest reply: Rockport Sep 16, 2015
    3 replies
  • Macros for counting the record count of each sheet Closed

    Hi , Anybody plz help me in writing macros to prepare summary of records i will be uploading txt files into excel each file will have header and...

    BabuSampath | Excel | Latest reply: BabuSampath Sep 16, 2015
    0 replies
  • Conditional Formatting as a text Closed

    I'm trying to create a conditional formatting to come up as a text. For example I want an if then statement... if the cell = 7, I want a text to com...

    clauxman | Excel | Latest reply: Aglo Sep 15, 2015
    2 replies
  • Macro with variable rows Closed

    Hi I am very new to macros and trying to record (rather than write through vba) a macro that can be used each week. The purpose of the macro is to f...

    shelly6661 | Excel | Latest reply: shelly6661 Sep 15, 2015
    0 replies
  • cell blocking Closed

    Hello, i need to block the cell after entering data to it which means i need each cell to accept entry one time only note.the worksheet must be pr...

    Moon Spell | Excel | Latest reply: TrowaD Sep 15, 2015
    1 reply
  • What to do about messages about corrupt tables in Microsoft word Closed

    Hello, I am receiving message that I can't create or save tables in ms Word 2003. Many different messages. Intermittent problem but I can't count...

    fennlasson | Word | Latest reply: fennlasson Sep 15, 2015
    0 replies
  • Change date format Closed

    Hello, I want to change date format from D/MM/YYYY (as it's being downloaded from a google form) into YYYY/MM/DD but I can't get it to work. A...

    questioner | Excel | Latest reply: questioner Sep 15, 2015
    0 replies
  • Table relation Closed

    Hello, Ok This is the scenario, I've a excel sheet, with inside 2 sheet. In sheet1 i've a table with some some datas. In the collum B there ...

    TheMarcus | Excel | Latest reply: TheMarcus Sep 15, 2015
    0 replies
  • Coping one cell values into different excel sheets by different Closed

    I have one cell vales. I want to store that value into different cell in different sheet. Suppose I have 10 in cell A1 from sheet 1 today which will ...

    Ncnayak | Excel | Latest reply: Ncnayak Sep 14, 2015
    0 replies
  • VBA for copy/paste a tutor perhaps.... Closed

    First of all, Excel is not new to me, and although I am not fluid on creating pivot tables, I can create some pretty awesome formulas on my own...and ...

    pepsijoe | Excel | Latest reply: technicgang Sep 14, 2015
    1 reply
  • Comparing sales of Mondays Closed

    We have an excel spreadsheet of sales for the year. The headings are Monday thru Friday. The rows are labeled for different categories. We would li...

    kkin627 | Excel | Latest reply: ac3mark Sep 14, 2015
    1 reply
  • Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format Solved/Closed

    I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...

    Lschwa01 | Excel | Latest reply: ac3mark Sep 14, 2015
    1 reply
  • Ôter la protection Closed

    Bonjour tout le monde, j'ai un problème qui me bloque depuis un bout de temps, je veux ôter la protection des structures et fenêtres pour un classeur ...

    khaoula.alao... | Excel | Latest reply: Ambucias Sep 14, 2015
    1 reply
  • Macro Closed

    Hi Team, I wanted to create macro which can select some data from cell A1 (not whole cell) eg if i have 10 characters in cell A1 i want select only 5...

    vaijnathd | Excel | Latest reply: vaijnathd Sep 14, 2015
    0 replies
  • How do I lookup a value in say column and in returning the found Closed

    Hello, How do I lookup a value in say column and in returning the found value replace the it with a typed value. An example is; a b ...

    Sheengle | Excel | Latest reply: Mazzaropi Sep 14, 2015
    1 reply
  • Unable to send email with outlook 2010 Closed

    Hello, i cant send email on outlook 2010 my web mail is binsowaidan.ae Configuration: Windows / Chrome 45.0.2454.85

    mattar | Outlook | Latest reply: mattar Sep 14, 2015
    0 replies
  • Google sheet Help required Closed

    Hello, i want to print some 18 document in Google sheet as a PDF format. i want to create a formula, by which. If i enter the default value in ma...

    Saji | Excel | Latest reply: Saji Sep 14, 2015
    0 replies
  • =IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>&quot Solved/Closed

    Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...

    j1969c | Excel | Latest reply: Mazzaropi Sep 13, 2015
    1 reply
  • Convert numbers to Word format in Rial Omani currency Closed

    Hello, I like to Convert numbers to Word format in Rial Omani currency, say for example - 8,823.200 should be written as Rial Omani Eight Thousand...

    Asim | Excel | Latest reply: Asim Sep 13, 2015
    0 replies
  • Sheet1 value in Sheet 2 Closed

    Hello, I have different DATA in a ROW of various Column of sheet1 (for specific date). Now in Sheet2, I have to use these DATA in various places. ...

    Faiyaz | Excel | Latest reply: Faiyaz Sep 12, 2015
    0 replies
  • how sum the total for paticular value Closed

    Hello, we have the stated contains as below Region product amount sales Chennai apple 1,854.00 * Delhi apple 4...

    ssk | Excel | Latest reply: ssk Sep 12, 2015
    0 replies
  • IF function for "specific date" + 15 calendar days Solved/Closed

    Hello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...

    josecruz | Excel | Latest reply: j1969c Sep 11, 2015
    11 replies
  • My compliments, great altruism everybody! Great forum! Solved/Closed

    Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...

    j1969c | Excel | Latest reply: j1969c Sep 11, 2015
    4 replies
  • translate spanish to english of a pdf file Closed

    I need to know how I can translate a large PDF file from Spanish to English

    Kay | PDF | Latest reply: Ambucias Sep 11, 2015
    2 replies
  • forgot password on locked folder Closed

    Hello, hi i forget my locked folder pass. i have the file with me. but i tried to open with the pass i always use but cant open. i need the date in...

    karan1712 | Word | Latest reply: qazal_eh Sep 11, 2015
    2 replies
  • Macro copying data to another workbook Closed

    Hello, After running the macro, WB2 doesn't have 6 7 8 9 0 1 2 3 4 5 WB2 has 1 2 3 4 5 http://ccm.net/faq/7565-excel-macro-to-copy-d...

    JD | Excel | Latest reply: JD Sep 11, 2015
    0 replies
  • =IF(F9:F46="CTF",I9,"") Solved/Closed

    Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...

    j1969c | Excel | Latest reply: Mazzaropi Sep 11, 2015
    1 reply
  • Conditional Cells Filing Solved/Closed

    Hello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...

    Branok | Excel | Latest reply: Branok Sep 11, 2015
    2 replies
  • how to use a single part of a cell's date Solved/Closed

    So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...

    TheMarcus | Excel | Latest reply: TheMarcus Sep 11, 2015
    2 replies
  • Find Number (1), in like 12,15,31 Ans.should be 3 Closed

    Hello, Find Number (1), in like 12,15,31 Ans.should be 3 Any formula to count number Configuration: Windows / Chrome 45.0.2454.85

    Pramod | Excel | Latest reply: Mazzaropi Sep 11, 2015
    1 reply
  • Conditional Formatting for dates Closed

    Hello, Hey there, so what I am trying to do is: I have a range of fruits that we grow. All of the fruits have to be tested at certain times. A ...

    JMO | Excel | Latest reply: JMO Sep 10, 2015
    0 replies
  • How do i recover an outlook calendar Closed

    I lost the motherboard on my computer and could not purchase a replacement board so i purchade an other computer and i installed my existing disk as a...

    mauricemorrison | Office Software | Latest reply: mauricemorrison Sep 10, 2015
    0 replies
  • Help in Merging Codes Solved/Closed

    Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...

    smuneeb | Excel | Latest reply: smuneeb Sep 10, 2015
    2 replies
  • Help Please For Auto Fill Closed

    Hello, Hi I have one sheet with 100 row and every row have 3 cell i want crate auto sheet with copy in first sheet set a1 from row 1 cell 1 a2 c...

    vulture | Excel | Latest reply: vulture Sep 10, 2015
    0 replies