Excel Forum

Ask a question
Search
Close
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
  • HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS Closed

    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