Office Software Forum - solved topics

Ask a question
Results 151 - 200 of about 2,650
  • Solved
  • Best MBOX conversion software Solved/Closed

    Last few days I have suffered to the conversion of MBOX files. Can anyone suggest the best way of MBOX conversion? Which is easier and Saves my all MB...

    robinsonmary | Outlook | Latest reply: larsaden Apr 21, 2020
    2 replies
  • Conditioning one Calc cell on another Solved/Closed

    Hello, does anyone know a way to make it so that a cell in Open Office Calc cannot be left empty, or at least that there will be an error message if ...

    AlanEDunne | Open Office | Latest reply: TrowaD Apr 16, 2020
    7 replies
  • VBA Function code to highlight Odd and Even numbers Solved/Closed

    Hello, I am trying to write a VBA Function code to highlight Odd and Even numbers. But not having much luck. Can anyone help me, please? I would ...

    Kalpesh | Excel | Latest reply: TrowaD Apr 16, 2020
    3 replies
  • Help: Need formula to find missing text comparing 2 cells Solved/Closed

    Hello guys I have the same issue. A2: The price includes VAT B2: The price In the next column, I want the following value (the text difference...

    alexm88 | Excel | Latest reply: TrowaD Apr 14, 2020
    1 reply
  • VBA: Color cells in table based on multiple condition Solved/Closed

    hello i do code by loop but it doesn't completely work i appreciate if somebody help me why it occurred and give me the alternative ok let'...

    abdelfatah_0230 | Excel | Latest reply: abdelfatah_0230 Mar 24, 2020
    2 replies
  • How to specify macro for current active sheet Solved/Closed

    Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is selecte...

    seo5906 | Excel | Latest reply: Dave Mar 20, 2020
    18 replies
  • How do I scan and then search a document Solved/Closed

    I would like to scan the table of contents from a large number of magazines. What format should I use to save this document? What software will allo...

    muddywater | Office Software | Latest reply: David Webb Mar 20, 2020
    3 replies
  • Excel make cell flash red Solved/Closed

    Hello, In Excel I can make cell red when formula is greater than 4 but how do I GET CELL TO FLASH Office 2003 And can you in same spreadsheet li...

    hugrl | Excel | Latest reply: Rjc Mar 13, 2020
    13 replies
  • inserted row should paste in 7times in next sheet based on the date Solved/Closed

    Hello, i have a template and from client a workbook will i should compare and paste the data if any new row der i should insert in template file an...

    abdul1201 | Excel | Latest reply: TrowaD Mar 9, 2020
    3 replies
  • VBA to reference newest sheet Solved/Closed

    Hello, Im a complete beginner in excel and the vba process. I'm trying to make a macro create a new sheet, copy the style/structure from a pre-det...

    pthfnd | Excel | Latest reply: TrowaD Mar 5, 2020
    1 reply
  • Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes Solved/Closed

    Hello All, I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific colu...

    jackied25 | Excel | Latest reply: TrowaD Mar 3, 2020
    2 replies
  • Macro to compare 2 sheets and copy differences Solved/Closed

    Hello, I’ve been working with this macro to compare two worksheets and copy the matches to a third sheet. Not knowing vb very well can someone show...

    ehusar | Excel | Latest reply: AirMaple Feb 15, 2020
    2 replies
  • Combine Cell Text Solved/Closed

    Hi, I am after an easy way to combine text in several rows into one cell. The number of rows that need combining will vary from 2- 10 (Would be...

    ad1959 | Excel | Latest reply: ad1959 Feb 11, 2020
    4 replies
  • Copying data from one Excel sheet to another. Solved/Closed

    Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the da...

    Remedial | Excel | Latest reply: Kav Feb 10, 2020
    30 replies
  • Copy rows from Excel to another sheet once a date in a specific field is filled Solved/Closed

    I have a current spreadsheet that lists our customers, job names, and delivery dates for the materials. I would like to have those lines copy automati...

    lisav041475 | Excel | Latest reply: vcoolio Feb 3, 2020
    16 replies
  • Cells copying and pasting in a empty cell of another sheet Solved/Closed

    Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...

    Parker | Excel | Latest reply: TrowaD Jan 30, 2020
    1 reply
  • Punching Time Solved/Closed

    Hi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders ...

    luigidelmonte | Excel | Latest reply: luigidelmonte Jan 24, 2020
    16 replies
  • Yahoomail ADS Solved/Closed

    If I follow these instructions, will I still see the yahoo ads and "news"? I was planning to open an Outlook account and just forward Yahoomail to it...

    blueskylady | Outlook | Latest reply: HelpiOS Jan 22, 2020
    1 reply
  • Date Am and PM but need the date to change Solved/Closed

    Hello, I have 12 workbooks, what I am trying to figure out is I have the date and time in one cell. But I has it 1/1/2020 00:00 then them next lin...

    JeepTruck | Excel | Latest reply: TrowaD Jan 14, 2020
    2 replies
  • Copy x rows y times and then insert customer ID on each set of x rows Solved/Closed

    Hello, I have a set of criteria, 56 criteria as of now, and I have to check how many criteria each customer meets. In one tab I have the list of the ...

    Y7654 | Excel | Latest reply: TrowaD Jan 14, 2020
    1 reply
  • Transferring data autonomously to another sheet with certain text Solved/Closed

    Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Bot...

    achettri | Excel | Latest reply: TrowaD Dec 17, 2019
    2 replies
  • Populate data from a column in one worksheet to a cell in multiple other sheets Solved/Closed

    In a workbook, I want to be able to copy all the cells in column B of sheet "Raw Data" into multiple copies of an existing template sheet correspondin...

    Vee1893 | Excel | Latest reply: Vee1893 Dec 11, 2019
    4 replies
  • Using IF to compare time values Solved/Closed

    Hello, So basically I have a huge column of time values (00-00-00 format) and I am trying to write a code that takes the time in one cell (B) an...

  • Find out date filling cells Solved/Closed

    Hi, First of all thanks for your help I have a big excel file which I have been filling it for the last 2 years. There is a way to find out the da...

    Marcus | Excel | Latest reply: Marcus Dec 6, 2019
    5 replies
  • Microsoft Word icon changed to unknown program Solved/Closed

    Hello, Recently my microsoft word (program) icon changed from the classic picture to the unknown programs icon. I wanted to know how to get the re...

    SV | Word | Latest reply: wmclaxton Dec 6, 2019
    21 replies
  • Convert Tamil PDF document to Word Solved/Closed

    Hello, how to convert a tamil font pdf file to word file with tamil font Still problem exists when i convert a word file the letter are not ...

    raje | Word | Latest reply: Aoife McCambridge Nov 26, 2019
    2 replies
  • How to hide text in a Excel cell and display it when needed Solved/Closed

    Hi friends I have doubt in excel. I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on the ...

    john_thomas | Excel | Latest reply: TrowaD Nov 25, 2019
    1 reply
  • Seperating time from text Solved/Closed

    Hello, I have a task in my office that i can't get done and it is very impossible to finish within 1 week as these are 14,000+ orders. The sheet ...

    luigidelmonte | Excel | Latest reply: TrowaD Nov 25, 2019
    1 reply
  • VBA: Delete empty rows based on value of cells Solved/Closed

    Hello, my code works transfer my invoice from sheet1 to sheet 2 but my problem i would adjusted my code to become delete rows from a19: e32 i...

    abdelfatah_0230 | Excel | Latest reply: TrowaD Nov 4, 2019
    15 replies
  • How to simply this Excel formula Solved/Closed

    Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...

    Rufus | Excel | Latest reply: TrowaD Oct 28, 2019
    3 replies
  • How to check if a cell contains "%" and calculate accordingly. Solved/Closed

    I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...

    N245 | Excel | Latest reply: Saurabh Oct 18, 2019
    7 replies
  • VBA Copy/Paste fixed range a number of times Solved/Closed

    Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...

    srinivas_kala | Excel | Latest reply: TrowaD Oct 15, 2019
    6 replies
  • Excel - IF function with multiple words Solved

    Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...

    Nick | Excel | Latest reply: user Oct 8, 2019
    14 replies
  • Find a date in a range of dates Solved/Closed

    Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...

    BrianGreen | Excel | Latest reply: BrianGreen Oct 2, 2019
    4 replies
  • Unable to change date format in Excel Solved/Closed

    Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I doubl...

    rznbyz | Excel | Latest reply: Tobby Sep 6, 2019
    39 replies
  • IF statement Solved/Closed

    Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...

    MCiort | Excel | Latest reply: ac3mark Aug 30, 2019
    4 replies
  • How to find the latest time per name in a table with names and times Solved/Closed

    Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...

    anitatelecon | Excel | Latest reply: TrowaD Aug 27, 2019
    11 replies

    Dear CCM, I dont know "interest on term loan and working capital, profit before taxes and profit after taxes""..etc anybody can help me to solve...

    Ganesh_131 | Excel | Latest reply: ac3mark Aug 24, 2019
    1 reply
  • Summarise hours incurred by month based on multiple criteria Solved/Closed

    Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...

    Micwhsct | Excel | Latest reply: Micwhsct Aug 19, 2019
    4 replies
  • Open Office page numbering - start numbering on page 3 Solved/Closed

    I would like to know how to start the page numbering on page 3 instead of 1.

    Chris_PT | Open Office | Latest reply: HelpiOS Aug 14, 2019
    3 replies
  • Message to appear when 5 cells uncolored cells contain values. Solved/Closed

    Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...

    Fmss8404 | Excel | Latest reply: TrowaD Aug 13, 2019
    1 reply
  • Code to move rows into another sheet based on certain values Solved/Closed

    Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...

    Ryleecone | Excel | Latest reply: vcoolio Aug 13, 2019
    6 replies
  • Inserting an image without the white background Solved

    Hello, I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square appears ...

  • Auto-populate a sheet with data from different other sheets Solved/Closed

    Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...

    ThanatosTalos | Excel | Latest reply: ac3mark Jul 29, 2019
    59 replies
  • Copy rows to other sheets based on value in column Solved/Closed

    Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...

    MsBluebird | Excel | Latest reply: vcoolio Jul 26, 2019
    16 replies
  • Replace 'sheet' reference in a formula (not copy data, but get averages) Solved/Closed

    Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...

    cmigoya | Excel | Latest reply: vcoolio Jul 13, 2019
    5 replies
  • MS Word not displaying page numbers, images Solved/Closed

    Hello, So far MS word worked fine. But now it is not showing up images. Also not even page numbers. Instead showing up {Page}. Please let me know...

    Janu | Word | Latest reply: soroush Jul 10, 2019
    54 replies
  • Am not too good on percentage calculation Solved/Closed

    Hello please what is the 10 percent of,7200000000

    Anonymous | Excel | Latest reply: kieferschild Jul 10, 2019
    1 reply
  • Why do my PDF documents open in Word? Solved/Closed

    Hello, I can't figure out why my PDFs always get open in Word but not the Adobe program? Does anyone have a quick answer? Thank you so much! ...

    jills | PDF | Latest reply: tinman Jul 8, 2019
    32 replies
  • Macro to copy/paste down X times (where X is the number of rows) Solved/Closed

    Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...

    JW32 | Excel | Latest reply: TrowaD Jul 8, 2019
    41 replies