Office Software Forum

Ask a question
Search
Close
Results 6651 - 6700 of about 16,600
  • Formula to calculate monthly contract value between date Closed

    Hi, Would appreciate helps here. I need to calculate monthly contract value based on contract start date and finish date. Contract value: 100,0...

    Bozztcs | Excel | Latest reply: bozztcs Jun 23, 2013
    2 replies
  • request for a formula marks of my students Solved/Closed

    Hello, sir, I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from ...

  • I cant open my exel .slxs files Solved/Closed

    Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...

    srf91 | Excel | Latest reply: srf91 Jun 22, 2013
    6 replies
  • Enter Start time and End Time Closed

    Hi! I'm trying to make a tracker using excel wherein we can calculate the minutes used in each task that we make. I am planning to have the start time...

    totzkie10 | Excel | Latest reply: totzkie10 Jun 22, 2013
    2 replies
  • VBA code for document controll & progress monitoring Closed

    Hi... Good day! I am a project control engineer dealing with almost 1500 documents/drawings from my engineering sub contractor. Each documen...

    j108 | Excel | Latest reply: j108 Jun 22, 2013
    13 replies
  • Enter Time by clicking on a cell Solved/Closed

    Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...

    jkdurkin | Excel | Latest reply: totzkie10 Jun 21, 2013
    7 replies
  • convert excel into pdf Closed

    Hi, i want to convert my one excel file into pdf please help

    rakshaagro | PDF | Latest reply: Saxon K Raj Jun 20, 2013
    2 replies
  • conditional formatting with an exception Closed

    Hello, Im trying to conditionally format the results in I19:I44 for all duplicates although I want the first one to be an exception. How do I sp...

    troxi | Excel | Latest reply: TrowaD Jun 20, 2013
    1 reply
  • Freezing Panes Closed

    Hello friends, I want to freeze more than one row (like 5, 8, 20, etc) and column (like E, K, O, etc) at random location at the same time in excel....

    ugn10 | Excel | Latest reply: TrowaD Jun 20, 2013
    1 reply
  • Attendance Sheet Closed

    Hello friends, Please help me for following issue. I have created an attendance sheet in excel having 12 sheets (for all months like Jan, Feb, ...

    ugn10 | Excel | Latest reply: TrowaD Jun 20, 2013
    1 reply
  • A macro for a single column until end of data in the column Closed

    I need to create a macro that created "Replacement Date" in Column AE and calculates the Replacement Date for the entire column and stops at the end o...

    ZGL | Excel | Latest reply: TrowaD Jun 20, 2013
    1 reply
  • I want to customize the Save As dialogue box. Closed

    Using Word 2010 (OS Windows 8 ) and when Saving documents, I used to be able to customize the folders in the Save As dialogue box. I think this was f...

    VMB7547 | Word | Latest reply: vmb7547 Jun 19, 2013
    2 replies
  • Selecting dates Closed

    I have a worksheet that list property sales from year 2000 to 2012. I'm trying to mark all property sales into different quarters that is all sales fr...

    kaake | Excel | Latest reply: kaake Jun 19, 2013
    2 replies
  • Data search and corellation Closed

    Hello I have hundreds of pages of data that I am going through for Pie and Pareto analysis and I am trying to speed up the process by using formula...

    Car7os | Excel | Latest reply: Car7os Jun 18, 2013
    1 reply
  • Matching Closed

    Working on a large data that I want to match, on one hand is payments by credit cards on the other from checking. The matching is to confirm no double...

  • Excel - Macro help please!!! Closed

    Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorte...

    SuzyDataAnalyst | Excel | Latest reply: TrowaD Jun 17, 2013
    3 replies
  • Conditionally insert a duplicate row Solved/Closed

    I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...

    acohen12 | Excel | Latest reply: TrowaD Jun 17, 2013
    7 replies
  • cell contains value from range return value from another column Closed

    How can I compare two columns of data and return a value from another column? If the value from column A on Sheet 2 contains a value from Column A ...

    cbaker137 | Excel | Latest reply: jack4rall Jun 17, 2013
    4 replies
  • Inserting rows chronologically while maintaining weekday formula Closed

    Hello there, In a sheet named Projects, col C contains weekday dates and col B has numbers of days needed for projects (a project takes at least 1 ...

    newVB | Excel | Latest reply: rizvisa1 Jun 16, 2013
    1 reply
  • Macro Help Copy Specific Text from One cell into another Solved/Closed

    Here is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...

    steve22522 | Excel | Latest reply: rizvisa1 Jun 16, 2013
    5 replies
  • How to convert a numeric value into eng. word Closed

    Hello, Please solve the question. How to convert a numeric value into eng. word Thanks & regards Rajesh Juneja

    Raj | Word | Latest reply: rizvisa1 Jun 16, 2013
    3 replies
  • Capturing time through Excel Macro Closed

    Hello, I am trying to capture the timings of my team for various activities like break, meeting, working hours, login & logout timings etc...I hav...

    Durgaprasadcs | Excel | Latest reply: rizvisa1 Jun 16, 2013
    1 reply
  • Excel - how do I create multiple spreadsheets from one Master Closed

    Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorted...

    SuzyDataAnalyst | Excel | Latest reply: rizvisa1 Jun 16, 2013
    1 reply
  • find a column by criteria and display in another worksheet Closed

    Hello, I have a worksheet with a several columns (example): PP DR MM SS 5 3 2 7 4 9 2 1 2 9 4 4 ...

    jesslm17 | Excel | Latest reply: Mazzaropi Jun 15, 2013
    1 reply
  • So many dates Closed

    Hello, I have a spreadsheet of about 15000 items. I need to do several things to the pivot table built off the spreadsheet. The things I need to...

    Excelsior2000 | Excel | Latest reply: Excelsior2000 Jun 13, 2013
    0 replies
  • trying to create a formula Closed

    Hello, what I am trying to do is that I have a $ amount in g7;g41 + 20% of the dollar amount in i7;i41 to give total payout in k7;k41 Thanks

    resiresale | Excel | Latest reply: ac3mark Jun 13, 2013
    3 replies
  • Enter data in a Workbook worksheet and Save it in a other Worksh Closed

    Hi, I Created a excel file requisition and user input details requesting materials I need to have this data go to a other sheet with two section ...

    jlockem | Excel | Latest reply: TrowaD Jun 13, 2013
    1 reply
  • Is there a way to make a default option for Autofilter? Closed

    Hello, I have an excel sheet that I am trying to display 3 different tables on, but I want to make it so that I can filter the tables down to just ...

    indydude71 | Excel | Latest reply: TrowaD Jun 13, 2013
    3 replies
  • Macro to add # of rows based on data in the sheet Closed

    I am trying to make a guest list that will insert rows automatically and fill in some data. I can get the primary data from one worksheet (i.e. com...

    ardale | Excel | Latest reply: TrowaD Jun 13, 2013
    4 replies
  • EXCEL - Create a bulleted list in a single cell from a list Solved/Closed

    Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...

    morocog | Excel | Latest reply: TrowaD Jun 13, 2013
    3 replies
  • Excel Spreadsheet date comparison Closed

    Hello, I am trying to compare 2 columns of data to determine if one date is prior to or after another date. (Is date in column A on, before, or aft...

    JohnnyB3 | Excel | Latest reply: aquarelle Jun 12, 2013
    1 reply
  • return selected characters in an excel cell Closed

    I have a alphanumerical number like the following: C297320 I need to return the last 3 digits of this number in a separate cell. Thus, I need...

    luiyoo | Excel | Latest reply: aquarelle Jun 12, 2013
    1 reply
  • why i cant open my pdf files even though i'm having adobe reader Solved/Closed

    hai. i'm having new version of adobe reader, when I try to open my pdf files by double clinking on it it opens in word. when I try to select'open-wit...

    reshmagh | PDF | Latest reply: reshma Jun 11, 2013
    12 replies
  • Have macro select range but exclude empty columns Closed

    Hello, I have a worksheet in which a range gets copied and pasted into an email using a RangeToHTML function from Ron de Bruin's website: https:...

    Pluggie | Excel | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • vba insert new cell to a dynamic range Closed

    Hello, Hi, Could anyone plz help me to achieve what I need ? I want a code to insert and autofill a new cell to the range depending on what ...

    tornado1981 | Excel | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • Excel solution Closed

    I have one Master Sheet, sheet1 in excel 2007 where I have entries of customer details from mixed cities Code ContactPerson Company Add1 ...

    eexpert | Excel | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • Insert Rows according cells value in excel table Closed

    Dear All, I need a Module that allowed me when I run it to add Rows down according upper cells Value for Example; Total Names 2 Sami 5 Rami ...

    loftier | Excel | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • If there is value in one column then a $ generates in another Closed

    Hi there, I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. W...

    KiwiJess | Excel | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • Number to Words Closed

    Dear Kioskes, Ex: 45,450.55, Forty five thousand four hundred and fifty & 55/100 only could please replay me

    syed abdulra... | Excel | Latest reply: TrowaD Jun 10, 2013
    5 replies
  • Adding 1 to an existing number if criteria is matched? Solved/Closed

    In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...

    rshelton22 | Excel | Latest reply: ac3mark Jun 8, 2013
    5 replies
  • Find the sum of data that has multiple conditions in Excel Solved/Closed

    Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...

    acohen12 | Excel | Latest reply: Kevin@Radstock Jun 7, 2013
    1 reply
  • Formula Closed

    Hi, I need to create a formula for a whole team. It is based on the number of people in the office for each calendar month. The spreadsheet I have ...

    Jenna3009 | Excel | Latest reply: TrowaD Jun 6, 2013
    2 replies
  • pdf to excel convertor Closed

    Dear Sir, I want to install pdf to excel convertor to my PC! Help me pls!

    Kyawt.tzs | Excel | Latest reply: ac3mark Jun 6, 2013
    1 reply
  • Formula for change of dates daily for one month of working days Closed

    Hello. I am looking for a formula to add one day to a column of working days in a month. I wish to start the first cell in the column to 1/07/2013 an...

    thirsty | Excel | Latest reply: ac3mark Jun 6, 2013
    9 replies
  • VB Column Width and Sheet Name Closed

    Hi, I am really new to VB, but I work a ton with Excel. I have a spreadsheet that I have to parse out into multiple spreadsheets for some reporting p...

    hsolo30k | Excel | Latest reply: hsolo30k Jun 5, 2013
    2 replies
  • Excel 2010; Need help w/If, Then formula Closed

    I need a formula that if there are duplicate values in column A, then it will sum the values in column D for the rows with duplicate values in column ...

    tmsblevis | Excel | Latest reply: ac3mark Jun 5, 2013
    1 reply
  • Autofilter range by selecting cell from a column in that range Closed

    Hello, I have a 6 column overview with Description rule sets for Titles and Subtitles of Product groups. Each set consists of two rows: The desc...

    Pluggie | Excel | Latest reply: Pluggie Jun 5, 2013
    0 replies
  • Unable to open word file Closed

    Hello, I recover my some deleted ms word 2007 file but it unable to open. it show the file is corrupted . i tried some method and softare but cant...

    UZAIR ansari | Word | Latest reply: jack4rall Jun 4, 2013
    1 reply
  • Transfering data from one sheet to another, but not duplicating. Closed

    Good day all. Checking to see if anyone could help out, as iam very new to the excel world. I have a sheet that I am transferring data to another s...

    RR2105 | Excel | Latest reply: TrowaD Jun 4, 2013
    3 replies
  • file convert procedure from pdf to jpg Closed

    dear sir, please give step wise procedure for converting pdf file to jpg file by return email at the earliest thanks & Regards Surekha Surve

    surekha Surve | Office Software | Latest reply: TrowaD Jun 3, 2013
    3 replies