Office Software Forum

Ask a question
Results 5701 - 5750 of about 16,700
  • multiple processors for Excel Closed

    I work with very large spreadsheets in Excel on a Mac and I often have to wait for Excel to execute things like sort and fill. I'm hoping too solve...

    greepaul | Excel | Latest reply: greepaul Jul 6, 2014
    2 replies
  • auto generate invoice number Save and Clear Closed

    I'm new to this site. I'm using excel 2013, I want a macro to auto generate invoice number, at the same time when I save it should copy and clear th...

    jinah | Excel | Latest reply: xpcman Jul 5, 2014
    1 reply
  • If... Then Closed

    Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum. All me to set the stage. A = ...

    chrisdantonelli | Excel | Latest reply: Osama_bb11 Jul 5, 2014
    2 replies
  • How to retrieve a person's seat number from microsoft outlook Closed

    Hi All, I am trying to get details of a employee from office communicator using VBA. I am able to retrieve every detail of a person except "Seat Nu...

    SheikJM | Outlook | Latest reply: SheikJM Jul 4, 2014
    0 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
  • calculating text to result certain text result Closed

    hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3 cells I ...

    simonchef | Excel | Latest reply: Mazzaropi Jul 2, 2014
    3 replies
  • Search values in one workbook and paste into another workbook Closed

    I have to paste monthly figures from one Excel workbook to another workbook I want to write a code that search for the departments name within the...

    NatsJou | Excel | Latest reply: NatsJou Jul 2, 2014
    0 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
  • Question about my if statement Closed

    Hello, I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that i u...

    Derrall | Excel | Latest reply: Mazzaropi Jul 1, 2014
    1 reply
  • 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
  • Extract data from one workbook and paste into another workbook Closed

    We receive a workbook with various different sheets every month. We need to copy data from the workbook we receive into the workbook we use. We have ...

    NatsJou | Excel | Latest reply: NatsJou Jun 30, 2014
    0 replies
  • Macro to cut data from multiple worksheets Closed

    Hi guys need help with a macro Scenario Have 3 WorkSheets (TEB,CEB,LTE) in a workbook called Cases All worksheets contain same Column Names I wan...

    clivemalungah | Excel | Latest reply: clivemalungah Jun 30, 2014
    0 replies
  • Applying conditional formatting to Rows that vary Closed

    I need to have AA turn red when the date is out of window of AB and AC. I have dates in column AB and AC the dates are all different in each row. I...

    lynnseyt | Excel | Latest reply: rizvisa1 Jun 28, 2014
    1 reply
  • Date formate Closed

    i have 2 date formate example 06/11/2004 07-01-2004 and i want 1 formate and i useing this function =text(CellAddress,"DD/MM/YY") and text(...

    akram786 | Excel | Latest reply: venkat1926 Jun 28, 2014
    1 reply
  • numerical value is range of cells has a text value Closed

    Hi guys, This is for a holiday rota. if any sell has a 'h' in it I would like to total up the h's in a cell at the end as a numerical value of how ...

    craig2014 | Excel | Latest reply: Mazzaropi Jun 27, 2014
    1 reply
  • Macro to create a sheet and copy rows into that newsheet Closed

    Hi everyone, I have a work book with 3 work sheets. Each work sheet contains 12 similar columns How do I write a macro to create a new sheet (sum...

    clivemalungah | Excel | Latest reply: clivemalungah Jun 27, 2014
    0 replies
  • Excel Macro to combine multiple values Closed

    Hi All, I am new for Excel Macro. Need to create a macro to get below attached data. InPut - Output - Please help me on this to devel...

    suveen_mohan | Excel | Latest reply: suveen_mohan Jun 26, 2014
    0 replies
  • Sum range if 2 conditions met Closed

    Hi, I have arrange of numbers which I would like to sum in a certain cell, only if a column contains certain text and another column contains another ...

    Portiapuss | Excel | Latest reply: Osama_bb11 Jun 26, 2014
    1 reply
  • How to freely download softwares? Closed

    Hello, Please help me in downloading IDM, Mavis typing and Adobe reader free of charge. Thank you!

    Alebe | PDF | Latest reply: ac3mark Jun 25, 2014
    1 reply
  • Macro to add certain cells to another worksheet based on cell $ Closed

    Sorry, I know this has been covered a million times, I've looked up probably 30 different examples that look very similar to my situation for a macro,...

    mindspincycle | Excel | Latest reply: mindspincycle Jun 25, 2014
    0 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

    I need to know how to do an if function: If D2 is >= 9/1/2008 and E2 is

    SLJ2M | Excel | Latest reply: venkat1926 Jun 25, 2014
    1 reply
  • Formula Help to Add Columns that Contain Text Closed

    I want to add the total of Column A (going to be text) and Subtract Column D if there is an "x". How do I do that formula? Anyone able to help? Exa...

    stephd22 | Excel | Latest reply: venkat1926 Jun 25, 2014
    1 reply
  • LibreOffice Calc Closed

    How do I turn off the spell check in LibreOffice Calc? Trying to type in Wittenberg, and it keeps changing it to Gutenberg . Went in to Tools, and O...

  • Hi All can you help me with the formula i require below Closed

    Im looking for a formula that will look at a number in row b and if that number is 1 will add 1 day from the date in row c and put it in row e, and if...

    noelmitc | Excel | Latest reply: RayH Jun 24, 2014
    1 reply
  • how can rename Multiple Files Once Closed

    Dear sir, PLS tell Mehow can rename Multiple Word ,Excel Etc Files Once Regards Santosh

    santoshqkumar | Word | Latest reply: ac3mark Jun 24, 2014
    1 reply
  • Excel - creating reminder pop up based on criteria Closed

    Hello, may you please help me in creating a reminder to pop up for every 5 hours once for a cell range having text equal to "pending" I was able t...

    123gh | Excel | Latest reply: TrowaD Jun 24, 2014
    3 replies
  • Using a macro to Copy and paste special values to a new workbook Closed

    HI, I have a lot of financial data that is downloaded from a specific program with code. I want to be able to go and select multiple tabs in one workb...

    Excel15 | Excel | Latest reply: Excel15 Jun 24, 2014
    0 replies
  • Downloading PDF Conversion Closed

    I would like to know if it is possible to download and install pdf converter to my laptop. thank you.

    yabida | PDF | Latest reply: BunoCS Jun 24, 2014
    1 reply
  • 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
  • Generating Individual Reports From A Master Sheet Closed

    Hello everyone, I have a master pay sheet I am working on. I created a macro to create a 'pay summary' breaking down deductions, credits, etc. ...

    Jennie617 | Excel | Latest reply: Jennie617 Jun 23, 2014
    0 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
  • How to copy sheets from one work book to other Closed

    Dear Team. My query is Iam having two workbook in d drive as 1.xlsx and 2.xlsx i want to copy two sheets from 1.xlsx and paste in 2.xlsx ...

    Sultaaan | Excel | Latest reply: venkat1926 Jun 23, 2014
    1 reply
  • Macro to add down a column Closed

    Hello all, I need a macro that will sum numbers down a column until it gets as close to 8 as possible. ex: 1 .5 .5 4 3 .5 3 2 so a ...

    Blind156 | Excel | Latest reply: venkat1926 Jun 23, 2014
    1 reply
  • nested formula with 'or' statement Closed

    Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in ...

    jutulu | Excel | Latest reply: jutulu Jun 22, 2014
    2 replies
  • Sumproduct gives me error Closed

    Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it giv...

    jutulu | Excel | Latest reply: jutulu Jun 22, 2014
    3 replies
  • Find Text In one Cell, Add Different In Another Cell Closed

    Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried every ...

    samisam321 | Excel | Latest reply: Mazzaropi Jun 22, 2014
    1 reply
  • Excel Closed

    Hello, I want to transfer a single cell of information (which is a number) from an external excel sheet to another excel sheet. I dont need tables, l...

    Hookybox | Excel | Latest reply: Hookybox Jun 22, 2014
    0 replies
  • Moving columns based on text Closed

    Suppose data is like this: 3 3 OPG 4 5 2 5 3 MCG 0 4 3 0 4 ELG 4 2 4 7 5 CTG 4 2 1 I want a macro ...

    Blind156 | Excel | Latest reply: Blind156 Jun 20, 2014
    2 replies
  • How to do recursive searches in Excel Closed

    Hi, I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet. If ...

    pacman849 | Excel | Latest reply: venkat1926 Jun 20, 2014
    1 reply
  • 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
  • tracking 3 columns of scores between 1-10: OSAT, Arrival, Staff Closed

    I am excel illiterate so please forgive me... I need to create a formula that will go out and look for a set of initials, take the data associated ...

    hotelguy318 | Excel | Latest reply: hotelguy318 Jun 19, 2014
    0 replies
  • Automatically transfer data from one sheet to another Closed

    Hello, I have a workbook in sheet1 details of materials issued to dealer for job work Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty, etc ...

    kishn697 | Excel | Latest reply: TrowaD Jun 19, 2014
    1 reply
  • How to copy data from one excel table to other Closed

    I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined. Now...

    rkindia | Excel | Latest reply: TrowaD Jun 19, 2014
    1 reply
  • Compare text cells Closed

    Hello, I need to compare text cell and return me column title- row 4 I have made this formulla =IF(B24=N5:N19,N4,IF(B24=O5:O19,O4,IF(B24=P5:P1...

    Frappy | Excel | Latest reply: Frappy Jun 19, 2014
    0 replies
  • error in date formate Closed

    find attachment of date format issue resole the error please let me know

    vinayak1986 | Excel | Latest reply: vinayak1986 Jun 19, 2014
    2 replies
  • getting it set up Closed

    I get the program open and I start the process to get email to this new laptop and it fails. HELP!!!

    jmsweeny | Outlook | Latest reply: xpcman Jun 18, 2014
    1 reply
  • can not open a PDF by clicking on it anymore Closed

    I downloaded this a few months ago. I use PDF files often that I have saved on my PC and within our resource center of the company's software. I can...

    bjones | PDF | Latest reply: bjones Jun 18, 2014
    0 replies
  • Help: Macro compare worksheets and generate new with difference. Closed

    Hello, I am trying to compare two worksheets Sheet1 and Sheet 2 in the same workbook. And after comparison it will be copied in Sheet3 with the d...

    fireburn | Excel | Latest reply: fireburn Jun 18, 2014
    0 replies
  • VlookUp Problem? Closed

    I have 4 Column A,B,C,D A=date B=MarketValue C=Results D=Numbers when i use the vlookup formula in other sheet it not working =vlookup(A2,Shee...

    akram786 | Excel | Latest reply: Mazzaropi Jun 17, 2014
    1 reply