Excel Forum

Ask a question
Results 901 - 950 of about 9,830
  • VBA macro loop Closed

    Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...

    bjj127 | Latest reply: ac3mark Nov 1, 2017
    1 reply
  • How to compare 2 sheets in Excel? Closed

    Hello, I have to come 2 sheets sheet 1 Rev 0 Sheet 2 Rev 1 Sheet 3 diference between sheet 1 & Sheet 2

    9833918859 | Latest reply: 9833918859 Nov 1, 2017
    0 replies
  • compilation Closed

    Good day to all, I am looking for help and I have asked all the knowledgeable people at work to no avail. As per the uploaded picture, I am lo...

    Wade526 | Latest reply: Wade526 Oct 30, 2017
    2 replies
  • How to compare a range of data in Excel? Solved/Closed

    Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...

    shan_asa | Latest reply: shan_asa Oct 29, 2017
    4 replies
  • Transferring data from page to page and automatically sorting Closed

    I'm creating a grocery list in excel and I am struggling with one big part of it. - Page 1 is dedicated to meal planning, page 2 is an ingredient c...

    SmithFamily | Latest reply: SmithFamily Oct 28, 2017
    0 replies
  • How to use VBA to send emails from Excel? Closed

    Hello, I really need some help! I need to create a macro which will send emails to a specific email address within excel when a cell is updated. ...

    Tara B | Latest reply: Tara B Oct 28, 2017
    0 replies
  • Adding and subtracting using Vlookups Closed

    Hello, =IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ") I need to add in another vlookup to the formula but have tried a few...

    libseal | Latest reply: ac3mark Oct 27, 2017
    1 reply
  • Pictures insertion Closed

    Hello TrowaD, With this code, pictures are linking to the file and not inserting. i.e. If I send the file to someone in email they cant these picture...

    anjumargams | Latest reply: ac3mark Oct 27, 2017
    1 reply
  • How to use VBA to loop copy and paste Closed

    Hello, I have a formula in raw # 12 (E12: TNF12) and would like to paste this formula in the raw below (raw# 13) and then copy and paste its conte...

    maddalenamori | Latest reply: ac3mark Oct 26, 2017
    3 replies
  • How to migrate data to another table and use a search box? Closed

    Questions! I have a database-type table with names, numbers, addresses and what have you. I would like to make a second, single-rowed table that s...

    venn47 | Latest reply: venn47 Oct 26, 2017
    0 replies
  • Formula in numerical format changes to date format Closed

    Hello, Actually, there is a problem arose. In an excel sheet where ever I put a formula changed from number to date format. Don't understand the...

    Shaynam | Latest reply: Shaynam Oct 26, 2017
    0 replies
  • Excel VBA macro to split rows, then copy and past Closed

    good day, please i need vba code, that split one row to multiple rows and copy, paste it in another worksheet, and the source worksheet have about 100...

    bashir2015 | Latest reply: bashir2015 Oct 26, 2017
    0 replies
  • Date Format not reflected in sheet Closed

    Hello, Guys,, help.. How do I convert the date in excel? Now it shows mm/dd/yyyy. I've changed the Format to dd/mm/yyyy but the data did not chang...

    NHAZA | Latest reply: NHAZA Oct 25, 2017
    0 replies
  • Copy Paste Special Values Macro Closed

    Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and t...

    usrvl | Latest reply: ac3mark Oct 25, 2017
    9 replies
  • How to update data of Sheet2 in Sheet1 with Excel? Closed

    Hello, I have data in SHEET1 A1-5 A2-6 A3-9 I am entering data in SHEET2 A1 B1 C1 D1=SHEET1!A1-C1 I want to update this D1 value...

    bhupesh | Latest reply: ac3mark Oct 25, 2017
    1 reply
  • Use conditional formatting to highlighting cells based on Name Closed

    Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a sepe...

    Kirk_92 | Latest reply: ac3mark Oct 24, 2017
    1 reply
  • VBA for copying from data entry sheet to corresponding sheets Solved/Closed

    Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...

    OMCHABRIA | Latest reply: TrowaD Oct 24, 2017
    7 replies
  • How to extract data using VBA in Excel? Closed

    Hello, Need some help to create a VBA for Excel 2016.. Basically i have 2 workbooks. Workbook 1 is Master File. Workbook 2 is the monthly d...

    hui1122 | Latest reply: ac3mark Oct 20, 2017
    1 reply
  • Calculate a percentage when the values are text Closed

    I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. ...

    Duwop01 | Latest reply: ac3mark Oct 19, 2017
    1 reply
  • Very New ... Need some help. Closed

    Hello, I've created a spreadsheet for my cruise inventory thought it would help keep track as a new travel agent first time really using excel in ...

    TuhchKeys | Latest reply: TuhchKeys Oct 19, 2017
    0 replies
  • Excel Macro not working, any ideas? Closed

    Hello, I work at a university and no one here knows anything about Macros. I had a new computer built and lost all my Macros a previous coworker...

    elb5035 | Latest reply: elb5035 Oct 18, 2017
    0 replies
  • How to count the number of occurrences in a range Closed

    I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...

    STUDENTFJR | Latest reply: Mazzaropi Oct 17, 2017
    3 replies
  • Formula for Unique ID's following a predefined rule Closed

    Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...

    Zolliez | Latest reply: TrowaD Oct 16, 2017
    1 reply
  • Dates conversion Closed

    Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...

    Herodia | Latest reply: TrowaD Oct 16, 2017
    1 reply
  • Reformat date field to plain text Closed

    I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...

    Bunk | Latest reply: vcoolio Oct 15, 2017
    1 reply
  • Auto fill Closed

    Hello, I need some help with excel. For example: I have on Sheet 2, in column A a list of words. So, what i need - if I enter one of the words on s...

    andrisp | Latest reply: andrisp Oct 13, 2017
    0 replies
  • how to give a students two ranks Closed

    Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class ...

    Fayyaz295 | Latest reply: Fayyaz295 Oct 13, 2017
    4 replies
  • Delete or insert rows in a workbook Solved/Closed

    Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...

    ehsan | Latest reply: TrowaD Oct 12, 2017
    1 reply
  • Auto-create tabs from list and template Closed

    Hello, I have a workbook with two tabs: 1. Tab name 'Index' If information is input into C4, then I need a tab created 2. Tab name 'Template' ...

    teacup001 | Latest reply: teacup001 Oct 11, 2017
    0 replies
  • How to make one summary file with 29 sum up sheets Closed

    Hi My self Dr. Seema Mehrotra working as an Urban Economist at National Institute of Urban Affairs, New Delhi, India. I am working on a very large...

    Chasheema | Latest reply: ac3mark Oct 11, 2017
    1 reply
  • Autopopulate using dates Closed

    Kind of a complicated one. I'll be appreciative/extremely impressed if someone can help me out. I'm budgeting and trying to autopopulate cells usi...

    chrisbrownn28 | Latest reply: TrowaD Oct 10, 2017
    1 reply
  • How do I create this conditional formula Closed

    How do I create this formula? If A2, B2, and C2 has a combination of H, H, HP (it doesn't matter what order it is in), returns a score of 98 in cell ...

    Dlene03 | Latest reply: TrowaD Oct 10, 2017
    2 replies
  • What formula can be used to share data in 2 sheets Closed

    Hello, I have two excel sheets A and B having the same columns. there names, dates, figures. not necessarily having the same number of rows, havin...

    NKERAGUTABARA | Latest reply: TrowaD Oct 10, 2017
    1 reply
  • Conditional Formatting Closed

    I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date...

    TraceyLongstaff | Latest reply: Mazzaropi Oct 10, 2017
    1 reply
  • How to update data between 2 sheets using Google Spreadsheet Closed

    Hello, I have created a form linked to Google Spreadsheet(named Form) to collect customer data like name, email, phone number and concern. I have an...

    faizan | Latest reply: faizan Oct 10, 2017
    0 replies
  • How to use a macro to check data in 2 work sheets Solved/Closed

    Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...

    MadhaviLakshmi | Latest reply: ac3mark Oct 9, 2017
    1 reply
  • Counting Number For Similar Value Closed

    I have 2 Excel Sheets where i want to Use data from one Column from one sheet and compare those values in Other Sheet Colum to know how Many types the...

    Prasad | Latest reply: Prasad Oct 7, 2017
    0 replies
  • Use Macros to copy worksheet and rename using a list of names Solved/Closed

    Hi all, I'm an excel novice and hoping for help. I need to write a macro to 1. Copy worksheet "Alstromeria" and 2. Rename worksheet to the name...

    eswhi | Latest reply: eswhi Oct 7, 2017
    0 replies
  • How to generate a STATIC unique identifier for each Excel row Solved/Closed

    Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...

    Musicar | Latest reply: ac3mark Oct 6, 2017
    4 replies
  • Two IF forumlas inside an IF formula Solved/Closed

    Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...

    AdrianHowland | Latest reply: Mazzaropi Oct 6, 2017
    4 replies
  • Formula with varying information need pasted multiple times Closed

    Hello, I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =...

    huestis | Latest reply: ac3mark Oct 5, 2017
    1 reply
  • Master Sheet to affect multiple sheets Closed

    Hello, I am not sure how to explain this... I have a master sheet that has a list of all the names and grades for each row alphabetically. I have ...

    akiroche | Latest reply: vcoolio Oct 5, 2017
    1 reply
  • how to find grade Closed

    How find grade in excel, old tell me about the formula

    kowsalyanaga... | Latest reply: xpcman Oct 5, 2017
    1 reply
  • Autopopulating multiple sheets from one main sheet Solved/Closed

    Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...

    Mikey | Latest reply: TrowaD Oct 5, 2017
    45 replies
  • How to sum a number from a range of cells, based on value Solved/Closed

    Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....

    cathcam | Latest reply: TrowaD Oct 5, 2017
    3 replies
  • Excel Closed

    Hello, i have 5 numerical values in 5 columns but in same row and these 5 values need to be compare(e.g whether the five values lies between the t...

    irshad | Latest reply: irshad Oct 5, 2017
    0 replies
  • Subtracting numbers based on data in another cell Closed

    I use a cell to show that a number has been deducted from an account. How can I make a subtraction of that amount form a total amount based on the inp...

    drspinner | Latest reply: ac3mark Oct 4, 2017
    1 reply
  • Name check Closed

    Hello, How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?

    kalai | Latest reply: Mazzaropi Oct 4, 2017
    1 reply
  • Change the date format in Excel Closed

    Hello, how I can chnage the format of 12-07-2003 to 2/22/2017 in excel 2010. Give the exact route inder

    inder | Latest reply: inder Oct 3, 2017
    0 replies
  • Self-generating sequenced number each time a sheet is opened Closed

    How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number...

    kevdoc | Latest reply: ac3mark Oct 3, 2017
    1 reply