Excel Forum

Ask a question
Results 351 - 400 of about 9,850
  • Formula/Solution Closed

    Hi, Is there a way for me to link in one spread sheet the Leave Dates that will automatically apply to the specific date in a second/third/forth sp...

    RuthG13 | Latest reply: ac3mark May 29, 2019
    1 reply
  • VBA Regex Closed

    i need a help to create regex to use in Excel vba. Actuality 3 regex 1. Only Numerics Valid: 12,12.000, 2343342.123221321398783, 0.9874, -12, -2...

    Sanju_7454 | Latest reply: Sanju_7454 May 28, 2019
    0 replies
  • Compare two excel file and provide unmatched excel data in separate file Closed

    Hello, I have two excel files with common identification column A in both files. I need macro which will provide unmatched data in separate file. ...

    Rajesh | Latest reply: Rajesh May 26, 2019
    0 replies
  • use RegEx in vba sub in general sheet Closed

    How to use regex in general vba sheet. i am getting lot of red lines and not able to find the reason for that. I have enabled the Regularexpression...

    Sanju_7454 | Latest reply: ac3mark May 25, 2019
    4 replies
  • Listboxes with Checkboxes to filter data Closed

    Hello, Greetings! I have a query regarding making dashboard. I have a data sheet where all data is managed. I want slicer with listbox having ...

    Game Start Now | Latest reply: TrowaD May 23, 2019
    13 replies
  • read special character value Closed

    how to read the cell value in vba if A1 has special character like -------- I used Range("A1").Value , Its throwing an error plz help me

    Sanju_7454 | Latest reply: ac3mark May 22, 2019
    1 reply
  • VBA code to count invalid Values Closed

    Hi, I have created a vba code to circle the invalid data based on the custom data validation rule being written. I want to count the all those i...

    Sanju_7454 | Latest reply: ac3mark May 21, 2019
    7 replies
  • Automatically update a cell with last modified date and time Solved/Closed

    I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cel...

    NazCarr | Latest reply: NazCarr May 16, 2019
    2 replies
  • Repeated copy/paste Macro Closed

    I have basic knowledge of Macros. I need to copy 1Lakh data in such a way that it takes 10k rows and paste in new sheet1 and again it takes next 1...

    Sanju_7454 | Latest reply: ac3mark May 9, 2019
    4 replies
  • Keeping track of ages Closed

    Hello, I operate a small daycare and need help figuring out a system to help keep track of my group ratios. I haven't been able to find a software...

    celineleblanc | Latest reply: ac3mark May 8, 2019
    1 reply
  • Please help me connect my workbooks to a master excel worksheet. Closed

    Hello, I have been through every excel video and forum trying to figure out how to connect my Excel workbooks for a tracker I have been working on. I...

    MBEr | Latest reply: ac3mark May 7, 2019
    2 replies
  • VBA find column by name and sort Solved/Closed

    Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascen...

    SidK | Latest reply: bOFILL Apr 30, 2019
    4 replies
  • copy x rows from a worksheet and paste x rows into another worksheet n times Solved/Closed

    Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sh...

    christol_1566 | Latest reply: TrowaD Apr 29, 2019
    20 replies
  • Create new sheets based on Column A data. Solved/Closed

    Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle ...

    josh07429 | Latest reply: Jay Apr 26, 2019
    4 replies
  • False error Closed

    Hello, How to remove false error while using this formula *if(c2="A",sumifs(sheet2!AA:AB,sheet2!B:B,sheet1!B:B, sheet2! Sheet1! A:A))*

    LOKESH | Latest reply: ac3mark Apr 22, 2019
    1 reply
  • Excels with different data Closed

    Hi All, sorry if this is already answered. I have two excel sheet having data of customers. the first report is 'old' one and the second is the '...

    Bharti | Latest reply: Bharti Apr 19, 2019
    0 replies
  • Finding duplicates between two columns with partial text Closed

    Hello, I am trying to compare a list of names in column A to a list of names in column B. I am trying to highlight the names in column A that matc...

    katthompson333 | Latest reply: katthompson333 Apr 19, 2019
    0 replies
  • Arrow keys not working in Excel Solved/Closed

    Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I wa...

    DaisyE | Latest reply: Nelson Apr 15, 2019
    59 replies
  • How to change date with the change in time Closed

    How to change date with the change in time and how to use if formula for date range

    Akshay_7572 | Latest reply: NazCarr Apr 9, 2019
    1 reply
  • excel on Mac Closed

    Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub NextInvoice() Range("I13").V...

    ADrossinis | Latest reply: ac3mark Apr 6, 2019
    1 reply
  • color cell Closed

    Hello, I have this formula to place a date in cell when negative number. =IF(D14

    docheller | Latest reply: ac3mark Apr 5, 2019
    1 reply
  • I want to change date format in Excel Solved/Closed

    Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.

    EAQ | Latest reply: mohammed Apr 2, 2019
    13 replies
  • Need to extract specific XML data from a cell in excel Closed

    Hi, I have the following data in cell A1 of an excel sheet: 39211000011200100100019 i would like to extract the value from this and print it o...

    alvin07 | Latest reply: SM Apr 1, 2019
    2 replies
  • Automatically data to another sheet by adding new rows Solved/Closed

    Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either ...

    NazCarr | Latest reply: TrowaD Mar 26, 2019
    9 replies
  • Creating search and update command buttons in a userform Solved/Closed

    I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command button...

    janb | Latest reply: ShezzyWiggle Mar 24, 2019
    19 replies
  • Update of Copied Excel sheet Closed

    Hello, I want to make copies of excel sheet such that if I delete rows/columns in main sheet they should be deleted in copy too.

    Vinayak | Latest reply: ac3mark Mar 21, 2019
    2 replies
  • Serial Numbers Based Upon Another Cell Closed

    I have a spreadsheet with owner and tenant information, along with their vehicle information. In the column that indicates if they are an owner, I hav...

    lkazempour | Latest reply: ac3mark Mar 21, 2019
    1 reply
  • Compare strings Closed

    Hello there, Case: I have lists of customers from 2 different sources, however example. List1 says ABC private limited on row A1, the other list2 say...

    Panstar5 | Latest reply: Panstar5 Mar 19, 2019
    0 replies
  • Help with filtering not working Closed

    Hello, I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to tha...

    Jessnleon17 | Latest reply: ac3mark Mar 14, 2019
    1 reply
  • Copy a range of Data in Column with a loop Closed

    Dear all, May I ask your help for a macro which allowed me to copy a range (column) 16350 times :-) On D5 to D369 I have a formula which do a rando...

    ChrisZ | Latest reply: ChrisZ Mar 13, 2019
    2 replies
  • Shows a #value! When using calculated fields on a pivot table Closed

    Hello everyone I would like to input a calculated field in the excel pivot table. I have input an formula as if(ERP (Variable)>0, "Yes", "No"). It...

    Harold | Latest reply: Harold Mar 11, 2019
    0 replies
  • User form to search all result and edit selected Closed

    I'm newbie in VBA excel. I want to create usesform to add, search all result and edit selected. Any one have code like this? Thanks

    silencehero | Latest reply: ac3mark Mar 8, 2019
    1 reply
  • compare 2 sheets with particular columns Solved/Closed

    Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in she...

    SunilD | Latest reply: SunilD Mar 5, 2019
    2 replies
  • Add data to row that already contains data Solved/Closed

    I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain d...

    aileen | Latest reply: aileen Mar 1, 2019
    2 replies
  • Automatically copy data from main sheet to child sheets. Solved/Closed

    Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-ano...

    Fenrir91_9 | Latest reply: vcoolio Mar 1, 2019
    5 replies
  • Montlhy Service Closed

    I have an increasing excel sheet where i keep the service records for customers per customer, per branch and per date (per year, month and exact servi...

    christossol | Latest reply: TrowaD Feb 26, 2019
    4 replies
  • Need VBA Code or function Closed

    Hello, kindly need assistance in getting VBA code to copy rows to a new sheet based on the cell value with same name sheet. and auto save the...

    mousa | Latest reply: mousa Feb 24, 2019
    0 replies
  • IF function? Closed

    I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not. This is the function I am using, ...

    bowmankailee | Latest reply: ac3mark Feb 20, 2019
    4 replies
  • Inserting pictures Closed

    Hello, Please I need help, I want to insert pictures into a particular sheet remotely without opening the sheet. And the picture will be base in ...

    Udomakpan | Latest reply: Udomakpan Feb 16, 2019
    2 replies
  • i want to convert figure or digit to word but without rupees or dollar Closed

    Hello, i want to convert figure or digit to word but without rupees or dollar, i just need only at the end of words, please help

    Munir | Latest reply: Munir Feb 16, 2019
    2 replies
  • Populating multiple cells with information pasted on a main sheet Closed

    I am trying to paste data every week in the same cells (B2-B12) on my main page and have that data populate cells on 12 separate pages. All 12 pages w...

    Alana | Latest reply: ac3mark Feb 15, 2019
    1 reply
  • Help getting data from one worksheet to the next. Closed

    Hello, I am trying to set up a master job sheet for all of our field employees to have the information in the field. The links to the 2 sheets are...

    amsterp | Latest reply: TrowaD Feb 14, 2019
    5 replies
  • Adding date depending on the day of the week Closed

    Hello, I want to automatically calculate a date when an invoice is due depending on the day of the week. For example: the service is provided o...

    dave1961 | Latest reply: TrowaD Feb 12, 2019
    6 replies
  • Transpose VBA Excel Closed

    Hi, I require a macro that performs a specific transpose action. Please see pre table example and desired post data set. I have searched for t...

    plexus2121 | Latest reply: TrowaD Feb 11, 2019
    4 replies
  • Updating other Excel sheets automatically from Master sheet. Closed

    Hi, I have been trying to sort this for a while. I have entered data in my master sheet and I have 4 other sheets. When I put new data into the mas...

    mandymindy | Latest reply: vcoolio Feb 6, 2019
    39 replies
  • Copying formulas to multiple worksheets Solved/Closed

    Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have t...

    mmikey45 | Latest reply: subodh Feb 2, 2019
    11 replies
  • Give a cell zero value depending on another cell's value Closed

    I have an interesting challenge I am a altra marathon runner busy creating a "log program" for my running Cell A1 = Distance Ran Cell B1 = Hours C...

    LSBUYS | Latest reply: ac3mark Feb 1, 2019
    1 reply
  • Copy data and pasting multiple times using macro Closed

    Hello, So I am having trouble determining what code to use to past value. The situations is as follows: On Sheet1 I have a list of names in co...

    Jlaro | Latest reply: ac3mark Jan 31, 2019
    3 replies
  • Auto Xfer Specific Data to a New Wkst Closed

    Hello, I have a raw data file of sales opportunities and would like to automatically identify and copy the TOP 10 Optys onto a new Wkst. Further, ...

    LSL18 | Latest reply: ac3mark Jan 31, 2019
    3 replies
  • Excel VBA- Copying data from newest worksheet to a new workbook Closed

    Hi all, Newbie here. I've been fumbling around with VBA and managed to get some parts working, but now I'm stumped. I have an Excel workbook tha...

    Holwhit | Latest reply: 1aman1diot Jan 30, 2019
    1 reply