Office Software Forum

Ask a question
Search
Close
Results 3651 - 3700 of about 16,600
  • Compare data in two excel sheets Closed

    Hello, I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find...

    Andy | Excel | Latest reply: rizvisa1 Dec 4, 2015
    1 reply
  • Excel sheet alphabet count Closed

    Hello, How can I count alphabet on excel sheet. kindly send me the details Thanks & regards Pulakesh Medhi

    Pulakesh | Excel | Latest reply: rizvisa1 Dec 4, 2015
    1 reply
  • Subtraction total Closed

    Good evening, please anyone who can help me, i have in cell J5 all products eg. 20 parts. In cells L5:W5 add how many parts i have used. How i will ...

    NickBR | Excel | Latest reply: ac3mark Dec 3, 2015
    1 reply
  • add a restriction to a column Solved/Closed

    Hello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...

    Aimz | Excel | Latest reply: rizvisa1 Dec 3, 2015
    1 reply
  • How to find a blank cell in Particular column? Closed

    Hello, I want o identify the blank cell in Particular column, and in this my blank cell is my last cell even it would be helpful if anyone suggest...

    Manjunath Bh... | Excel | Latest reply: rizvisa1 Dec 3, 2015
    1 reply
  • How to copy multiple lines with a Macro Closed

    Hello! I have never worked with Macros but I strongly believe they could save my current data crunching work (that I need to finish by tomorrow or ...

    Em | Excel | Latest reply: TrowaD Dec 3, 2015
    4 replies
  • Conditional Formatting through Macro Solved/Closed

    Hello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...

    smuneeb | Excel | Latest reply: vcoolio Dec 3, 2015
    9 replies
  • excel formula needed Closed

    Hello, Need excel code for min(1-5), N or X Example data: 1. 3. 5. 2 X. --> 1 X. N. X. X. N. -->N X x x x x x x. --> x X 3 2 N. X N...

    Ray | Excel | Latest reply: rizvisa1 Dec 2, 2015
    1 reply
  • Sum values from one column if another column equals x Solved/Closed

    Hello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...

    Sarah | Excel | Latest reply: vcoolio Dec 2, 2015
    3 replies
  • VBA - Copying Data to new sheets Closed

    Greetings Excel experts, I'm trying to figure out how to tackle a problem. Basically, I have a master sheet with a bunch of data and I would like ...

    rayz211 | Excel | Latest reply: vcoolio Dec 2, 2015
    2 replies
  • Weird date display in excel Closed

    Hello, This seems like a really simple problem to solve but totally has me stumped. I have entered my date as 30/11/15 (DMY) into the excel cel...

    bellydancemi... | Excel | Latest reply: ac3mark Dec 1, 2015
    3 replies
  • Worksheet_Change event Closed

    Hello, I have a vb script worksheet_change I am trying to get a conditional If like statement to work in the code where a condition is met from...

    cptn | Excel | Latest reply: RayH Dec 1, 2015
    8 replies
  • Retrieve data from Column A based on condition from Column B Closed

    I have a set of data in a column. Say like below: Col A Sets Apple 1 Apple 1 ...

    ashjey29 | Excel | Latest reply: rizvisa1 Dec 1, 2015
    3 replies
  • Autocopy row based on whether the cell in a certain column is Closed

    Hello, I have a detailed aging report that I am attempting to create monthly tabs in. Basically what I need is a macro that will auto paste the en...

    crystal hill | Excel | Latest reply: TrowaD Dec 1, 2015
    3 replies
  • Going paperless - form replacement - suggestions please. Closed

    Hi All, I have no idea how to ask this, so please bear with me on this. My wonderful boss has tasked me with what seems to be such a simple idea...

    BrianGreen | Office Software | Latest reply: BrianGreen Dec 1, 2015
    2 replies
  • Transfer worksheet Solved/Closed

    Hello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...

    answerseeker | Excel | Latest reply: Gili Dec 1, 2015
    3 replies
  • will Open Office work on Windows 10? Closed

    will Open Office work on Windows 10?

    bo48 | Open Office | Latest reply: xpcman Nov 30, 2015
    1 reply
  • download a file on PDF from email Closed

    Hello, I want to download a file on PDF from my email. Thanks Configuration: iPhone / Chrome 46.0.2490.76

    Jose | PDF | Latest reply: Ambucias Nov 30, 2015
    1 reply
  • Problem when format date option Closed

    Hello, I have a date "17/07/15" and "01/07/2015" i want to change it to "July-15" format for all cases. I go through format option and select the op...

    NEEL | Excel | Latest reply: TrowaD Nov 30, 2015
    1 reply
  • Copy outlook email account settings Closed

    Hello, Is there a way to copy email account settings? I want to set up outlook to be able to send mail from the same account for several people ...

    DonShort | Outlook | Latest reply: WilliamB918 Nov 30, 2015
    1 reply
  • Excel and dates Closed

    Hello, I have three columns, for example 19-Nov-15 then 26- NOV-15, I want the third column to = the most recent date of the two +7. because I nee...

    Zac | Excel | Latest reply: RayH Nov 28, 2015
    1 reply
  • Copy invoice dates to ledger Closed

    @vcoolio Read your reply in an earlier post. copied it to my use, but this did not work. please help. I am copying a list of cell entries from invoi...

    aneela1 | Excel | Latest reply: vcoolio Nov 28, 2015
    3 replies
  • Custom Message Box in Macro Closed

    Hello, I would like to ask that how could custom message box having custom button will be created. I have a code given below I need a changes wh...

    smuneeb | Excel | Latest reply: smuneeb Nov 28, 2015
    0 replies
  • can't view Mail attachment on my z30 blackberry mobile-pdf Closed

    Hello, I can't view Mail attachment on my z30 blackberry mobile

    ebyic5 | PDF | Latest reply: ebyic5 Nov 28, 2015
    0 replies
  • Image into Table Closed

    Hello, I have inserted a picture in my table and have formatted it with Wrap Text. Problem is when I try to copy and paste this entire table, my p...

    Toni P | Word | Latest reply: Toni P Nov 27, 2015
    0 replies
  • Diagram generator with logical handling Closed

    Hello, I'm looking for options to make flowcharts and related graphics. Rather than being interested in many customization options or visual effec...

  • How to convert number into words Closed

    Hello, pl give the solution

    anil | Excel | Latest reply: Computertech Nov 27, 2015
    1 reply
  • vlookup or is blank?? Closed

    hi i need a formula to copy cells that are not blank or error if possible. in th picture attached i want the time to copy to the names with out th...

    Cblack | Excel | Latest reply: Cblack Nov 26, 2015
    0 replies
  • match col A sheet1with sheet2 found write row sheet3 Closed

    Hello, Need help. I have 2 sheets both contain same type of data in random and also duplicate rows. I need to 1. copy sheet1 row and sheet2 row i...

    Gardencity | Excel | Latest reply: Gardencity Nov 26, 2015
    0 replies
  • PDF Closed

    I NEED PDF CREATER SOFTWARE

    deepkuntal12 | PDF | Latest reply: deepkuntal12 Nov 26, 2015
    0 replies
  • Transfer data from excel sheet to excel sheets. Closed

    Hello I have a table contains about 5000 rows and 4 columns. The columns are Date, Codes, Department and Amount. I entered one year's data in that ...

    bhaskarroy | Excel | Latest reply: vishnumethas55 Nov 26, 2015
    2 replies
  • EXCEL FORMULA Solved/Closed

    Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks

    AlainSatori | Excel | Latest reply: vcoolio Nov 25, 2015
    3 replies
  • converting 179 HTML Files in a folder to docx (word 2010) Closed

    I have a folder consisting of 179 HTML Files saved in a folder to convert to word (2010) then remove all the residue html formatting (removing page n...

    laulou95 | Word | Latest reply: laulou95 Nov 25, 2015
    0 replies
  • Scroll mouse in ListBox Solved/Closed

    Hello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...

    smuneeb | Excel | Latest reply: smuneeb Nov 25, 2015
    2 replies
  • Chance Excel to PDF Closed

    How can it possible excel sheet to PDF?

    ifti21feb | PDF | Latest reply: rizvisa1 Nov 25, 2015
    1 reply
  • Date Change to dd/mm/yyyy to dd/mm/yy Closed

    Hello, I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003 Please revert me urgently Configuration: Windows XP / Chrome 46.0...

    ANDY | Excel | Latest reply: kieferschild Nov 25, 2015
    1 reply
  • Calculation of age Closed

    Hello All, I have been trying to calculate the exact age of a person from two dates in Office 2007. In the first cell I have the current date and i...

    ARZANM | Excel | Latest reply: vcoolio Nov 25, 2015
    11 replies
  • create a summary table from a master table Closed

    Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...

    Eli | Excel | Latest reply: rizvisa1 Nov 24, 2015
    1 reply
  • Get other cells value Closed

    Hello, I am stuck in a formula and I cannot solve it. Please I need help. I am making a survey on excel, and I need the result for a whole month ...

    BashirYazbik | Excel | Latest reply: rizvisa1 Nov 24, 2015
    1 reply
  • Compare Excel Sheet1 to Sheet2 and highlight changes in sheet2 Closed

    I have explained my query in screenshot. Somebody please help me get this resolved.....

    robzzz0489 | Excel | Latest reply: rizvisa1 Nov 24, 2015
    1 reply
  • Export data from one sheet to another Closed

    I need help. I have a form call Purchase Request from where I want transfer data to different fields in next sheet and then need to raise Purchase ...

    deardipakjee | Excel | Latest reply: rizvisa1 Nov 24, 2015
    3 replies
  • copying cells if criteria is met Closed

    Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...

    IanHeradien | Excel | Latest reply: rizvisa1 Nov 24, 2015
    1 reply
  • Copy a 'Template' sheet onto multiple other sheets Solved/Closed

    Hello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...

    SWILLER | Excel | Latest reply: rizvisa1 Nov 24, 2015
    1 reply
  • AverageIf function using dates Closed

    Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...

    jpeg21 | Excel | Latest reply: RayH Nov 24, 2015
    5 replies
  • compare to columns in v lookup Closed

    Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155

    sachin | Excel | Latest reply: TrowaD Nov 24, 2015
    14 replies
  • Add Sheets to ComboBox Solved/Closed

    Hello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...

    smuneeb | Excel | Latest reply: smuneeb Nov 24, 2015
    5 replies
  • conditional formatting on multiple criteria Solved/Closed

    hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...

    pramvyas000 | Excel | Latest reply: TrowaD Nov 23, 2015
    5 replies
  • Conditional formatting cells containing IF rules Closed

    Hello, Cell D11 contains the rule "=IF(D4>0,D4,"0")". I have set conditional formatting on the entire spreadsheet to show that if value is grea...

    Robin | Excel | Latest reply: Robin Nov 23, 2015
    0 replies
  • Copy data from another sheet if the condition is met Closed

    Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...

    Rhyne | Excel | Latest reply: vcoolio Nov 23, 2015
    1 reply
  • Transfer Data IF.... Closed

    Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...

    MT | Excel | Latest reply: vcoolio Nov 23, 2015
    3 replies