Excel Forum

Ask a question
Results 501 - 550 of about 9,830
  • Comparing 2 worksheets in Excel Closed

    Hello, I wanted to compare 2 worksheet. If there is a different it return the as below Sheet 1: Apple vs Sheet2:Orange and if no different ...

    husna | Latest reply: TrowaD Aug 7, 2018
    1 reply
  • Recalculation in Excel Closed

    Hi friends I need a code. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. I press f9 once for eac...

    endoox | Latest reply: endoox Aug 6, 2018
    0 replies
  • need formula Closed

    1. If the cell in coumn Q contains CEMEX, put the value of “CEMEX Reuqest” in the new column cell 2. If the cell in column Q contains C...

    istiyaque12345 | Latest reply: istiyaque12345 Aug 3, 2018
    0 replies
  • Need macro copy info and save as new file Closed

    Hello everybody! I have 2 workbooks: Timesheet (T), FTE report (F) All would be starting on second row, as I have a header row on the F spreadsheet:...

    rpt878 | Latest reply: rpt878 Aug 2, 2018
    0 replies
  • Days from date and stopping counting issue Closed

    Hello, I am trying to create a new tracking sheet, and it focuses around this forumula I can't seem to find out how to fix. The formula I'm workin...

    gorillawar | Latest reply: TrowaD Aug 2, 2018
    2 replies
  • Making my macro independent on future Sheets Solved/Closed

    Hello All; 1st time posting anything so please bear with me. I really need some help and have going out of my mind for days with what I believe is...

    rizzob95 | Latest reply: vcoolio Aug 2, 2018
    7 replies
  • VBA to copy only values and not formula Closed

    I have this sentence in VBA that is working but it is copying the format as well . I really would appreciate. if you can tell me where to add Value s...

    Cherine | Latest reply: Cherine Jul 29, 2018
    0 replies
  • Basic formula in spreadsheet addition Closed

    basic formula in spreadsheet addition

    rene | Latest reply: rene Jul 25, 2018
    0 replies
  • Making formulas work, which work on other computer Solved/Closed

    Hello, My boss is using a large spreadsheet with multiply formulas in and has been using it for quite a while, updating the figures as and when ne...

    Hoffy | Latest reply: ac3mark Jul 25, 2018
    3 replies
  • Help creating a Macro Closed

    Hi, I am trying to create a Macro to copy paste the particular range of row in the same sheet based on the cell value in the previous sheet Sce...

    NanduB | Latest reply: ac3mark Jul 24, 2018
    1 reply
  • VBA: Create sheets from list Closed

    Hello, suppose i have value in column A from 1 to 10 then i want to create a sheet from 1 to 10 using macro System Configuration: Windows / C...

    jdamushte | Latest reply: TrowaD Jul 24, 2018
    2 replies
  • VBA Code - conditional formatting Closed

    Hello, in VBA, I want to do conditional formatting of cells in a column with below background & font colours. Below 25: (RED Background-RGB-255...

    SridharK | Latest reply: TrowaD Jul 19, 2018
    2 replies
  • Use a checkbox to copy a row and paste at end Closed

    Hi, Relatively new to VBA so please bear with me. I am looking to add a checkbox button that when clicked will replicate the row of data at th...

    PNyiam | Latest reply: ac3mark Jul 17, 2018
    3 replies
  • Multiple IF statements in Excel Solved/Closed

    Hello, I am trying to calculate a cell based on values , so if A1 =between 1 to 10 than it will equal 10.00 if A1 = between 11 to 20 that it e...

    nesto2008 | Latest reply: Nesto2008 Jul 17, 2018
    2 replies
  • Excel compare and return result Closed

    Hello, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in anoth...

    newbie881 | Latest reply: Zohaib R Jul 16, 2018
    3 replies
  • Searching two columns and displaying a third Closed

    Hello, Hello everyone...quick question...I need a formula to search data from two columns and find the single row which matches the specified criter...

    ahmetcandan | Latest reply: TrowaD Jul 16, 2018
    1 reply
  • Copy certain number of rows using VBA Closed

    Hello, Hello I am trying to copy a certain number of rows from sheet 1 to sheet 2 this number is dependent on a value i have set in sheet 3 A1. T...

    Excel934 | Latest reply: vcoolio Jul 15, 2018
    2 replies
  • Create New Sheet with specific format from row Closed

    Hello, I have a fixed report format named "Challan" which I need to prepare almost everyday with specific data. I want the macro by which by click...

    shibbirahamed | Latest reply: shibbirahamed Jul 15, 2018
    0 replies
  • Highlighting future dates Solved/Closed

    Hi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...

    Hoffy | Latest reply: Hoffy Jul 13, 2018
    4 replies
  • Copy rows to other sheets based on value in column Solved/Closed

    Hello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...

    Need_2Know | Latest reply: Need_2Know Jul 13, 2018
    2 replies
  • Highlighting future dates Closed

    Hi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...

    Hoffy | Latest reply: Hoffy Jul 11, 2018
    0 replies
  • Copying time fields down Closed

    Hello, I am attempting to put the time starting at 12:32:44 AM for 128 rows and click up the time by one second to 12:32:45 AM for the next 128 rows...

    Somnonaut | Latest reply: TrowaD Jul 10, 2018
    8 replies
  • How to change date format in Excel? Closed

    Hello, Sir I want change date format in 25-06-2018 to 25th June 2018 How can change 25 in Th letter in upper case Please tell me any one

    Manikanta | Latest reply: TrowaD Jul 10, 2018
    2 replies
  • Make userform Solved/Closed

    Hello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...

    Immortal | Latest reply: ac3mark Jul 9, 2018
    1 reply
  • Copy Cells to Separate Workbook Using VBA Closed

    Hello, I am attempting to take a range of data, in this case A1:I42, and copy it to a separate workbook. So I want to copy A1:I42 from Sheet 1 in ...

    ProWHP | Latest reply: ProWHP Jul 8, 2018
    3 replies
  • Find in column and Copy it's row code for Google s Closed

    Hello, I have created code in MS Excel for finding particular text in column and after finding text the entire row should be copy and add in next sh...

    Nvcworld | Latest reply: Nvcworld Jul 7, 2018
    9 replies
  • VBA code for create a copy of one excel file Closed

    Hello, I want a VBA code for create a copy of one excel file that contains all the contents without macros and also I want to send that work...

    Rajdavid | Latest reply: ac3mark Jul 6, 2018
    1 reply
  • How to change the format from date to number? Closed

    Hello, I need help to changed from date to number? System Configuration: Android / Chrome 67.0.3396.87

    Usshaa | Latest reply: Usshaa Jul 5, 2018
    0 replies
  • Copy command button in message box Closed

    Hello, I want to create copy command button through message box in VBA. In message box the information which is going to reflect should be copie...

    MUKUL_1308 | Latest reply: TrowaD Jul 5, 2018
    3 replies
  • VBA code for copy & paste items for multiple times Solved/Closed

    Hi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...

    andrewhu91 | Latest reply: andrewhu91 Jul 3, 2018
    4 replies
  • Create sheets for additions to list on sheet one. Solved/Closed

    I have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...

    Michelle | Latest reply: TrowaD Jul 2, 2018
    9 replies
  • Overwriting data during transfer Solved/Closed

    Sir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...

    MUKUL_1308 | Latest reply: MUKUL_1308 Jul 2, 2018
    3 replies
  • Date Formula counting days Closed

    Hello, If anyone could help me, I would greatly appreciate it, I need help with counting days if there is not an end date on the report. Ex: Count...

    Brande74 | Latest reply: Brande74 Jun 28, 2018
    8 replies
  • How to find the total tax? Closed

    The excel sheet below, shows different Items that are either purchased and paid up front, not paid or purchased through layby from AGRIQUIP. If Column...

    0882513011 | Latest reply: ac3mark Jun 27, 2018
    1 reply
  • Change date format in Excel Closed

    hi there i just need to make 1 cell for a date but with auto population of slashes so if i type 21062018 in the cell it comes up like 21/06/2018 ...

    kathycrooks | Latest reply: TrowaD Jun 26, 2018
    2 replies
  • Comparing two columns in Excel Closed

    Hello, I have to compare the following 4 columns; Code Amount Code Amount 100 213 101 25 101 465 ...

    sham | Latest reply: TrowaD Jun 26, 2018
    2 replies
  • Numerical value to appear in D31 automatically Closed

    1) Hi there, I'm trying to do a formula in a cell and need some help please. For the sake of this example, I'll be typing certain text into C31 and I'...

    bigalogigalo | Latest reply: TrowaD Jun 26, 2018
    1 reply
  • Autopopulate info from Master to individual WS Closed

    Hello, I have a series of data that are categorized by a prefix (P, UR, A, CAPA, etc.). I want to pull only the CAPA record information into a secon...

    PattiSmith | Latest reply: vcoolio Jun 21, 2018
    1 reply
  • counting days on a report Closed

    I need help with counting days if there is not an end date on the report. Ex: Count the days from the admission date to the end of the month I am do...

    Brande74 | Latest reply: Brande74 Jun 21, 2018
    0 replies
  • How to get the first worksheet only? Closed

    Hi I'm new in VBA. My program should let the user choose a folder of excel files. Then it will automatically copy all of the first worksheet to master...

    atut | Latest reply: atut Jun 20, 2018
    0 replies
  • Populate cells in worksheets from an updating list Closed

    I have a club workbook with 150 member Worksheets that need to be populated from the members list. First Member is starting with A2 Second A3 etc....

    LazyDave | Latest reply: LazyDave Jun 20, 2018
    2 replies
  • VBA code for command button Solved/Closed

    hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...

    MUKUL_1308 | Latest reply: MUKUL_1308 Jun 20, 2018
    4 replies
  • Multiple text in a cell Closed

    Hi Please can someone help I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add...

    AfsanaEssop | Latest reply: ac3mark Jun 19, 2018
    1 reply
  • Multiple columns into a single column Closed

    Hello, I am using excel 2013 and I want to convert a range of data with variable no. of columns and 24 rows to a single column (columns stacked on...

    Jags | Latest reply: Jags Jun 17, 2018
    0 replies
  • Vlookup where table arrary contains certain value Closed

    Hello, I have a "Key" Code Value 000 Black 123 White and another sheet with the data below Data Colour BKI000T GTEF123X...

    _Liv_ | Latest reply: _Liv_ Jun 16, 2018
    0 replies
  • Compiling data in excel Closed

    Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas...

    jdlt | Latest reply: ac3mark Jun 15, 2018
    1 reply
  • looking for VBA code. Closed


    MUKUL_1308 | Latest reply: Ambucias Jun 15, 2018
    1 reply
  • Auto update of data from one sheet to other Closed

    Hello, Pls guide me regarding how to update data from one sheet to other in excel. In sheet1, if i update the details of the student it sho...

    aruncs | Latest reply: ac3mark Jun 12, 2018
    1 reply
  • Creating Excel Email Alert For Expiring Dates Closed

    Hello, all I want to do is to create a code that will send me an e-mail when one of my docs will be expiring or expired. The problem is that there...

    Imgladuc4me | Latest reply: ac3mark Jun 12, 2018
    3 replies
  • How to combine/merge multiple rows into single row Closed

    I have name of person in 1 row and multiple car names owned by him in different rows .How to combine these rows together so that name is in one column...

    PadmapriyaTG | Latest reply: PadmapriyaTG Jun 12, 2018
    0 replies