Excel Forum

Ask a question
Results 101 - 150 of about 9,870
  • VBA code: calculating time difference Closed

    Hello, this is my code i try update the data automatically but the macro is not working of the updating part datetime auto_cycle tool time_differe...

    vathsala | Latest reply: TrowaD Nov 4, 2021
    1 reply
  • How can I link optionbutton and textbox based on selected from combobox Solved/Closed

    Hello, hi actually I got this codes from another web and mod some . it succeed and works , but my question how should link with the others tools ...

    abdelfatah_0230 | Latest reply: TrowaD Nov 4, 2021
    5 replies
  • Copy & Paste Closed

    Hello, I copied Sheet1 Names( A2:A6) and select the Sheet2 Paste Names (B2). The same name paste entire (B) up to end row . If Sheet2 (A) ro...

    Bala | Latest reply: vcoolio Nov 3, 2021
    5 replies
  • Multiple IF arguments Solved/Closed

    Hello, I am trying to get Excel to look at data in two cells and depending on the combination it finds in those cells, record a different TRUE sta...

    Tim | Latest reply: Tim Nov 2, 2021
    2 replies
  • add missing data before TOTAL row after matching between two sheets Solved/Closed

    Hello, I'm new begginer in vba and I hope some help I have data in two sheets . should match data beween them. the match depend in COL ...

    Mussa_8911 | Latest reply: TrowaD Oct 18, 2021
    5 replies
  • create excel spreadsheets that update from a master sheet Closed

    Good Morning I need to create a master list of individuals in a specific program on a master list that covers all counties in Maryland. I want to b...

    waynem | Latest reply: TrowaD Oct 14, 2021
    1 reply
  • Code to move rows into another sheet based on certain values Solved/Closed

    Hello, I've seen different variations on this question, but haven't seen any answers that specifically address moving rows based on multiple value...

    jcbbach | Latest reply: vcoolio Oct 8, 2021
    3 replies
  • cell value = sheetname to pull information from in excel formula Solved/Closed

    I am trying to pull data from another sheet using the formula (located in B26) below, but I want to replace the sheetname ('9.60'! in this case) with ...

    Tbonekiller | Latest reply: TrowaD Oct 4, 2021
    3 replies
  • Return Seq Values Until Blank value then return different set of seq values Solved/Closed

    Hello, What is a formula to return a specific set of values in sequential cells until the reference sequence returns a blank value then start return...

    lorieb63 | Latest reply: TrowaD Sep 30, 2021
    1 reply
  • Sorting table without messing up formulas Closed

    Hello, I'm trying to create an excel file to manage my diet and meal plan and counting macros. I have in the same file a table filled with differen...

    Matpi | Latest reply: TrowaD Sep 27, 2021
    1 reply
  • how deal with this complicated code and updating(subtraction between two sheets) Solved/Closed

    Hello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...

    Hasson_6770 | Latest reply: TrowaD Sep 27, 2021
    11 replies
  • I want to find date of joining Solved/Closed

    Hello everyone i have a attandance sheet like this i want to find date of joining by formula. Mean on which date from 1 to 31 he started to work i w...

    Ansh_5770 | Latest reply: TrowaD Sep 20, 2021
    1 reply
  • Compare 2 sheets, 2 columns, copy/paste matching data to third sheet. Closed

    Hello, In response to this link https://ccm.net/forum/affich-756470-comparing-two-excel-sheets-and-copying-like-data-to-third-sheet I am using...

    Mustangboss23 | Latest reply: vcoolio Sep 20, 2021
    3 replies
  • i need to find date of joining Closed

    Hello, i have a worker attandance register of 100 employess and i want to find there joing date to the sheet from which date they started to work .as ...

    ansh | Latest reply: HelpiOS Sep 19, 2021
    3 replies
  • How do I compare two worksheets where added value will copy to sheets3 Solved/Closed

    Hi, is it possible to get output as below where original in sheet1 and sheet2 will added 1 then in sheet3 it will sum the qty which previous qty is 2 ...

    aze_123 | Latest reply: TrowaD Sep 14, 2021
    5 replies
  • How to rank the last top ten students Solved/Closed

    Hello.. Am a teacher.am preparing results of 126 student.. So I need to find the last ten students among those 126.

    James07392 | Latest reply: James07392 Sep 9, 2021
    2 replies
  • VBA Code to Copy Worksheet multiple times and rename based on list Solved/Closed

    Hello, New VBA user.. I have created code to copy a worksheet multiple times and rename based on a list in excel. However, I am receiving an e...

    Hpence | Latest reply: rogerio Sep 4, 2021
    3 replies
  • How can I change a cell daily Solved/Closed

    Hello, I will try to explain the best I can, I have some cells 'A1, A2, A3, A4' that I fill up daily with numbers ex: -day1 I will input ...

    Pupic4fun | Latest reply: TrowaD Aug 30, 2021
    7 replies
  • Shared content between 2 cells on 1 sheet and on 2 sheets Solved/Closed

    Hello, I have cell 'A1' and cell 'B1' How cand I do a formula so I can tipe something in A1 and B1 is the same content, but I would like it bouth w...

    Pupic4fun | Latest reply: TrowaD Aug 30, 2021
    3 replies
  • What will MS Excel return when E2-F2 is entered in a cell? Solved/Closed

    Hello, What will MS Excel return when E2-F2 is entered into a cell?

    Joseph | Latest reply: TrowaD Aug 26, 2021
    1 reply
  • pop message into textbox on userform if number is exceeded Solved/Closed

    hello I have userform contains multiple comboboxes and textboxes . the comboboxes1,2,3 should match with sheet data in COL B,C,D ...

    Hasson_6770 | Latest reply: Hasson_6770 Aug 24, 2021
    13 replies
  • Duplicating rows multiple times in excel Closed

    Hello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row. Example: Befo...

    Ona_4053 | Latest reply: TrowaD Aug 23, 2021
    1 reply
  • merge data across multiple sheets in one sheet and calculate the values Solved/Closed

    hi I have data in multiple sheets the same structure some sheets have duplicated data so it should merge and summing the value...

    kalilme | Latest reply: kalilme Aug 18, 2021
    18 replies
  • Training Delivery Tracking Help Closed

    Hello, This question is a follow-up to another question I asked here and uses the same/similar files, code, and format as that question (at least in...

    excelnovice2019 | Latest reply: vcoolio Aug 15, 2021
    1 reply
  • Grey out an entire row in Excel 2010 depending on a cell's value Solved/Closed

    Hi all, I am trying to grey out an entire row in excel 2010 depending on a cell's value. Each cell has a drop down list: Yes, No, Maybe etc ...

    deeptis | Latest reply: T Aug 11, 2021
    11 replies
  • highlighted unmatched data between two sheets and merge data in summary Closed

    Hello, I have two sheets contain data from COL A: COL G if there are new data in sheet1 but are not existed in sheet2 th...

    leapout | Latest reply: leapout Aug 11, 2021
    1 reply
  • Multiple Mathmatical Calculations For Profit Solved/Closed

    Hi, I'm trying figure out how to create a formula to calculate profit from a row with multiple options. column n*o=a column p=b column q=c co...

    Tom268 | Latest reply: TrowaD Aug 5, 2021
    3 replies
  • Popup message when mandatory columns are not filled in a row in Excel Solved/Closed

    Hi All, Hope you are doing good! I want to popup an error message before saving. The requirements are for eg:- In this table, "Name & PhnNo" are ...

    Raj_1562 | Latest reply: TrowaD Aug 5, 2021
    5 replies
  • VLOOKUP problem Closed

    Hi ! I have an excel document where I'm trying to use a VLOOKUP formula, however it refers to N#A whereas the value actually is in the column. I...

    farreneit | Latest reply: zacharyswift727 Aug 4, 2021
    2 replies
  • If cell L2 has Text in it return Date in J2 Solved/Closed

    Hello, Can anyone help with this? I am designing a Task Tracker. The user wants a Date and Time to auotgenerate when Text is entered into a Ce...

    The397Life | Latest reply: vcoolio Aug 3, 2021
    3 replies
  • Algorithm and Flowchart Closed

    Hello, Write an Algorithm and flowchart to calculate total number of students passed in first division, second division and third division in ...

    Bishal | Latest reply: TrowaD Aug 2, 2021
    1 reply
  • Copy automatically columns if the criteria is met Solved/Closed

    Hello, I have simple workbook with 2 sheets. Sheet1 contains columns "Risk ID", "Risk" and "Response". Data would be for example ID1, "Cyber attac...

    kerwin | Latest reply: TrowaD Jul 29, 2021
    1 reply
  • Job Boards? Solved/Closed

    Hi, I am new here, just signed up today. There was an issue I was having with excel and found the solution. The solution was pasted exactly as ...

    Tom268 | Latest reply: TrowaD Jul 29, 2021
    1 reply
  • Transfer Data from One Sheet to another based on an if/then condition. Solved/Closed

    Hello there, I'm hoping to work with three lists (three sheets). First sheet, a master list, second sheet, a manager's list, third sheet, an emplo...

    apet134 | Latest reply: vcoolio Jul 28, 2021
    3 replies
  • Finding certain words in a cell and return a value based off the word found. Solved/Closed

    Hello, I need to find a certain word in a cell in a column and return text based on the value. Example of this is if the word Apple is in a cell in...

    shanej69 | Latest reply: TrowaD Jul 26, 2021
    1 reply
  • Excel Macro/Code help: Creating sheet for each name in column of another sheet Solved/Closed

    Hello! I am working on a project at my internship and ran into some issues finishing up some of the features I want to implement. The excel is a file...

    excelnovice2019 | Latest reply: vcoolio Jul 22, 2021
    21 replies

    Hi Guys I want Excel to highlight cells(in a column) based on the value(text) I select from a drop-down list in another column. So each time ...

    lcarolus20 | Latest reply: vcoolio Jul 22, 2021
    7 replies
  • I have a '0' that need's to be gone Solved/Closed

    Hello, I have a file with two sheets. In sheet2 I have cell A1 ='sheet1'!A1 (when I type something in cell A1 from sheet1 it's goes on A1 from shee...

    Pupic4fun | Latest reply: vcoolio Jul 21, 2021
    3 replies
  • How can I make the 'false' statement remove if blank Solved/Closed

    Hello, I have this simple formula =IF(J15"",J15-H15) I have that formula alocated to G8 and I want it to work only when I type something ins...

    Pupic4fun | Latest reply: Mazzaropi Jul 21, 2021
    3 replies
  • Excel if range of cell contain a text put a cell value in Solved/Closed

    Hi All, How do I put a cell value into a cell when the range of cell contain a specfic text. For example, in the sample below, I want to put the ...

    diegomagum | Latest reply: TrowaD Jul 13, 2021
    11 replies
  • Formula in excel for a date Solved/Closed

    Hello, Hope you are well. Please assist me with the date calculation in Column E and Column F. The 2012/02/29 date should show (29) because for tax ...

    Gerberreinette | Latest reply: TrowaD Jul 13, 2021
    3 replies
  • Change cell list values when another cell is changed Solved/Closed

    Hello, My calculations would go a bit further, and i don't really know if my issue can be solved by excel. I have multiple lists for speaker box...

    Rolnaashch | Latest reply: Rolnaashch Jul 5, 2021
    6 replies
  • Conditional formatting another cell based on text in a range Solved/Closed

    Hi I have a spreadsheet where columns A,B,C contain text (a subject studied at school) e.g. Maths, Science, Geography. I have 170 rows of this data...

    KB2383 | Latest reply: TrowaD Jul 1, 2021
    1 reply
  • Finding file names in a local folder Solved/Closed

    Hello, I have a large list of file names in excel worksheet. I am trying to find which of those files are NOT in the folder on the local drive...

    gogazapr | Latest reply: TrowaD Jun 29, 2021
    3 replies
  • VBA: Use password to go to sheet Solved/Closed

    Hi, I have a spreadsheet that is driven by VBA buttons that take you to different sheets, I need to password protect some of the sheets, but if an inc...

    Andy.top | Latest reply: TrowaD Jun 21, 2021
    1 reply
  • split data from multiple sheets to tables for summary sheet based on dropdowns Closed

    Hello, I have data about five sheets sometimes contain the same data are duplicated then should merge and summing the values as show in sheet summar...

    abdomegahri | Latest reply: abdomegahri Jun 7, 2021
    0 replies
  • Command Button Launches Default Browser Via One Line of VBA Code Solved/Closed

    I have a userform that allows me to use a webbrowser within it, however sometimes due to compatibility issues I need to use microsoft edge and use it ...

    ProWHP | Latest reply: TrowaD Jun 3, 2021
    1 reply
  • Download excel worksheet with formulas (calculation VAT inclusive) Closed

    The simple Excel formulas (calculation VAT inclusive) Hi there how do I download this example so I can work on it? Thanks Philip

    Status_5001 | Latest reply: TrowaD Jun 1, 2021
    1 reply
  • Macro to compare 2 columns and output list with singles and sheet reference Solved/Closed

    Hello, I am trying to write a macro to compare two different columns on two different sheets. and I want to print only the values that are not on ...

    Justdance | Latest reply: TrowaD Jun 1, 2021
    1 reply
  • How to split the Amount in excel formula or Excel VBA Code? Solved/Closed

    Dear All, Hope you are doing well!. I would like to copy the value in cell based on user input value. Below is the sample screenshot. The use...

    Raj_1562 | Latest reply: TrowaD May 31, 2021
    1 reply