Excel Forum

Ask a question
Search
Close
Results 2301 - 2350 of about 9,840
  • Automate copying data from one sheet to another Closed

    Hello, Could you help me with the below issue please? I have 2 different sheets in 2 different locations (say one is the Master sheet). I need ...

    Jithin | Latest reply: Jithin Jul 5, 2016
    0 replies
  • Highlight cell if another cell contains any text Solved/Closed

    Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...

    LvH | Latest reply: LvH Jul 4, 2016
    4 replies
  • Senior accountant A/R Closed

    Hello, i cannot transfer data more than 54 column to another sheet(can not write more than 54 cell same row in the code) Configuration: Windows...

    Mohamed | Latest reply: Mohamed Jul 3, 2016
    0 replies
  • So close! Script creates worksheet and populates BUT Closed

    Over the last 10 hours I have researched and pondered and really enjoyed the process of building up this program, but my shift is almost over and I wo...

    MitchLPN | Latest reply: MitchLPN Jul 1, 2016
    0 replies
  • Macro that Creates New Worksheets based on Data from a List Closed

    I've been researching and attempting to create a macro for the past few hours. I have a workbook with 2 worksheets. 1st worksheet contains a table tha...

    Mitch | Latest reply: Mitch Jul 1, 2016
    0 replies
  • Copy and paste macro button based on a condition Closed

    Hello, I am very new using VBA. I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the wor...

    bgm79 | Latest reply: bgm79 Jun 30, 2016
    0 replies
  • Excel help please Closed

    Ok here's what I want to accomplish. I want to be able to type the name of a medication: and the formulations automatically appear in the rows foll...

    jenn | Latest reply: Mazzaropi Jun 30, 2016
    1 reply
  • auto row copy to another worksheet Closed

    I'm new to excel and need to set up a simple double entry bookkeeping system in excel. I need to know what formula to put into a cell to accomplish t...

    barryhall | Latest reply: Anon Jun 30, 2016
    8 replies
  • Assign numerical value to cell based on text in another cell Closed

    Hello, I'm trying to solve an issue... Column A cells have a drop down which has 4 text options to choose from: Tier 1 Tier 2 Tier 3 Tier 4 ...

    ERS | Latest reply: Mazzaropi Jun 30, 2016
    1 reply
  • Copy and paste macro button based on a condition Closed

    I have daily time I am entering for employees in a worksheet. It is summarized in a table at the bottom of the worksheet. When today's data is entered...

    bgm79 | Latest reply: bgm79 Jun 30, 2016
    0 replies
  • Tracking changes on a work book Closed

    Hello, just to inform, i don't know how to create a macro or visual basic program. I have an excel sheet that contains 500 line items. each ite...

    Ric San | Latest reply: Ric San Jun 30, 2016
    0 replies
  • Runtime Error 6 - Overflow error with a variant type variable Closed

    Dear All, Kindly help me with the below coding where i get Runtime Error 6 - Overflow error when executed. Private Sub Workbook_Open() Dim ws A...

    Anju | Latest reply: Anju Jun 30, 2016
    0 replies
  • Word Search Closed

    Hello, I need some help. I basically do not have the knowledge about Macros or VB in Excel I just need some help on this hope you can understand m...

    blindfolded | Latest reply: blindfolded Jun 29, 2016
    0 replies
  • Find words within a cell, use a list to identify and place value Closed

    Hi everybody I would be really appreciative of any suggestion you might have. I have used a solution provided previously which was terrific however ...

    Jen | Latest reply: Jen Jun 29, 2016
    0 replies
  • Excel macro to create workbooks and synchronize data (and more) Closed

    Hi there, A little more than a year ago I made a commitment to go in-depth with Excel. Since then I have been practicing 4-8 hours every week, and...

    pr0t0typ3 | Latest reply: pr0t0typ3 Jun 29, 2016
    0 replies
  • cant figure out a formula Closed

    Hello, I need help figuring out a formula that will if two cells values match then the data in selected rows will go to one if that makes sense......

    williamjc | Latest reply: ac3mark Jun 29, 2016
    1 reply
  • how to save next data entry in next target range Closed

    Hello, I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click sav...

    jen | Latest reply: vcoolio Jun 29, 2016
    1 reply
  • create a macro which monitors the cell "c1" to be changed to "a" Closed

    Hello, I hope someone can assist with this In my workbook; I have two worksheets labeled "log" and "master" I want to create a macro which monitor...

    Fkhan777 | Latest reply: Fkhan777 Jun 28, 2016
    2 replies
  • auto add or subtract between two cells Closed

    Hello, This is probably a very simple question. I am trying to auto add or subtract between two cells. example: if B1 is greater or less t...

    MEL | Latest reply: ac3mark Jun 28, 2016
    1 reply
  • EXCEL VBA: Application.FileSearch Error in Running Excel 2013 Solved/Closed

    Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...

    g.cabal | Latest reply: TrowaD Jun 28, 2016
    6 replies
  • Please help - Finding missing rows between 2 sheet Closed

    Hello, I would really appreciate your help with putting together a simple script to compare 2 excel sheets. I basically just want to find missing ...

    JULES ETRO | Latest reply: JULES ETRO Jun 28, 2016
    0 replies
  • Percentage Closed

    Hello, how do I figure out the mark up percentage when I have the cost and sell price. cost Q2 1.14 sell P2 8.04 what's the per...

    ike | Latest reply: Mazzaropi Jun 27, 2016
    1 reply
  • How to stop rows underneath being affected by a filter Closed

    Hello, I have a filter set up for a table which works fine and is filtered when a quantity is entered in column D. However under the table is more row...

    Jane | Latest reply: TrowaD Jun 27, 2016
    1 reply
  • simple multiplication gives wrong result Closed

    Hello, I am raja, In my excel 2010 when i am trying to multiply two cells of values 743.91 & 0.87 , the result is as given 646.88. But the actual...

    ganesh | Latest reply: TrowaD Jun 27, 2016
    1 reply
  • column with dates not sorting/formating Closed

    Hello, a column with dates is not sorting nor formatting. I have tried to do the suggested answer on the forum but to no avail. This is driving me cra...

    Starfishstef | Latest reply: TrowaD Jun 27, 2016
    1 reply
  • Copy paste special into last row of another worksheet Solved/Closed

    Hello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...

    Roy | Latest reply: TrowaD Jun 27, 2016
    3 replies
  • how to create student exams record and printout using ms excel Closed

    I wish to design student exams records using MS Excel afterward, I should be able to pull records of student using Matric_No and then print out the st...

    vao | Latest reply: pervezjan Jun 27, 2016
    1 reply
  • EXCEL ** Sent e-mail after cell changes ( Excel macro ) Closed

    Hello, I am looking for a solution on excel where when coloumn e is changed then email me with a coloumn plus the new e coloumn. Thank you for ...

    yenisoru | Latest reply: yenisoru Jun 27, 2016
    0 replies
  • Multiple Query in once button in same sheet Closed

    Hello all, I have created two separate queries in excel VBA. I have given two different buttons for both queries and both are running successfully...

    Raju | Latest reply: vcoolio Jun 25, 2016
    1 reply
  • Transfer names from general sheet to separate other sheets Closed

    Hello, So i have 3 separate sheets, the first is a general info sheet with names and other information on it, names are in column A. Each name is ...

    Tyler | Latest reply: vcoolio Jun 25, 2016
    1 reply
  • Help for creating a macro Closed

    Hi all. I'm here to ask for ypur help. I want to create a macro, that opens a dialog box and leting you browse your computer and open a new excel file...

    r.rafailov | Latest reply: r.rafailov Jun 24, 2016
    1 reply
  • complex nested if formula help... Closed

    Hi, I'm new to this excel lark, i rather like it but am stuck, please can you wise people help me... heres a pic of what I'm working on... s...

    iisjo | Latest reply: Mazzaropi Jun 24, 2016
    1 reply
  • status of the certificates Closed

    Hello, i am raja, i have no.of certificates with issue date ,expiry date, last annual survey & next annual range. i attached sample sheet below .I...

    ganesh | Latest reply: ganesh Jun 24, 2016
    0 replies
  • Show Calculation on the first of the month Closed

    Hello, I have created a spreadsheet with various calculations. I have it divided as monthly items, however, I prefer that a certain calculation o...

    bluemoonintn | Latest reply: ac3mark Jun 23, 2016
    1 reply
  • account formulas Closed

    Hello, i am raja, i am working on milk processing excel sheet(it contains parts annexure II to annexure X) to start new business. anyone can help m...

    ganesh | Latest reply: ac3mark Jun 23, 2016
    3 replies
  • Autopopulating across tables Closed

    Hello, Hoping for some help with the following Excel conditional query. Hoping to automate so that Table 1 can autopopulate Table 2 with the re...

    Utopia18 | Latest reply: Utopia18 Jun 23, 2016
    0 replies
  • IF statement that adds 1 for specific text Closed

    Hello, I have a spreadsheet that I have a column (I2-I48) that contains text for different ticket types. I am trying to create a formula that give...

    Jet | Latest reply: Mazzaropi Jun 23, 2016
    1 reply
  • Copy cell value between sheets if it matches a criteria Closed

    Hello, I am looking for assistance in getting a formula to copy cell values between sheets if it matches criteria. Scenario - sheet 2 will have...

    Prashanth | Latest reply: Prashanth Jun 23, 2016
    0 replies
  • Find the last blank cell Closed

    Hello, I am looking for a formula/method of finding a last blank cell in a column example column A 1 2 3 4 blank cell 1 2 3 ...

    vutanhuynh | Latest reply: Mazzaropi Jun 23, 2016
    3 replies
  • Employee Scheduling using Excel Closed

    Hello, I'm trying to create an excel sheet for employee scheduling. If I type the name of the person, is it possible to create a formula or condi...

    Yeop | Latest reply: Yeop Jun 23, 2016
    0 replies
  • Auto populate cells based on the number in another cell Closed

    Hello, I was wondering if it's possible to "tell" excel to Auto fill in a row of cells with specific text, based on a value in another cell. For ...

    Wonderingabo... | Latest reply: Wonderingaboutexcel Jun 22, 2016
    0 replies
  • If then formula for dates and days of the week Closed

    i need an excel formula that will calculate days according to rules, so I have a list of dates and in the column next to it I need it to add 13 days t...

    anita | Latest reply: anita Jun 22, 2016
    0 replies
  • Merge data based on condition Closed

    Hello, I have multiple sheets with different columns, the header is mentioned in row 3 and there are few headers which are common across all the s...

    Shridhar | Latest reply: Shridhar Jun 22, 2016
    0 replies
  • Need a macro to duplicate rows of text based upon a cell value Closed

    Working on Mac vs. 15.17; I had a macro that use to work in a previous version of Excel. But I cannot get it to work now. I do not know VB or code. Ca...

    jnowell | Latest reply: jnowell Jun 22, 2016
    0 replies
  • Matching Names with two separate formats Closed

    Hello, I am trying to create a table where in one column has the names from File1 in format Last, First ex. Gates, Bill without duplicates. The in...

    Alex | Latest reply: Alex Jun 22, 2016
    0 replies
  • How to extract Date Before a particular word in a cell Closed

    Hello All, .I have a particular column in an excel worksheet that contain something like "AUXID9016700# 16/06/2016 8:54:25 AM call received fro...

    kayclan | Latest reply: kayclan Jun 22, 2016
    0 replies
  • Help needed for copying cells from one sheet to another Closed

    Hello, Guys i'm new here, so pleace don't be hard on me :) I need your help for doing the following: There is one column A filled with names on ...

    r.rafailov | Latest reply: r.rafailov Jun 22, 2016
    0 replies
  • Excel Formula Closed

    Hello everybody! That seems so simple but I can't do it :( I would like to know the formula for this: If any text is found in cells T23 U23 V2...

    augustaD | Latest reply: fdibbins Jun 22, 2016
    3 replies
  • Names matching Closed

    Hello, I have two columns A and B, in the both columns i have the names.i have to match the all the A columns names with the B column names and B ...

    venkataswamy... | Latest reply: fdibbins Jun 22, 2016
    1 reply
  • Copy all data from multiple sheets to one new sheet using VBA Closed

    Hello, I have Multiple files in a folder.i wants to copy all Files data (i.e.all columns to new sheet) to one new sheet. E.g. file 1 Contains 5 colu...

    @mar12 | Latest reply: @mar12 Jun 22, 2016
    0 replies