Excel Forum

Ask a question
Results 351 - 400 of about 9,830
  • 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
  • Copy data onto sheet only if cell has text Solved/Closed

    Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the inf...

    danipants | Latest reply: checjb Jan 29, 2019
    17 replies
  • Repeat a set of rows in Excel Closed

    Hello, I have some set of unique row in a1 to a10, and I want to repeat the whole set of row in same column eg."A" by some given no. Of time by a p...

    RajeshParmar | Latest reply: Daniel Telele Jan 28, 2019
    1 reply
  • Formatting a cell for multiple functions in Excel Closed

    Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I alrea...

    KeithSmith | Latest reply: ac3mark Jan 18, 2019
    9 replies
  • Split data into several rows of same data Closed

    Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro that...

    Valerija_0201 | Latest reply: ac3mark Jan 14, 2019
    1 reply
  • Send Automatic emails using Macros Closed

    If column F in any worksheet in entire workbook is changed to "Pending" send an email. Below is my macro so far. Sub Request() Dim OutApp As Ob...

    DrewTully | Latest reply: ac3mark Jan 10, 2019
    1 reply
  • Copy more than one cell in Excel if a condition is met Closed

    Hi, I need to copy more than one cell if a condition is met. It’s about student degree. If the degree between specific range, then I need to copy m...

    ELGazzar | Latest reply: ac3mark Jan 9, 2019
    1 reply
  • Pulling data from multiple sheets to master sheet Closed

    Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project...

    stuart999 | Latest reply: ac3mark Jan 7, 2019
    2 replies
  • VBA code to open non excel programs Solved/Closed

    Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM

    PM | Latest reply: Billybob Jan 7, 2019
    10 replies
  • Excel 2007 file Excel found unreadable content in <filename.xslx Closed

    Good day, I have a computer set of Excel files, all in working order, but today one of the files when opening gave an error: "Excel found unreadable ...

    kianbarrett | Latest reply: vl Jan 5, 2019
    2 replies
  • Problem with copy in one sheet Solved/Closed

    Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...

    kekserica | Latest reply: ac3mark Jan 4, 2019
    26 replies
  • I have a problem regarding how to automatically update data in other Sheets. Closed

    Hello, I m looking to have few different sheets that automatically updated based on information that is added or changed in master sheet. One shee...

    ZEE | Latest reply: ac3mark Jan 4, 2019
    2 replies
  • Automatically move an entire row of expired item from one sheet to another sheet Closed

    Hi, I have a problem with the code below. I am a store officer in the firm I am currently with, and monitory of expiring date of a product is par...

    Danielkyan | Latest reply: Ratnendra Ashok Dec 30, 2018
    1 reply
  • Copy worksheet from one workbook to another workbook in MS Office Excel Closed

    Hello, In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.

    SrinivasNittala | Latest reply: ac3mark Dec 28, 2018
    1 reply
  • I need VBA that creates a new sheet for every data entered in column D Solved/Closed

    Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...

    dmatrix00 | Latest reply: ac3mark Dec 26, 2018
    3 replies
  • Budgeting forumla in Excel Solved/Closed

    Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...

    nfez | Latest reply: nfez Dec 22, 2018
    2 replies
  • Macro in Excel Closed

    bonjour je bloque sur ma macro depuis plusieurs jours et j'aurais besoins d'aide j'ai un listing de 13 colonnes qui peut aller jusqu’à 50 lignes m...

    bugs77100 | Latest reply: Daniel Telele Dec 20, 2018
    1 reply
  • Copy rows n times in Excel Solved/Closed

    Hello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...

    Sarath | Latest reply: vcoolio Dec 20, 2018
    8 replies