Office Software Forum

Ask a question
Results 6201 - 6250 of about 16,700
  • Conditional Fomatting Closed

    I am trying to add conditional formatting to a spreadsheet. It is an employee list showing drivers lic and med cards expiration dates. I want to forma...

    irene wallin | Excel | Latest reply: gm2612 Jan 1, 2014
    1 reply
  • Macro for creating text file and copy paste date Closed

    Hello experts, I need an another macro, a keypad shortcut triggered macro (Ctrl+j), which will copy ranges "A10:A45", create a new text file on the...

    gm2612 | Excel | Latest reply: gm2612 Jan 1, 2014
    5 replies
  • Help with comparing column data Closed

    Here is my situation, I have a DB with a column of customer #'s that I want to tie to a status column. Each customer # can have anywhere from 1 - 12 ...

    Lost in the ... | Excel | Latest reply: ac3mark Dec 31, 2013
    3 replies
  • paste 10 or more worksheets data in a single worksheet Closed

    I want paste 10 or more worksheets data in a single worksheet by using formula, is it possible?? Thanks in advance Mahfuz

    mahfuz19 | Excel | Latest reply: mahfuz19 Dec 31, 2013
    2 replies
  • Creating workbook and copying data Closed

    Hello, I have a work book in which the sheet - "Master list". Column D contains the master list of clients. 2nd sheet "Template" contains the maste...

    gm2612 | Excel | Latest reply: gm2612 Dec 30, 2013
    0 replies
  • Doubts on Sum Mulitple Sheets Closed

    Hi All, I have different kind of workbooks having records from A6to BB6 in this we can enter the details on daily basis sales . One more Master...

    vimal4184 | Excel | Latest reply: vimal4184 Dec 30, 2013
    0 replies
  • How to use formula for transfering data from Sheet 1 to Sheet 2? Closed

    Date & Time JOB NO PENDING 12/23/13 2:14 PM SICD-B00xxx * My question is, there are three cells named- Date & ...

    paulg100 | Excel | Latest reply: paulg100 Dec 28, 2013
    0 replies
  • Macro for copying cells with format from last sheet to new sheet Closed

    Hello, My project requires to maintain a database for all customers. I have already obtained an event macro from experts from this forum, which, I...

    gm2612 | Excel | Latest reply: venkat1926 Dec 27, 2013
    1 reply
  • Excel formula Closed

    I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If 0...

    apg913 | Excel | Latest reply: venkat1926 Dec 27, 2013
    1 reply
  • Macro for creating a new excel sheet based on certain conditions Closed

    Dear Experts, Greetings. My sincere thanks for the support you providing thorugh this forum. Now stuck with some requirements in the microsoft exce...

    gm2612 | Excel | Latest reply: gm2612 Dec 25, 2013
    7 replies
  • time calculation formula Closed

    Hello, what is the formula to calculate time between two different dates and times Thanks

    madhusupra | Excel | Latest reply: Kevin@Radstock Dec 25, 2013
    1 reply
  • date function Solved/Closed

    i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...

    gayathrialagu | Excel | Latest reply: venkat1926 Dec 24, 2013
    1 reply
  • list dependant drop down menu Closed

    Hello everyone, I have a worksheet with two columns (A and B) of data. I'm trying to populate a second worksheet (column A) using a drop down box t...

    wstring | Excel | Latest reply: wstring Dec 19, 2013
    0 replies
  • Applying conditional formatting to multiple cells Closed

    Hi all, I've actualy already done what I needed to do, but as this is a very sensitive document I would like to know WHY it worked, just to be sure...

    AndieArbeit | Excel | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Formula to highlight cell based on data value over 2 cells Closed

    Hi Guys and Girls, I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location. I want...

    insight1979 | Excel | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Conditional formatting to colour cell based on text in another Closed

    Hi, I have a workbook tracking submission of work ideas. In column C I have the date received. In column J I have status (approved, rejected, pendi...

    nicm123 | Excel | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Excel Closed

    Hello, Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String ...

    Reddy | Excel | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Conditioning Formatting Closed

    HI All, we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed. we have seve...

    Chamberlyn | Excel | Latest reply: ac3mark Dec 19, 2013
    1 reply
  • Formula Closed


    manz26 | Excel | Latest reply: manz26 Dec 19, 2013
    0 replies
  • Remove duplicates and merge rows Closed

    A B C D E 2000 Mary 123 street1,street2 2000 James 123 street2 2000 Mary 123 street1 2.8...

    Annie1986 | Excel | Latest reply: Annie1986 Dec 19, 2013
    0 replies
  • Date formula Closed

    HI I want to set the formula for excel for when I insert date in cell ex. 1dec2013 then I will select any empty cell date change in to 31dec2013

    @vi | Excel | Latest reply: venkat1926 Dec 18, 2013
    1 reply
  • If command across multiple cells Closed

    Hi Guys, I can successfully use if command with text on a single cell, however I want the true or false outcome to be based on multiple cells. T...

    CuriousBaz | Excel | Latest reply: venkat1926 Dec 18, 2013
    1 reply
  • corrupted office file Solved/Closed

    i have a problem that i lost my all data from my computer. then i apply recovery software to get this data , although i recover my data but after reco...

    julupapa | Open Office | Latest reply: julupapa Dec 17, 2013
    2 replies
  • Writing a macro that copies data from multiple worksheets to one Closed

    I have a workbook that has over 580 different worksheets, and I need to copy a certain section from each worksheet onto a "master" worksheet. The data...

    Jasonlowery_1 | Excel | Latest reply: Jasonlowery_1 Dec 16, 2013
    0 replies
  • Find and Extract text from a cell content Closed

    I need to search a cell for content and extract and display a portion of the cells content. How do I do this? Here are more specifics. lets say...

    rdegrasse | Excel | Latest reply: rdegrasse Dec 15, 2013
    2 replies
  • Nested If logic is not working Closed

    Please tell me what's wrong in below formula: =IF((AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Green"))),"Compliant",IF((AND(AND((H...

    raj3076 | Excel | Latest reply: raj3076 Dec 15, 2013
    0 replies
  • Date Function using if_ else statement Closed

    My requirement is while writing a function using if statement : In a range of cells in say: P10: P20, containing dates, I want to writ...

    shiny thomas | Excel | Latest reply: venkat1926 Dec 15, 2013
    1 reply
  • Require Formula Closed

    I want to type only 1 in excel cell but require to come 100 and the same that 2 for 200, 3 for 300, 10for 1000, 50 for 5000, 100 for 10000 and so on. ...

    desai bandhu | Excel | Latest reply: venkat1926 Dec 14, 2013
    1 reply
  • ahtisham Closed

    12 3456Hello, Configuration: Windows 7 / Chrome 31.0.1650.63

  • VBA for Conditional print Closed

    Hi all, I have a word file which includes some check boxes. I need a VBA code that forbid the user to print the active document if he didn't checked...

    issahamameh03 | Word | Latest reply: issahamameh03 Dec 13, 2013
    0 replies
  • How can I add blank line to the record using macro Closed

    Hi There, I am having difficulties with macro, I would like to have macro which checks the records in each row and if they do not match than it add...

    sylvans | Excel | Latest reply: sylvans Dec 13, 2013
    0 replies
  • Cannot Receive or send yahoo mail in Outlook 7 Closed

    From yesterday onward I can not send or receive Yahoo mail in my Outlook 7. Since i thought that it is due to the trouble with my ISP I tried 3 diffe...

    appachen | Outlook | Latest reply: appachen Dec 12, 2013
    2 replies
  • Returning Text from Excel Closed

    I have customer names located in Column B Rows 12-56; I have dates that they returned letters to me in column J rows 12-56. My question is what is...

    mccormack.1087 | Excel | Latest reply: mccormack.1087 Dec 12, 2013
    0 replies
  • Unique records Solved/Closed

    Hello, I am very new to excel macros, however, I want to make a macro that will provide unique records from three different excel sheets. I have...

  • convert the date format into general format Solved/Closed

    Hello, In excel 2003, how do I convert the date (3/21/2012) from date format into general format and still keep it show as 3/21/2012 instead of 40...

    hhchavez | Office Software | Latest reply: Bharath Dec 12, 2013
    4 replies
  • how to auto copy/past info from one cell . Closed

    Hi , I am trying to create a sheet that when i press a name it will ask me to where i want to copy it in a different sheet. For example If i pre...

    Avisub | Excel | Latest reply: Avisub Dec 12, 2013
    0 replies
  • Transfer data between sheets in excel Closed

    I currently have a sheet that sorts my data by customer, such as Part#, Qty ordered, Qty Shipped, Due date and so on. I would like to be able to trans...

    Rubidoux | Excel | Latest reply: Rubidoux Dec 11, 2013
    0 replies
  • Script :Scan Excel Sheet for Validity Date & Send Reminder Mails Closed

    Hello, I have a training manager in Excel that has different training records of about 100 employees. Each training has a certain validity. The re...

    IMR4N | Excel | Latest reply: IMR4N Dec 11, 2013
    0 replies
  • Excel IF argument Closed

    Dear All, I'm trying to use IF argument in a excel document for a calculation. But it is not working. I'm using more than 8 IF argument. My excel i...

    arahim01 | Excel | Latest reply: ac3mark Dec 10, 2013
    1 reply
  • How to move data to different sheets Closed

    I need to enter data into several different sheets and then would like some of the data to transfer automatic to a log sheet so I can then sort it. C...

    pb1927 | Excel | Latest reply: TrowaD Dec 10, 2013
    5 replies
  • moving data from rows into columns for every Solved/Closed

    Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...

    Rick | Excel | Latest reply: Glitchdata Dec 10, 2013
    20 replies
  • Transfer data from one workbook to another. Closed

    Hello, I am having a problem with the getting the form to transfer data. The post previously placed on this forum is not resolved. Please help me ...

    topinwebhost | Excel | Latest reply: topinwebhost Dec 9, 2013
    0 replies
  • Excel VBA Closed

    Hi, I have a VBA data entry user form where in 200 people will be updating it and updating different excel sheets and will be saving it. All the d...

    topinwebhost | Excel | Latest reply: topinwebhost Dec 9, 2013
    9 replies
  • Ms office 13 Closed

    Hi guys, A source to download Ms office 2013 with activation key please? Thanks in advance

    kg247 | Open Office | Latest reply: Ambucias Dec 9, 2013
    1 reply
  • copy rows with date as criteria Closed

    Hi i have a workbook with 3 sheets. sheet 2 has data that changes constantly and column A has the date entered when the change was made. sheet 3 ne...

    ANDREAAS | Excel | Latest reply: ANDREAAS Dec 8, 2013
    0 replies
  • Macro to sort worksheets by a value in a cell, least to greatest Closed

    I need a macro to sort my worksheets by the value in their cell "J65", least to greatest. The formula in cell "J65" is: =Sum(J35-H62). It is a USD...

    StarScott | Excel | Latest reply: StarScott Dec 8, 2013
    0 replies
  • how to check replicated data Closed

    Hello, I have a set of data ranging from column A to AW. They are shown in several sheets and there are 289 items in each sheet. Since the data wa...

    ichliebeprin... | Excel | Latest reply: ichliebepringles Dec 7, 2013
    0 replies
  • Change Cell Data by Format Conditioning Closed

    I need to how to used format conditioning to change a cell's data Example If Cell A1 = "F", then A3 background is Green (this is normal Format Con...

    Patrobyn | Excel | Latest reply: Patrobyn Dec 7, 2013
    0 replies
  • Combine Multiple Rows into One Row Closed

    Hello, I am in need of major help with a large spreadsheet that have over 500 rows. I need to take multiple rows and combine them into one row. ...

    iietntech | Excel | Latest reply: iietntech Dec 6, 2013
    0 replies
  • resume writing Closed

    how a resume can be written .

    DEVASHIS | PDF | Latest reply: BunoCS Dec 6, 2013
    1 reply