Excel Forum

Results 1 - 50 of about 9,830
  • 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
    14 replies
  • How to get the data in excel from Rest API using Excel VBA

    Dear Experts, I would like to build an excel file that allows me to see the time entered between two dates (Start date and End date). REST-based API...

    Raj_2823 | Latest reply: Raj_2823 Sep 19
    0 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
    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
    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
    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
    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 09
    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 05
    4 replies
  • How to extract text from column that got text

    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
    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
    1 reply
  • How to Speedup Formula processing

    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
    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
    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
    1 reply
  • Macro to automatically update a master sheet from multiple sheets Solved

    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
    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
    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
    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
    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
    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
    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
    1 reply
  • Convert

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

    Hlo | Latest reply: Hlo Jul 05
    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
    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
    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
    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
    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 02
    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
    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
    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 06
    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 05
    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 05
    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 03
    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
    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
    2 replies
  • Keep Track of Customers Service Visits

    Hi All, I need help in keeping track in excel of the customers service visits. I have customers that are visited weekly, some twice a month, most of...

    christossol | Latest reply: TrowaD Apr 11
    1 reply
  • Comp. value in 2 columns against a list and disp. text in 3r

    Hello, I need some help as I cant figure out how to construct this. I have been using a combination of IFS, AND, & VLOOKUP functions but I cant se...

    Rschewe1 | Latest reply: TrowaD Apr 11
    1 reply
  • Excel formula for filling another cell

    I have four columns in excel. Column A is named "Date" while Column B is named "Day". Column B depends on the value in Column B and I got the Formula...

    ejeruratyuuga | Latest reply: TrowaD Apr 07
    1 reply

    In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel...

    peterappiahkubi | Latest reply: Wofanat Mar 23
    2 replies
  • Conditional formatting in Sheets rows based on text in cell

    Hello, I have looked through some past answers and have not found a solution yet; I am trying to apply conditional formatting to a sheet where if te...

    Lindsey | Latest reply: Mazzaropi Mar 07
    1 reply
  • Code to move rows into another sheet based on certain values

    I found this lovely little script on this forum. It has worked flawlessly. I have a spreadsheet with multiple pages and I would like this code to work...

    Eagleeyes011 | Latest reply: vcoolio Mar 05
    6 replies
  • Macro: change cell color based on value in another cell

    Hello, I'm am trying to fix a spread sheet at work but what i need is a macro that i can run to do the following if the word Traffic appears in...

    randal.hite | Latest reply: TrowaD Mar 03
    1 reply
  • Autogenerate alphanumeric ID numbers in Excel? Solved

    Hiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...

    NoTechKnowle... | Latest reply: vcoolio Mar 02
    3 replies
  • search across all open workbooks for user defined criteria Solved

    Here is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...

    Tbonekiller | Latest reply: TrowaD Mar 01
    5 replies
  • auto-fill items repeatedly for two sheets based on another Solved

    Hello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...

    leapout | Latest reply: TrowaD Feb 24
    3 replies
  • Copying a row based on a integer in a cell Solved

    Hello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...

    Sheepy_777 | Latest reply: TrowaD Feb 24
    5 replies
  • Automatically creating code like OTP

    Hello, I want to make some automatically code or number against once I enter data in cell. I mean it's like OTP number . It's not necessary that it'...

    Deepak | Latest reply: TrowaD Feb 17
    1 reply
  • how split column into multiple columns for multiples sheets Solved

    Hello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...

    Hasson_6770 | Latest reply: Hasson_6770 Feb 15
    6 replies
  • UserForm VBA excel. Saving data depending on the parameters

    Hello, I created a UserForm through Excel VBA with the data text input which contains dates (ex. 2015,2016 etc.) I need this data to be put into d...

    gogazapr | Latest reply: TrowaD Feb 08
    1 reply
  • Reference and tranpose cell information

    Hello, I am trying to get get the formula in SHEET 2 ROW 3 to copy the data from SHEET 1 COLUMN D. I tried to just copy and paste or copy and dra...

    Rokky | Latest reply: TrowaD Feb 08
    1 reply
  • match & add missed items between two sheets Solved

    Hello, I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 . ...

    abdomegahri | Latest reply: TrowaD Feb 08
    12 replies