Excel Forum

Ask a question
Results 251 - 300 of about 9,830
  • Transfer data from one Excel file to another Closed

    Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?

    doanphan111 | Latest reply: HelpiOS Nov 2, 2019
    1 reply
  • 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 | Latest reply: TrowaD Oct 28, 2019
    3 replies
  • VBA Compare 2 sheets and output difference to 3rd sheet Closed

    Hello, I am trying to make a button on VBA that will take compare two excel sheets, and identify new numbers in a certain column and copy and past...

    jmah | Latest reply: TrowaD Oct 22, 2019
    3 replies
  • Serial numbers Closed

    Hi, Can someone help me create a series of numbers? I ran out of numbers. Please help me do this numbers. I need maybe 5000 numbers for this. here is ...

    luigidelmonte | Latest reply: luigidelmonte Oct 20, 2019
    2 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 | Latest reply: Saurabh Oct 18, 2019
    7 replies
  • FindAll This custom function returns Find and FindNext results as an array of va Closed

    Find All This custom function returns Find and FindNext results as an array of values. It will find all the instances of a string (sText As String) a...

    RodwellSmith | Latest reply: TrowaD Oct 17, 2019
    1 reply
  • VBA Stops Running When it Reaches a Blank Cell Closed

    Hello Everyone, I have an Excel spreadsheet that I am preparing for use. In the spreadsheet, i have a VBA macro set up to transfer out data from t...

    Fenrir91_9 | Latest reply: TrowaD Oct 15, 2019
    1 reply
  • 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 | 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 | Latest reply: user Oct 8, 2019
    14 replies
  • Calcul de prévision des livraisons de colis sur les deux prochaines années Closed

    Bonsoir, J aimerai faire une projection sur Excel pour les 2 prochaines années,pour ce faire je dispose des données des livraisons de colis pour 2027...

    cotuitioj | Latest reply: TrowaD Oct 3, 2019
    1 reply
  • Mac: Copy rows to Master sheet based on cell condition Closed

    I am an insolvency professional. I keep details of processes to be conducted on different companies alongwith their time lines. The different columns ...

    mvdiamond | Latest reply: TrowaD Oct 3, 2019
    4 replies
  • adjust code show message about brand Closed

    hi i would helping to adjust my code i have data in my sheet a,b ,c columns a= item , b= brand, c= quantity and userform textbox1,2,3 when...

    abdelfatah_0230 | Latest reply: abdelfatah_0230 Oct 3, 2019
    5 replies
  • Mac: Copying row of data that contains dates between two specified dates. Closed

    Hello Friends, I am reasonably good at excel but have never used macros or VBA. I have multiple workbooks one for each company which has similarly...

    mvdiamond | Latest reply: mvdiamond Oct 3, 2019
    0 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 | Latest reply: BrianGreen Oct 2, 2019
    4 replies
  • how to merge bank statement into one column Closed

    Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should be i...

    Faisal | Latest reply: thanks_4_nothing Sep 30, 2019
    3 replies
  • Excel VBA Sorting Problem Closed

    Hello, This code is placing all the header names in the last row after sorting in descending order. Can you please help how to keep the position of ...

    Hassan | Latest reply: vcoolio Sep 29, 2019
    3 replies
  • Spell number in Excel Closed

    Hello, thanks for your coding when i use your coding to convert the number in to Text it will shown as like this for 12 (Rupees Twelve)only , ...

    Sivanesh | Latest reply: Sivanesh Sep 28, 2019
    0 replies
  • Copy data to a master sheet from newly created sheet Closed

    Hello, I have a master sheet that I want to automatically fill. I have a macro that creates a new sheet for each instance, I now need another to ...

    Wraggy | Latest reply: TrowaD Sep 24, 2019
    1 reply
  • Creating Graph that updates Closed

    Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I would ...

    Ryleecone | Latest reply: vcoolio Sep 21, 2019
    6 replies
  • VBA SUM DATA between 2 sheets Closed

    hi, expert i have sheet1 contain data from range a4:e and the sheet2 contains data from range a3:g i would sum the data in sheet1 from b4:e and s...

    abdelfatah_0230 | Latest reply: TrowaD Sep 19, 2019
    5 replies
  • Need to extract the data from one page to another page based on the unique numbe Closed

    Hi i have data like below mentioned format, need to extract and paste it in another sheet, please help me in it. DEAL_NO DEAL_DATE APPLICATION_OFF...

    LakshmiKanth | Latest reply: ac3mark Sep 17, 2019
    1 reply
  • VBA Coding Closed

    I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1 of sh...

    chauhanskapil | Latest reply: TrowaD Sep 9, 2019
    1 reply
  • Arrow keys not working Closed

    Hello, my arrow keys are not working. up down left right

    Hansraj | Latest reply: Ratnendra Ashok Sep 9, 2019
    1 reply
  • 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 | Latest reply: Tobby Sep 6, 2019
    39 replies
  • Excel 2013 to extract text in one cell Closed

    Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to ext...

    Fiddler123 | Latest reply: TrowaD Sep 5, 2019
    1 reply
  • how to transfer data from sheet to sheet 2 Closed

    Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that needs ...

    Herisha | Latest reply: TrowaD Sep 3, 2019
    9 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 | Latest reply: ac3mark Aug 30, 2019
    4 replies
  • Dynamically Assign a Number in Data Set Closed

    Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can assign...

    iluvhc | Latest reply: TrowaD Aug 29, 2019
    3 replies
  • transfer data from userform to sheet with the same format of table Closed

    hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in userform ...

    abdelfatah_0230 | Latest reply: ac3mark Aug 28, 2019
    7 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 | Latest reply: TrowaD Aug 27, 2019
    11 replies
  • Need to create linked sheets Closed

    Hello, I have an excel sheet this is for a list of unavailable items however I need to create another sheet for 1 specific team. So my sheet is lik...

    luigidelmonte | Latest reply: TrowaD Aug 26, 2019
    8 replies
  • SUMPRODUCT Based on WBS Closed

    Ebti59 | Latest reply: ac3mark Aug 26, 2019
    7 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 | Latest reply: ac3mark Aug 24, 2019
    1 reply
  • get help Macro sheet Closed

    Hello, My name is vivekanandan i am try to create macro sheet like compare two different excel file and get the output in new excel file but i am ...

    vivekanandan | Latest reply: ac3mark Aug 23, 2019
    1 reply
  • Spreadsheet help moving data Closed

    So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being entered....

    Tbonekiller | Latest reply: ac3mark Aug 22, 2019
    4 replies
  • Excel vba to color row based on wbs level Closed

    Hello I need a macro to change row color based on "Level" column. Thanks Ebti

    Ebti59 | Latest reply: ac3mark Aug 21, 2019
    1 reply
  • Copy from one cell and paste to another sheet based on length of another column Closed

    Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data f...

    Ski4q | Latest reply: ac3mark Aug 21, 2019
    3 replies
  • 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 | Latest reply: Micwhsct Aug 19, 2019
    4 replies
  • Are you still taking questions? Closed

    Hello, Are you still taking questions?

    Somnonaut | Latest reply: Somnonaut Aug 13, 2019
    5 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 | 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 | Latest reply: vcoolio Aug 13, 2019
    6 replies
  • create an ordering list for our consumables Closed

    Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an orde...

    anewskillofhelp | Latest reply: ac3mark Aug 12, 2019
    17 replies
  • False Value removal Closed

    Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))

    Jumita | Latest reply: ac3mark Aug 9, 2019
    1 reply
  • Checking the values in Sheet1 with multiple entries in Sheet2, Write the output Closed

    Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values from Sh...

    shreven | Latest reply: TrowaD Aug 8, 2019
    1 reply
  • Creating a data input sheet with excel Closed

    Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent t...

    excelmatt23 | Latest reply: TrowaD Aug 6, 2019
    1 reply
  • Count cells containing text per row Closed

    Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time ...

    c | Latest reply: TrowaD Aug 6, 2019
    1 reply
  • Excel Formula to identify similar text Closed

    Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word wit...

    Reinette | Latest reply: TrowaD Aug 6, 2019
    5 replies
  • Search using variable Closed

    Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in the ...

    Roger | Latest reply: ac3mark Jul 29, 2019
    1 reply
  • 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 | 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 | Latest reply: vcoolio Jul 26, 2019
    16 replies