Excel Forum

Ask a question
Results 251 - 300 of about 9,870
  • Date counter and then stop when new date is entered Closed

    I am attempting to calculate the time between B9 and Z9. and the same with D9 and Z9. the person who created the file is only calculating from "Today'...

    slizott | Latest reply: TrowaD Mar 2, 2020
    1 reply
  • 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 | 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 | Latest reply: ad1959 Feb 11, 2020
    4 replies
  • vba error -2147417848 (80010108) automation error Closed

    So I am trying to make a spreadsheet that tracks our usage by diameter and individual serial number. I perform some basic checks using conditional for...

    Tbonekiller | Latest reply: Tbonekiller Feb 10, 2020
    8 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 | 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 | 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 | 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 | Latest reply: luigidelmonte Jan 24, 2020
    16 replies
  • 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 | 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 | 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 | Latest reply: TrowaD Dec 17, 2019
    2 replies
  • Averaging data on inserted rows in Excel Closed

    Hello, Please after successfully inserting specific number of rows in excel, is there any code that can help you average the data on the inserted ...

    kurugfrancis | Latest reply: TrowaD Dec 17, 2019
    16 replies
  • Calculating normalized standard deviation in rolling window Closed

    Hello, Please how do I calculate normalized standard deviation in a rolling window for positive and negative values?

    kurugfrancis | Latest reply: LamoIdiot5 Dec 12, 2019
    6 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 | Latest reply: Vee1893 Dec 11, 2019
    4 replies
  • Extracting images from a database but named with a specific cell content. Closed

    Hi there people! I could use some help... I'm currently importing product images from a database into Excel using the Visual Basic code below: ...

    Gordon02812 | Latest reply: TrowaD Dec 10, 2019
    20 replies
  • 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 | Latest reply: Marcus Dec 6, 2019
    5 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 | 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 | Latest reply: TrowaD Nov 25, 2019
    1 reply
  • adjusting code transfer data from combo box & textbox into userform to sheet Closed

    Hello, i would help adjusting this code it doesn't work it gives me error when i transfer data to sheet i want to begins transfer dat...

    abdelfatah_0230 | Latest reply: Facebook Nov 21, 2019
    12 replies
  • conditional formatting to show when job is done Closed

    HI, I have work tracking file. all is running good only i want to have conditional formatting in it. for example:- in sheet dme, column f12:f50 is...

    sanjeev02625 | Latest reply: TrowaD Nov 18, 2019
    1 reply
  • Excel project Closed

    I’m in pompano beach Florida searching for a freelancer for this excel project. Not much success yet. Any help would be appreciated

    Jpatierno | Latest reply: TrowaD Nov 18, 2019
    1 reply
  • Update Master / Summary Tab with all new entries in other sheets / tabs Closed

    Hello, I have a workbook with 9 worksheets; one of the sheets is the master; created to be the other 9 sheets compiled into 1. I need to set it up...

    santosjo | Latest reply: TrowaD Nov 18, 2019
    4 replies
  • Working on the same workbook from 2 locations Closed

    Hello, my name is Marshall and I'm a Logistics Planner. I have created a load schedule on Excel for every day of the week, depending on how many vehic...

    Marshall1983 | Latest reply: Facebookidioits Nov 12, 2019
    2 replies
  • 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 | Latest reply: TrowaD Nov 4, 2019
    15 replies
  • Excel linking to word Closed

    Hello, Please I need assistance, I want to link and excel worksheet to word document and be able to edit it on word without having to open the excel...

    harwin | Latest reply: HelpiOS Nov 2, 2019
    3 replies
  • 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