Office Software Forum - solved topics

Ask a question
Results 1051 - 1100 of about 2,640
  • Solved
  • How to get free microsoft office? Solved/Closed

    How to get free microsoft office?

    aboabdou | Open Office | Latest reply: Ambucias Aug 18, 2014
    1 reply
  • VB script to notify/popup Solved/Closed

    I was having a difficulty in notifying my co-worker to print all the sheets on a workbook. I a thinking if it's possible to have an pop-up message to ...

    Sammysen | Excel | Latest reply: Sammysen Aug 14, 2014
    10 replies
  • lookuk a value in 2 columns and get value of third (help) Solved/Closed

    Hello, I have a question I need to lookup a value of col A1 of sheet 1 in col A of sheet 2 and if it matches it gets the corresponding value ...

    sharifa6869 | Excel | Latest reply: sharifa6869 Aug 12, 2014
    2 replies
  • Remove duplicated data Solved/Closed

    Hi, How do I remove duplicated data from 3 different worksheets in excel ? Like I have a column of client names on each worksheets. I need to com...

    SherlynPeh | Excel | Latest reply: SherlynPeh Aug 11, 2014
    5 replies
  • Automation of pie chart using the values in excel Solved/Closed

    Hi, Anybody knows how to convert values into pie chart using macros instead of the insert function? Thanks!

    SherlynPeh | Excel | Latest reply: TrowaD Aug 11, 2014
    4 replies
  • Forgot my Internet password Solved/Closed

    I forgot my internet password , how can i get it .

    superman9007 | Open Office | Latest reply: Ambucias Aug 10, 2014
    1 reply
  • Transferring Selected Data from Multiple Worksheets to One Solved/Closed

    My team uses an excel to track our projects. We have many tabs (8) , but on each tab on Column A, we have a drop down menu that we can select if it's ...

    cpogata | Excel | Latest reply: cpogata Aug 5, 2014
    10 replies
  • locking a range based on a value of a cell Solved/Closed

    Hello, first I would like to thank every one working at kioskea my issue is , I want to lock a set of cells ( A2:M2) if the cell M2="app" and ...

    Osama_bb11 | Excel | Latest reply: Osama_bb11 Aug 4, 2014
    4 replies
  • require help to count number Solved/Closed

    1652 1646 1650 1658 1622 1651 1659 1582 1599 1606 1611 1657 1745 1937 1936 1648 1666 1656 1636 if i type like this in diffrence cel...

    ebrahimrta2489 | Excel | Latest reply: ebrahimrta Aug 4, 2014
    2 replies
  • Grater then , less then with number range multiple Solved/Closed

    if the numbers cell A110 means the cell B1 have to calculate the C1 cell and if A1 20 means the cell D1 have to calculate ...... please let clear...

    najustar72 | Excel | Latest reply: najustar72 Aug 3, 2014
    2 replies
  • Excel "If Then" Formula Solved/Closed

    I am looking to create a "If Then" formula for Excel that can put an "X" in the cell if the date I am reffering to (Cell A6) is 0-5 days, next cell 6-...

    jessica2991 | Excel | Latest reply: jessica2991 Jul 30, 2014
    6 replies
  • Need help comparing dates... Solved/Closed

    I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie with...

    l_gavacho | Excel | Latest reply: Mazzaropi Jul 28, 2014
    3 replies
  • Automate Excel to shift data so the values in two rows match? Solved/Closed

    Hello! Please help me with this quandary for my internship. I would greatly appreciate it :) Here is my problem: I want to match ID numbers in two co...

    excellenthelp | Excel | Latest reply: excellenthelp Jul 22, 2014
    5 replies
  • Copy X Row N Number of Times Solved/Closed

    Hi. I need the formula to Copy X Row N No.of Times. For Example Col 1 Col 2 ABC 3 DEF 5 GHI 4 O...

    lionsclaw | Excel | Latest reply: smiller1712 Jul 21, 2014
    2 replies
  • Excel returns FALSE sometimes.... why Solved/Closed

    I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date of ...

    plato2 | Excel | Latest reply: plato Jul 11, 2014
    2 replies
  • Excel 2003 IF Function using Dates & Text Solved/Closed

    Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell w...

    Jen | Excel | Latest reply: depu Jul 9, 2014
    7 replies
  • Format fill colour based on another cell Solved/Closed

    Hi I would like to format my excel page so that the rows alternate between two fill colors based on whether two cells are equal or not. Here is an ex...

    EndlessDread | Excel | Latest reply: EndlessDread Jul 2, 2014
    2 replies
  • Transfer cell data from one workbook to another workbook Solved/Closed

    I am using two workbooks to track account spending for quarterly reporting. Workbook 1: Day Expenses Workbook 2: Monthly Expenses WB1: I have fo...

    txljh | Excel | Latest reply: Osama_bb11 Jul 2, 2014
    4 replies
  • Date format change in excel Solved/Closed

    Hi, I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried the '...

    booor | Excel | Latest reply: booor Jul 1, 2014
    2 replies
  • Classic Menu for Word 2010 or 2013? Solved/Closed

    Can you clarify? Will "Classic Menu for Word" work for Word 2013 or just for 2010? I see both on your download page.

    ofannod | Word | Latest reply: ofannod Jun 25, 2014
    2 replies
  • Help: Return day of the week Solved/Closed

    Hello, I have checklist sort of form that I am printing every month to let them sign for task everyday. from C3 - AG3 it is numbered 1-31 and un...

    fireburn | Excel | Latest reply: TrowaD Jun 23, 2014
    6 replies
  • Excel - Repeat rows to a specific number of times Solved/Closed

    Hello, Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in...

    arhee | Excel | Latest reply: daphtan Jun 23, 2014
    6 replies
  • cell auto filled with dots Solved/Closed

    Hello, I sow it once but not sure where and can't work out how to do it. Basically, if I write things in excel, I need it to be auto filled with do...

    jutulu | Excel | Latest reply: jutulu Jun 19, 2014
    4 replies
  • How to delete strings of words from a range of cells Solved/Closed

    I have a list of website for which some start with www. and others start with http://. I have been trying to remove the "http://" from all the cells a...

    Arrissa | Excel | Latest reply: Arrissa Jun 14, 2014
    2 replies
  • Need Formula for automatic date update in same cell Solved/Closed

    Hi all, I was wondering if anyone knew of a formula that would allow excel to change a date in a cell automatically once a certain date had passed?...

    Matrix1000 | Excel | Latest reply: Osama_bb11 Jun 13, 2014
    5 replies
  • Creating a Macro to Find Text and Then Merge Cells Solved/Closed

    Hi- I need some help with creating a macro. I haven't been able to get it to record correctly and I am completely illiterate in Visual Basic. ...

    katie215 | Excel | Latest reply: TrowaD Jun 2, 2014
    6 replies
  • Bold Text Solved/Closed

    Hello Sir, I required the macro to bold some specific text in cell like: Below mentioned formula is written in cell ="We are enclosing herew...

    Game Start Now | Excel | Latest reply: TrowaD May 27, 2014
    1 reply
  • need vba Code to Transfer Data from Sheet3 to Row1 of Sheet2? Solved/Closed

    Hi dears, I need a VBA Code which can transfer the LAST ROW's (ie 15 or 29 or may be any other) Data of Sheet 3 to ROW 2 of Sheet 2 . Reason to Trans...

    hmk950 | Excel | Latest reply: hmk950 May 24, 2014
    2 replies
  • Split data into several rows of same data Solved/Closed

    Hello, I would like to split a row of data into several rows of same data in MS Excel. For example, I have an item with standard packing size of 100p...

    wliang | Excel | Latest reply: emily1214 May 19, 2014
    25 replies
  • How to count number of cells dated this week? or next week? Solved/Closed

    I've got lots of cells with dates. I want to know how many are THIS WEEK and NEXT WEEK. I'm not sure how to do it... Help would be appreciated...

    doublewitt | Excel | Latest reply: doublewitt May 19, 2014
    2 replies
  • Can't send email on outlook 7 Solved/Closed

    I cannot send email on outlook 7 using window 7 ultimate, it's reporting error (0x800cccof) can anyone help on this? Thanks Bobosco

    Bobosco | Outlook | Latest reply: Bobosco May 19, 2014
    4 replies
  • Date counting with user inputs Solved/Closed

    Hello, I'm looking for a date counting formula between two dates, where the user defines the total number of days, and Excel will tell them which ...

    Plastic_Cup_... | Excel | Latest reply: Plastic_Cup_of_Stars May 15, 2014
    3 replies
  • Create file xls based on colums & populate data with criteria Solved/Closed

    Hi, I need a macro that create some new file (txt or xls it doesen't matter) starting from an existing xls. The existing xls named "Arretrati" h...

    Steveryde | Excel | Latest reply: Steveryde May 14, 2014
    4 replies
  • product key of ms publisher Solved/Closed

    I want to know the product key of Ms publisher downloaded from your website.

  • auto filling bill number and date Solved/Closed

    hi i need a macro for my office use the condition is like this sheat one input ...

    jowelvjoy | Excel | Latest reply: jowelvjoy May 7, 2014
    16 replies
  • How to insert multiple conditions in a formula? Solved/Closed

    I have 2 cells, and I proceed like this with a formula and basically, if cell A2 meets a condition, then cell B4 shows the word "Good" =IF(A2>=100...

    doublewitt | Excel | Latest reply: doublewitt May 4, 2014
    2 replies
  • Excel - Shortcut key print preview Solved/Closed

    Hello, What is the short cut in excel 2003 for print preview. Please give me solution. Configuration: Windows XP / Firefox 3.6

    CHITTI | Excel | Latest reply: Hafiz Pakistani May 4, 2014
    12 replies
  • Insert word in cell based on value in another cell? Solved/Closed

    CONDITIONAL FORMATTING for cell A2: if value in cell C3 is > than 500, then insert word "alert" in cell A2 what would the formula look like? I ...

    doublewitt | Excel | Latest reply: doublewitt May 1, 2014
    2 replies
  • Conditional formatting of entire column Solved/Closed

    Hello, I have two columns in excel 2010 which are generated by sensors measuring the same thing. In theory the 2 columns should be the same...of c...

  • Round UP Formula for TIME Solved/Closed

    Hi All. I need an excel macro to populate a cell with a time slot based on the previous column which is a datetime value. e.g. if column A is 1-Apr-...

    ravibangera | Excel | Latest reply: ravibangera May 1, 2014
    2 replies
  • The value of a name Solved/Closed

    Hello, I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making ...

    Derrall | Excel | Latest reply: Derrall Apr 29, 2014
    2 replies
  • Can the formula COUNTA / COUNT exclude 0 values? Solved/Closed

    If I use COUNT or COUNTA, what can I include in the formula to exclude zero values? Thanks for any tips

    doublewitt | Excel | Latest reply: doublewitt Apr 28, 2014
    2 replies
  • Transfer data into Invoice Solved/Closed

    So I've put hours and hours into this with no avail. Here's my situation...I have on "Sheet 1" a list of materials which could potentially be used dur...

    semperfi90 | Excel | Latest reply: semperfi90 Apr 28, 2014
    10 replies
  • Inserting a row when the value of a field changes Solved/Closed

    I was using this code as a start but can't seem to mak it do exactly what I want. Sub InsertRows() Dim r As Long, mcol As String, i As Long '...

    kkautz | Excel | Latest reply: KKautz Apr 28, 2014
    2 replies
  • Format cell color based on date range Solved/Closed

    Hi, this is my first post. I'm glad to be a member of this forum. Based on conditional formatting, how can I select a cell and have the backgroun...

    doublewitt | Excel | Latest reply: doublewitt Apr 27, 2014
    4 replies
  • Filtering data from 1 sheet to another Solved/Closed

    Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and tasks ...

    mmtmacros | Excel | Latest reply: mmtmacros Apr 24, 2014
    2 replies
  • To show blank record when no data while copying Solved/Closed

    Hello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet ,th...

    AK | Excel | Latest reply: venkat1926 Apr 22, 2014
    4 replies
  • add value to one cell if multiple other cells have any value Solved/Closed

    Hello, I'm trying to create a spreadsheet where: if A1 has any value, 10 is added to the total sum in G1 if B1 has any value, 20 is added to t...

    alonsy | Excel | Latest reply: alonsy Apr 21, 2014
    11 replies
  • 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
  • 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