Excel Forum

Ask a question
Results 401 - 450 of about 9,850
  • Formatting a cell for multiple functions in Excel Closed

    Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I alrea...

    KeithSmith | Latest reply: ac3mark Jan 18, 2019
    9 replies
  • Split data into several rows of same data Closed

    Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro that...

    Valerija_0201 | Latest reply: ac3mark Jan 14, 2019
    1 reply
  • Send Automatic emails using Macros Closed

    If column F in any worksheet in entire workbook is changed to "Pending" send an email. Below is my macro so far. Sub Request() Dim OutApp As Ob...

    DrewTully | Latest reply: ac3mark Jan 10, 2019
    1 reply
  • Copy more than one cell in Excel if a condition is met Closed

    Hi, I need to copy more than one cell if a condition is met. It’s about student degree. If the degree between specific range, then I need to copy m...

    ELGazzar | Latest reply: ac3mark Jan 9, 2019
    1 reply
  • Pulling data from multiple sheets to master sheet Closed

    Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project...

    stuart999 | Latest reply: ac3mark Jan 7, 2019
    2 replies
  • VBA code to open non excel programs Solved/Closed

    Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM

    PM | Latest reply: Billybob Jan 7, 2019
    10 replies
  • Excel 2007 file Excel found unreadable content in <filename.xslx Closed

    Good day, I have a computer set of Excel files, all in working order, but today one of the files when opening gave an error: "Excel found unreadable ...

    kianbarrett | Latest reply: vl Jan 5, 2019
    2 replies
  • Problem with copy in one sheet Solved/Closed

    Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...

    kekserica | Latest reply: ac3mark Jan 4, 2019
    26 replies
  • I have a problem regarding how to automatically update data in other Sheets. Closed

    Hello, I m looking to have few different sheets that automatically updated based on information that is added or changed in master sheet. One shee...

    ZEE | Latest reply: ac3mark Jan 4, 2019
    2 replies
  • Automatically move an entire row of expired item from one sheet to another sheet Closed

    Hi, I have a problem with the code below. I am a store officer in the firm I am currently with, and monitory of expiring date of a product is par...

    Danielkyan | Latest reply: Ratnendra Ashok Dec 30, 2018
    1 reply
  • Copy worksheet from one workbook to another workbook in MS Office Excel Closed

    Hello, In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.

    SrinivasNittala | Latest reply: ac3mark Dec 28, 2018
    1 reply
  • I need VBA that creates a new sheet for every data entered in column D Solved/Closed

    Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...

    dmatrix00 | Latest reply: ac3mark Dec 26, 2018
    3 replies
  • Budgeting forumla in Excel Solved/Closed

    Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...

    nfez | Latest reply: nfez Dec 22, 2018
    2 replies
  • Macro in Excel Closed

    bonjour je bloque sur ma macro depuis plusieurs jours et j'aurais besoins d'aide j'ai un listing de 13 colonnes qui peut aller jusqu’à 50 lignes m...

    bugs77100 | Latest reply: Daniel Telele Dec 20, 2018
    1 reply
  • Copy rows n times in Excel Solved/Closed

    Hello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...

    Sarath | Latest reply: vcoolio Dec 20, 2018
    8 replies
  • Copy data from first sheet to other in Excel Closed

    I have a workbook for tracking service customers. I would like for some of the data entered in the first sheet (first name, last name, date & email ad...

    CabelaRay | Latest reply: TrowaD Dec 18, 2018
    4 replies
  • Excel conditional formula Closed

    Hello, I need to fixed date (not change by everyday) when A1 CONTAIN certain text like (IR) B1=Fixed date

    tamerhelmy | Latest reply: ac3mark Dec 17, 2018
    1 reply
  • VBA to compare column E from 2 sheets and copy entire row to sheet 3 Solved/Closed

    Hello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then co...

    Bryant | Latest reply: Bryant Dec 14, 2018
    2 replies
  • Excel function question Closed

    Hello, Which spreadsheet function in Excel will display 6 as the output in the following formula? =(36)

    1234ah | Latest reply: ac3mark Dec 14, 2018
    3 replies
  • Excel formula to track accrued vacation Solved/Closed

    Hello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they earn P...

    zonda216 | Latest reply: TrowaD Dec 13, 2018
    1 reply
  • If/then formula in Excel Closed

    I am trying to write a formula that will add a certain number of days to a date, based upon the written response in another cell ie: if H5="Admit/5 D...

    melkeenan13 | Latest reply: TrowaD Dec 13, 2018
    1 reply
  • Copy rows based on a condition Solved/Closed

    Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I...

    Blossom83 | Latest reply: ravichennai86 Dec 12, 2018
    30 replies

    Bonjour, j'ai un tableau sous excel et je veux le générer en pdf le problème je veux le converti en pdf mais dans un tableau de modèle différent

    hu_da | Latest reply: ac3mark Dec 11, 2018
    1 reply
  • How to merge data from different Excels Solved/Closed

    Hello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had...

    SAMARMANDKE | Latest reply: Ratnendra Ashok Dec 9, 2018
    1 reply
  • Master sheet and connecting other sheets Closed

    I am trying to make a master list of all my donors for charity. The master list will have less information on it then the following sheets. Bellow a...

    Goofymama | Latest reply: vcoolio Dec 7, 2018
    3 replies
  • Recalculation of dates Solved/Closed

    Hello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...

    BlairBiss | Latest reply: BlairBiss Dec 4, 2018
    4 replies
  • Sliding conditional formatting Closed

    Hi everyone, I am currently stuck in Excel with the conditional formatting. I would like to apply a color to a cell in column A, row 1 based on a for...

    mgrivetseyve | Latest reply: TrowaD Dec 4, 2018
    1 reply
  • IF function in Excel refrencing data from another cell Closed

    I have a column which has names (these change on a daily basis). I have dates in another cell and I want a formula that says a3="IF the date in cell ...

    carldavies75 | Latest reply: TrowaD Dec 4, 2018
    1 reply
  • Excel formula for copying data from one sheet to another Closed

    Hello, I have 10 columns and 142 rows of name of person and their details, Is it possible when I edit data from the first sheet, it will automaticall...

    Mia15 | Latest reply: Ratnendra Ashok Dec 4, 2018
    1 reply
  • Mask cells in Excel Closed

    Hello, I created a calendar / schedule under Excel with one month per sheet. Depending on the month. So for the month of February, for example, ...

    the cameleon | Latest reply: TrowaD Nov 22, 2018
    1 reply
  • Autofill number from Column B based upon text in Column A Closed

    Hello Is there a way to get excel to autofill a number on sheet 1 that comes from the column "B" on sheet 2; if the text in column "A" matches? ...

    alawson90 | Latest reply: TrowaD Nov 20, 2018
    1 reply
  • Auto fill dates Closed

    I am trying to figure out that if i make a change (like fill in a amount) in colum A1 (for example) that in colum E1 today's date will automatic appea...

    Andriesa | Latest reply: Andriesa Nov 19, 2018
    0 replies
  • Find and replace in Excel Closed

    Hi, This question is related to Excel 365. I have Sheet1 that has two columns. I Just gave a sample of word abbreviations. It has around 800. ...

    NehruKhandrika | Latest reply: TrowaD Nov 15, 2018
    1 reply
  • If function with printing tool Closed

    I have 3 column " Nu, Item, QTY" I want to print the cell who has a qty with the same Nu sort. nu item qty 1 ...

    Ahmed88888 | Latest reply: ac3mark Nov 13, 2018
    1 reply
  • Populate separate worksheets with data from main worksheet based on criteria met Solved/Closed

    Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...

    biancacabo | Latest reply: Jules_St-Germain Nov 12, 2018
    9 replies
  • Incorrect date while saving csv format Closed

    Hello, I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and reopens...

    Vivek | Latest reply: ac3mark Nov 12, 2018
    1 reply
  • Picking data from a table Closed

    Hello, I am going to apologise once again in advance as I am terrible at coming up with the right question when it comes to excel formulas hence why I...

    AdrianHowland | Latest reply: TrowaD Nov 12, 2018
    1 reply
  • Excel IF formula - Priority setting Closed

    Good day I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indica...

    Kobusdebeer | Latest reply: ac3mark Nov 7, 2018
    1 reply
  • VBA comparing two files via rows and copy difference to third file Closed

    Hello everyone! I'm new to VBA and need your help! I need two compare two files (File 1 and File 2). I need to compare rows in File 2 to rows in Fil...

    tatkse11 | Latest reply: ac3mark Nov 7, 2018
    1 reply
  • HELP with IF function Closed

    Hello, So I have a problem with my file. I need to use IF function, but I don't understand. The main thing is that I need to calculate the days tha...

    BigTommy | Latest reply: BigTommy Nov 4, 2018
    0 replies
  • Excel Closed

    I am trying to change date format to dd-mm-yyyy, but the format remains unchanged

    Rajini | Latest reply: Rajini Nov 3, 2018
    0 replies
  • Copy-paste some grid in excel Closed

    Hi All I know this topic is quite old by now but. Haven't found the solution yet. I tried to copy-paste some grid in excell when i noticed. It wasn'...

    Schwarzmann | Latest reply: Jules_St-Germain Nov 3, 2018
    1 reply
  • Conditional formatting Closed

    I want to make a formula in excel that if a cell in one column is not filled in within 7 days from the day in a cell in another column but in the same...

    Mike | Latest reply: Mike Nov 2, 2018
    0 replies
  • Paste value on filtered cells Solved/Closed

    Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...

    ehlblackstar | Latest reply: ac3mark Nov 2, 2018
    2 replies
  • Regarding all fields by selecting individual ID Closed

    Hello, I have a JSON file it contains 100 IDs and all their details, but when I type ID I need to get entire details of that person from JSON file...

    Surya | Latest reply: ac3mark Nov 2, 2018
    3 replies
  • Formula I should use Solved/Closed

    I am so confused on what formula should i be using for my work...? Which should be ending up like this...

    ehlblackstar | Latest reply: ehlblackstar Nov 2, 2018
    0 replies
  • Excel Cell Color change from another cell date fill up. Closed

    For Example, 1 item due date is 10/Nov/18 & showing yellow color. when the next cell will in-house 9/Nov 18 than the previous date color will move fr...

    Saifur | Latest reply: ac3mark Nov 1, 2018
    1 reply
  • Compare Excel sheets using Python Closed

    Hello, Can you please solve this question.To compare two excel sheets and copy unlike data to a third sheet which is not deduplicated.Can you plea...

    ramya515 | Latest reply: ac3mark Nov 1, 2018
    1 reply
  • A combination of SUMPRODCUT/ISNUMBER with LOOKUP Closed

    Hello all, hoping someone can help CELL (A) I have a question where, I have a column of data where there is a missmatch of data. CELL (B) I ha...

    Trinilad | Latest reply: ac3mark Nov 1, 2018
    1 reply
  • Background formatting from two values drawn from formulas Closed

    Hi. I've created a table displaying prices from suppliers. On the end two columns I've added a formula to show the header of the colomn which holds t...

    Nickthompson94 | Latest reply: TrowaD Nov 1, 2018
    1 reply