Excel Forum

Ask a question
Results 1 - 50 of about 9,850
  • How do I set the height of rows in Excel all at once ?

    Hello, How do I set the height of rows in Excel all at once instead of doing them one click at a time by clicking and dragging and dropping the indic...

    xarzu | Latest reply: xarzu Mar 18
    0 replies
  • How do I change the backgroud of a cell or a whole section?

    Hello, I have a question. How do I change the backgroud of a cell or a whole section? I want to differentiate one set of data from anoter set based...

    Xarzu | Latest reply: Xarzu Mar 17
    0 replies
  • How NOT to show False in the following example.

    Hello, I wish the formula to return a blank cell if there a blank cells in the formula. =IF(C27="BUY",((D30-D27)*10000),IF(C27="SELL",((D27-D30)*1000...

    Peter | Latest reply: Herminaandrews Mar 12
    1 reply
  • Drop down

    Hello, I have a workbook with one main sheet and lots of rows to be filled. There is one column with a drop down with 3 selection. How can I copy ...

    Moana | Latest reply: vcoolio Feb 10
    3 replies
  • Create Multiple Workbooks With Template At Once

    Hello, I'm being tasked with copying a single workbook with a special layout in it and copying it about 90 times with the file name corresponding to a...

    Dak903 | Latest reply: Dak903 Jan 16
    4 replies
  • Adding last week position to a weekly record survey

    Hello, I am compiling weekly record charts of the most popular records. How do I add the last week position to each song on each new record list in E...

    oraclewjr | Latest reply: TrowaD Jan 16
    1 reply
  • How to pull data from column based on multiple criteria?

    Hi Expert, I'd like to combine a column value in Mainsheet, where the column values are pulled from Sheets 1 and 2 of the same Excel file using VBA c...

    Raj_2823 | Latest reply: TrowaD Jan 16
    3 replies
  • copy a data from one sheet to another

    I have a Master list (Sheet 1) that contains house numbers and personnel assigned to them. I want to copy the entire row with the data assigned to eac...

    roberttripoli | Latest reply: TrowaD Dec 27, 2022
    3 replies
  • Formula to return text

    I need to have a formula to return text from text. I will give example; If column A = 7am then I want column B to say Days If column A = 3pm then I...

    stever | Latest reply: TrowaD Nov 21, 2022
    2 replies
  • Create Christmas present schedule

    Hello EXCEL GENIUSES OF THE WORLD! I am trying to save my entire family money and a feeling of obligation to buy a gift for EVERY DANG KID in our fam...

    DPENARANDA | Latest reply: TrowaD Nov 21, 2022
    1 reply
  • Formula to recognize Fical Year to Reset Paid days off

    Hello, I am trying to make a formula that will choose certain rows from each month in a calendar year that have hours in them, subtract from a total ...

    Gail1954 | Latest reply: TrowaD Nov 21, 2022
    1 reply
  • compare 2 columns to find the 3rd value and return the 4th

    Hello, Here in my example, if value in Column B (table 2) matches with the value in column A (table 1), then I need to check the first row corre...

    salu | Latest reply: TrowaD Nov 8, 2022
    4 replies
  • Coloring cells in sheet 2 based on data sheet 1 Excel VBA Solved

    Hi!  I would like to ask a question about using VBA for colouring a cell in sheet 2 based on a value of a cell in sheet 1. I want to write a code in ...

    Sue-Ellen1994 | Latest reply: Sue-Ellen1994 Nov 4, 2022
    4 replies
  • UDF for Attendance register Solved

    Hello, I have used your UDF as shown below to report a date whenever an entry is made in a row of my excel sheet. Function LastAttendanceDate(mDate...

    slinger42 | Latest reply: Slinger42 Nov 3, 2022
    2 replies
  • 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 Nov 3, 2022
    3 replies
  • Excel filter some data from other two sheets and copy back

    Hi, I have some query related to excel where i have to get some results as described below: Excel Sheet 1: Excel Sheet 2: Excel Sheet ...

    SAGO_1304 | Latest reply: TrowaD Nov 1, 2022
    1 reply
  • How Sum the Column value in Excel via VBA based on criteria? Solved

    Hello All, I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" c...

    Raj_2823 | Latest reply: TrowaD Oct 10, 2022
    2 replies
  • Basic Copy/Paste, multiple sheets and Databases

    Hello all! I’m not good with this, so I’m am reaching out to those who are. I can record and run basic macros, but this is above my skill level. I’ve...

    Eagleeyes011 | Latest reply: Eagleeyes011 Sep 29, 2022
    14 replies
  • Find text in multiple cells and return different text

    Hello, I am a teacher trying to find an alternative to manually entering data for single children and a way of simply analysing it.  I have created a...

    MLloyd81 | Latest reply: MLloyd81 Sep 18, 2022
    5 replies
  • Apply Conditional Formatting Across Several Cells Solved

    Hello, I want to change the color of a row if there is text in column A of that row.  I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...

    RDavis | Latest reply: rdavis Sep 12, 2022
    2 replies
  • Formula for Outputting Value from Dropdown List

    Hello, I need assistance with finding a way to output the value of cell based on the text it's associated with in a drop down list. Below is a scre...

    olsatch | Latest reply: TrowaD Sep 12, 2022
    1 reply
  • How to add Rows automatically based on Cell Value In Excel? Solved

    Hi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...

    Raj_2823 | Latest reply: TrowaD Sep 12, 2022
    7 replies
  • populate values in textbox based on combobox ,optionbutton Solved

    Hello, I  have  the  items  in column B  in sheet1,2,3   and  the  prices  in columns F,G  for sheet1,2      and  the  prices  for columns F  for  sh...

    Mussa_8911 | Latest reply: Mussa_8911 Sep 9, 2022
    6 replies
  • Running a macro in different cells Solved/Closed

    Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...

    Rinat | Latest reply: Helmy Sep 5, 2022
    4 replies
  • How to extract text from column that got text Closed

    Hello, I would like help on how to extract text from column which has text. Some column might not have text or blank, want to know how to extract th...

    Manjit | Latest reply: Jameswalter2050 Aug 27, 2022
    2 replies
  • how to convert excel to pdf in tamil font Closed

    Hello, how to convert excel to pdf in Tamil font

    Amutha | Latest reply: Jameswalter2050 Aug 27, 2022
    1 reply
  • How to Speedup Formula processing Closed

    I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value. This function is working fin...

    DevopRaj | Latest reply: Jameswalter2050 Aug 27, 2022
    2 replies
  • Generating invoice number automatic without repetition Solved

    Hello, please I need help , I want VBA CODE  to Generating invoice number  automatic without repetition in my excel any time type in the next cell it...

    SOLOMON231 | Latest reply: TrowaD Aug 25, 2022
    3 replies
  • pasting a column into alternating rows in new column

    Hello, i have a column of ID numbers and a column of names next to it, I want to copy and past the names with their corresponding id in cell under the...

    Kusay | Latest reply: TrowaD Aug 16, 2022
    1 reply
  • Macro to automatically update a master sheet from multiple sheets Solved/Closed

    Hello, I have a file with a master sheet and 6 different individual sheets. Each sheet is considered a project. It includes person's information a...

    Monu | Latest reply: TrowaD Aug 16, 2022
    17 replies
  • Working with multiple worksheets in a workbook Solved

    Hello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...

    buffala77 | Latest reply: vcoolio Aug 11, 2022
    7 replies
  • Conditional formatting as text, unless cell is a certain col

    Hello, If I  create a conditional formatting rule for column A to turn a color given work "General" How do I make it so that it turns "General" that...

    ChloeG | Latest reply: ChloeG Jul 26, 2022
    0 replies
  • Compare 2 columns if it matches all columns must go toSheet2

    Hello, Thank you for putting the time aside to help me. There are 2 sheets, Summary and Journal. Step 1: In the Summary sheet, I added Column E to ...

    Reinette | Latest reply: abdelfatah_0230 Jul 23, 2022
    1 reply
  • Indirect Ref# error

    I use a formula to set the name of my sheet (using VBA to move data around) to a number based on a cell value. The value is always a number and if the...

    Tbonekiller | Latest reply: Tbonekiller Jul 20, 2022
    0 replies
  • master sheet to auto populate from multiple sheets

    hello! could someone kindly assist me with a formula or a macro that will auto populate/update the master sheet  using information from sheets A-E. t...

    Mukundi_001 | Latest reply: vcoolio Jul 19, 2022
    3 replies
  • Move rows to another sheet based on values in column A

    Hello, I am trying to have rows in sheet "KEY" automatically moved to sheet "INACTIVE DRIVERS" if the cell in column A is "Inactive". I have looked...

    amcrawford | Latest reply: vcoolio Jul 14, 2022
    1 reply
  • Convert

    Hello, Sir/madam how to convert 30-1-2009in words

    Hlo | Latest reply: Hlo Jul 5, 2022
    0 replies
  • How to lock in specific cells in a formula going down rows Solved

    Hello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...

    JoshL | Latest reply: JoshL Jun 27, 2022
    2 replies
  • Counting and stop counting in a cell

    Hello, I need to create a formula for a cell involving number of days between dates. A2 - start date B2 - lead time C2 - end date D2 - showi...

    jerome | Latest reply: TrowaD Jun 21, 2022
    1 reply
  • Hello friends. Please help ! COUNTIF formula ? Solved

    Hello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...

    realest25 | Latest reply: TrowaD Jun 13, 2022
    3 replies
  • Highlight cell if another cell contains specific text

    Hello, I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 h...

    Abbi | Latest reply: vcoolio Jun 10, 2022
    1 reply
  • change cell color of all cells in my formula

    I often have huge spreadsheets where I have to add random cells together. In order to make sure I don't miss any cells, I want to change the color of ...

    jlindgren | Latest reply: JessyLew Jun 2, 2022
    2 replies
  • Excel formula to check if cell contains a date

    Hello, Hi, I am trying to write a formula to check if there is DATE value in a particular cell. If there is a DATE value, need to say "DELETED...

    Aniruddha | Latest reply: TrowaD May 30, 2022
    1 reply
  • Automatically update one sheet from multiple other sheets Solved

    Hello, I have a workbook with each office location having its own sheet to keep track of project information all with the same column headings. Co...

    zboneill | Latest reply: vcoolio May 20, 2022
    7 replies
  • Create and populate sheets based on values in master list

    I have seen a few similar forms but cannot seem to achieve the functionality I'm hoping for. My workbook will have a master spreadsheet that is per...

    chorton2 | Latest reply: vcoolio May 6, 2022
    3 replies
  • Formula to compare 2 columns and count missing values

    Hello, I have an Excel spreadsheet where I want to compare values between two columns A and b and to see if any values are missing in column b. ...

    Mikey150 | Latest reply: rizvisa1 May 5, 2022
    2 replies
  • Email notification when cells in a column are changed

    Hello, I am trying to set up a macro to send an email when a cell changes in a certain column in excel. I used a conversation in this forum that g...

    ITJennyS | Latest reply: rizvisa1 May 5, 2022
    1 reply
  • Conditional format B1 based on a specific word in A1 & calc

    Hello, I would like to check how to use the conditional formatting to get a colored cell in B1 containing numbers (based on a "INC VAL" in Cell A1...

    Sorrow81 | Latest reply: Sorrow81 May 3, 2022
    4 replies
  • summing values based on matching column across sheets Solved

    Hello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...

    leapout | Latest reply: leapout Apr 26, 2022
    6 replies
  • how to copy data after at a fixed cell Solved

    Hello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...

    skprma | Latest reply: skprma Apr 13, 2022
    2 replies