Excel Forum

Ask a question
Results 101 - 150 of about 9,830
  • 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
  • Conditionally Formatting if another column contains a specific date Solved/Closed

    Hello, I have a spreadsheet where I am tracking requests. I want Excel to highlight the row if the item due date (column B) is NEXT month or has P...

    cjf15 | Latest reply: TrowaD May 27, 2021
    1 reply
  • Multiple logic formula Closed

    Hello, I have 2 columns with separate pieces of information: Column A = Wood or Plastic Column B = 1 or 2 How do I build a formula which ca...

    LTeron | Latest reply: Mazzaropi May 10, 2021
    1 reply
  • Formula to find last date of attendance Solved/Closed

    Hello, I have an excel sheet that enters the time taken by each student on each day for the whole month. The student names are in the rows and d...

    Reminv93 | Latest reply: TrowaD May 10, 2021
    1 reply
  • Moving the data into previous cell by using excel formula or VBA code Solved/Closed

    hi all, I am working as Master data analyst. While working with data I got a problem, I have almost 10,000-row lines each having multiple col...

    svtranjit | Latest reply: vcoolio May 7, 2021
    1 reply
  • How to copy cell value from one table to another table with Criteria Solved/Closed

    Hi, Please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" aut...

    Raj_1562 | Latest reply: vcoolio May 5, 2021
    4 replies
  • Create multiple copies of excel based on a single template Solved/Closed

    Hello there, I need your help. I need to create multiple excel workbooks using a single template and saving them based on a list of names which ...

    daher | Latest reply: TrowaD May 4, 2021
    9 replies
  • Need help: formula calculating values depending on value in drop down list. Closed

    I created a planning tool for my work. It's basically showing situation on a current week, put I need more from it for future planning and also, time ...

    urr100 | Latest reply: TrowaD May 3, 2021
    1 reply
  • Update Sheet 2: specific data is copy and pasted to next row on sheet1 Closed

    Hello, Please Help! I would like to copy and paste daily data I get onto sheet two. Then using a macro button, copy and past select data from s...

    excelnoooob | Latest reply: vcoolio Apr 30, 2021
    1 reply
  • How to fill Value in Cell if data is not available ? Solved/Closed

    Dear All, Hope you are doing good! I would like to fill the product name as below in Cell if the nearby cell value is filled with some other te...

    Raj_1562 | Latest reply: TrowaD Apr 29, 2021
    1 reply
  • create report balances for many customers Solved/Closed

    hi here this is the first post and I hope find what I'm looking for despite my request is not easy I have data in sheet1 contains...

    abdomegahri | Latest reply: abdomegahri Apr 26, 2021
    17 replies
  • How to store cell value in a variable excel vba OR Increase Cell Value in Excel Solved/Closed

    Dear All, Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store i...

    Raj_1562 | Latest reply: vcoolio Apr 24, 2021
    1 reply
  • How to create a new sheet based on student Id numbers Closed

    Hello, I am trying to find a code that can make a new sheet based on my students name and ID number. I want to be able for the program to copy the...

    bookman35 | Latest reply: vcoolio Apr 23, 2021
    2 replies
  • Change colour of range of cells based upon text from a drop down menu in another Solved/Closed

    Hi, I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. ...

    Jim1409 | Latest reply: TrowaD Apr 22, 2021
    1 reply
  • Automatically Run Macro from a calculated cell value change Solved/Closed

    Hello, I am not having any luck using this code(and haver tried others). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address...

    smiller | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • Numbering increamental base on value in another colum Closed

    Hello, I have different numerical value in one column (say A column), I need to put serial number in another (B) column based in value in A colum...

    RPS | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • Auto copy data from sheet1 to sheet based on criteria Solved/Closed

    Hello, I am trying to auto copy values from Sheet1, Col A to Sheet 2 only if criteria from Sheet1, Col b is met. I have tried so many different t...

    whatchatalki... | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • to highlight or catagorize the data Closed

    Hi, I am willing to prepare the data under the catagory used and unused list checking the data table (data_plan) suppose C4A-R1 is placed in any ce...

    stha_naren | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • VBA: Copy row ---> lookup value ---> paste in table Closed

    Hello, I need help copying a row then lookup a value and paste the row next to the value that has been looked up, constructing a table. Thanks...

    claudia | Latest reply: TrowaD Apr 20, 2021
    1 reply
  • match between two sheets and create summary Closed

    hello I'm a beginner in vba excel so I hope find assistance from the experts I have two sheets names are(sheet1,sheet2) I would compare data i...

    kalilme | Latest reply: kalilme Apr 20, 2021
    0 replies
  • transferring data Closed

    Hello, i am having trouble and hopefully someone can help me i am creating an invoice system for the company i am working for and i have created a s...

    tasha | Latest reply: vcoolio Apr 16, 2021
    1 reply
  • How to import multiple texte files to multiple Excel files using Power Query Closed

    Hello to All Need for help to import multiple csv/txt files to multiple Excel Sheets/files using Power Query Thanks

    Adama_69810 | Latest reply: Adama_69810 Apr 14, 2021
    0 replies
  • VBA New sheet and copy template Closed

    Hello, Im struggling abit. I want to make a button where I add a new sheet with a specific name. In this example, "App1". But I also want to c...

    Tinsmith | Latest reply: vcoolio Apr 10, 2021
    1 reply
  • Calendrier Closed

    Bonjour, Voici ma demande puisque je ne parviens pas à solutionner le problème ! En vue de mon prochain championnat, j'ai refait un nouveau calend...

    Caillou1360 | Latest reply: HelpiOS Apr 7, 2021
    1 reply
  • modified code copy data from userform to the empty last columns Solved/Closed

    hello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...

    leapout | Latest reply: leapout Apr 1, 2021
    17 replies
  • Information transfer Solved/Closed

    Hello, I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, ...

    bri_dubzz | Latest reply: TrowaD Apr 1, 2021
    1 reply
  • Rectify a specific value in specific rows from multiple sheets Closed

    Hello, I saw the answer given by Vcoolio that was very useful to me. And how to proceed with the rectification, on especific value, on rows from ...

    JDkas | Latest reply: TrowaD Mar 30, 2021
    3 replies
  • Copy Rows to multiple sheets based on drop down validation Solved/Closed

    Hello all, I have tried to find the answer to my query through other questions but can't put my finger on what to do. I would like to copy rows...

    Beckyx1 | Latest reply: vcoolio Mar 23, 2021
    5 replies