Excel Forum

Ask a question
Results 51 - 100 of about 9,850
  • summing values based on matching column across sheets Solved/Closed

    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/Closed

    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
  • Keep Track of Customers Service Visits Closed

    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, 2022
    1 reply
  • Comp. value in 2 columns against a list and disp. text in 3r Closed

    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, 2022
    1 reply
  • Excel formula for filling another cell Closed

    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 7, 2022
    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, 2022
    2 replies
  • Conditional formatting in Sheets rows based on text in cell Closed

    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 7, 2022
    1 reply
  • Code to move rows into another sheet based on certain values Closed

    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 5, 2022
    6 replies
  • Macro: change cell color based on value in another cell Closed

    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 3, 2022
    1 reply
  • Autogenerate alphanumeric ID numbers in Excel? Solved/Closed

    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 2, 2022
    3 replies
  • search across all open workbooks for user defined criteria Solved/Closed

    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 1, 2022
    5 replies
  • auto-fill items repeatedly for two sheets based on another Solved/Closed

    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, 2022
    3 replies
  • Copying a row based on a integer in a cell Solved/Closed

    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, 2022
    5 replies
  • Automatically creating code like OTP Closed

    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, 2022
    1 reply
  • how split column into multiple columns for multiples sheets Solved/Closed

    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, 2022
    6 replies
  • UserForm VBA excel. Saving data depending on the parameters Closed

    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 8, 2022
    1 reply
  • Reference and tranpose cell information Closed

    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 8, 2022
    1 reply
  • match & add missed items between two sheets Solved/Closed

    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 8, 2022
    12 replies
  • How to add rows that meet specific conditions Solved/Closed

    Hi Every week at work we get data about new jobs that have been completed at our company, and I add that data to a raw data tab. In the summary tab...

    SalinaSJames | Latest reply: vcoolio Jan 28, 2022
    1 reply
  • If then excel Closed

    Hello, If AA cell says not recorded, I need AB, AC, and AD to be shaded in red. I’ve read multiple forums and unable to find help for this. ...

    Chelle | Latest reply: vcoolio Jan 23, 2022
    1 reply
  • Changing values in one cell depending on drop down Solved/Closed

    Hello, I created a drop-down list of scores (ie. 10, 20, 30 to 100) in cell A1. In cell B1 I want it to show a specific number value based on which...

    NOVA007 | Latest reply: vcoolio Jan 21, 2022
    3 replies
  • 30 days prior date popup notification Closed

    Hello, I've currently done condition formatting on the expiry date column to turn RED 30 days prior to expiry using formula =AND($H2>TODAY(),$H2-TOD...

    filliords | Latest reply: vcoolio Jan 19, 2022
    5 replies
  • Start and stop counting at the zero value Closed

    Hello, How to insert a COUNTIF function to count values once it reaches to the first zero value to stop. And count again the cells between the first...

    Naima | Latest reply: TrowaD Jan 13, 2022
    5 replies
  • Excel Macro: compare 2 sheets and create result sheet Closed

    Hello, I have two excel spreadsheets, spreadsheet 1 a sheet that list device names, spreadsheet 2 has device/machine name and custodian. Need to ...

    wdouglas90 | Latest reply: TrowaD Jan 11, 2022
    1 reply
  • How? Transfer columnar totals only from 1 sheet to another? Closed

    Sheet 1: several columns of #s, each column totaled. I want to transfer the columnar TOTALS ONLY that were the result of formulae to Sheet 2. How do ...

    JC | Latest reply: vcoolio Jan 10, 2022
    1 reply
  • Trying to build a weekly sales comparison Closed

    Hello, I built a workbook that has as 8 weeks of of sales data. Each week contains the items that were sold with the quantity and and how much re...

    TrvAllen82 | Latest reply: TrowaD Jan 10, 2022
    1 reply
  • Conditional formatting: change fontcolor based on another cell Solved/Closed

    Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...

    wandanuila | Latest reply: Ravi Jan 3, 2022
    18 replies
  • IF function: Conditionally multiplying a value Solved/Closed

    Ok so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data us...

    BeastNZ | Latest reply: TrowaD Dec 20, 2021
    1 reply
  • EXCEL formula IF Closed

    Hello, Can someone help me? I want a formula to show OK if the cell beside it have some value. Example: A1: to be filled with D.O number (will o...

    Mayra | Latest reply: TrowaD Dec 16, 2021
    1 reply
  • Use Count and Find number of certain item Closed

    Hello, Use Count and Find number of certain items within a field range

    Beth | Latest reply: TrowaD Dec 13, 2021
    1 reply
  • copy adjacent Columns in excel if the ID numbers same Solved/Closed

    Dear all, I have ONE HELP in excel to copy two columns data( Qty & Amount ) from another sheet if the ID numbers are same.. I have created one...

    Ganesh_131 | Latest reply: TrowaD Dec 13, 2021
    1 reply
  • If cell contains multiple text how to add other cell value? Solved/Closed

    Hello, I am struggeling with my excel sheet and need help. I will rather give it in an example. A1 and B1 contains a price, C1 contains three s...

    Iza | Latest reply: TrowaD Dec 13, 2021
    1 reply
  • How to set Multiple selection to insert photo in this code Closed

    Hello, Can any one please slove this code. I want to get multiple photos at once. Here my code is supported to pick only single selection while goes...

    Charan | Latest reply: Charan Dec 10, 2021
    0 replies
  • match two sheets with another and highlight & create report Closed

    hello I have sheet"In & Out Balance" contains data .every month I will insert three columns it should match column B,C,D together with sheets(purchas...

    abdomegahri | Latest reply: abdomegahri Dec 3, 2021
    0 replies
  • Generating new file with multiple sheet template Closed

    Hello, I have a file that is currently generating new files based on a template file + a list of names. The problem is that the file is generat...

    Ana | Latest reply: vcoolio Nov 28, 2021
    1 reply
  • How to Insert an Image into an Excel Comment Box (Mac) Solved/Closed

    Hi I'm on Mac with Excel 16.53 and I want to insert an image into a comment box. I read this : https://ccm.net/apps-sites/software/4079-how-to-i...

    GNAGNAGNA | Latest reply: TrowaD Nov 22, 2021
    1 reply
  • How to calculate position (1st,2nd,3rd) in excel....? Closed

    Hello, Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in...

    abdulwajid | Latest reply: TrowaD Nov 22, 2021
    1 reply
  • Formula in excel to show amount in cell Solved/Closed

    Hello, I need a formula that show the amount in another cell if some text is found in another cell. Like this; A2: 500 B2: Done C2: result t...

    Mayra | Latest reply: vcoolio Nov 17, 2021
    3 replies
  • Copy and autopast rows from sheet1 to sheet2 IF Closed

    Hello, I woul like to Copy and autopast rows from sheet1 to sheet2 IF they are f ex "highlighted" or "bold" or "underlined" is something lik...

    Majk | Latest reply: TrowaD Nov 9, 2021
    3 replies
  • Excel assistance; IF formula to calculate remaining balance Closed

    Hello, How do I write a formula in excel that says if any cell contains a certain value, then calculate a remaining balance?

    Turner | Latest reply: TrowaD Nov 8, 2021
    1 reply
  • 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