Excel Forum

Ask a question
Results 301 - 350 of about 9,850
  • Spreadsheet help moving data Closed

    So I'm trying to make a macro that moves data from an input sheet to the appropriate sheet based on information in a given cell that is being entered....

    Tbonekiller | Latest reply: ac3mark Aug 22, 2019
    4 replies
  • Excel vba to color row based on wbs level Closed

    Hello I need a macro to change row color based on "Level" column. Thanks Ebti

    Ebti59 | Latest reply: ac3mark Aug 21, 2019
    1 reply
  • Copy from one cell and paste to another sheet based on length of another column Closed

    Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data f...

    Ski4q | Latest reply: ac3mark Aug 21, 2019
    3 replies
  • Summarise hours incurred by month based on multiple criteria Solved/Closed

    Hi, I want to summarise hours incurred mthly (from the time_converted column) based on the grade and agency but can't seem to get the below formula...

    Micwhsct | Latest reply: Micwhsct Aug 19, 2019
    4 replies
  • Are you still taking questions? Closed

    Hello, Are you still taking questions?

    Somnonaut | Latest reply: Somnonaut Aug 13, 2019
    5 replies
  • Message to appear when 5 cells uncolored cells contain values. Solved/Closed

    Hello, A macro using excel that can return a message when 5 uncolored cells that are in a range of colored and uncolored cells contain values. The ...

    Fmss8404 | Latest reply: TrowaD Aug 13, 2019
    1 reply
  • Code to move rows into another sheet based on certain values Solved/Closed

    Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). ...

    Ryleecone | Latest reply: vcoolio Aug 13, 2019
    6 replies
  • create an ordering list for our consumables Closed

    Hello all, New user here! I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an orde...

    anewskillofhelp | Latest reply: ac3mark Aug 12, 2019
    17 replies
  • False Value removal Closed

    Hello, How to remove false value if I use below formula =IF($K4="Urban",IF(N4>0,1,0))

    Jumita | Latest reply: ac3mark Aug 9, 2019
    1 reply
  • Checking the values in Sheet1 with multiple entries in Sheet2, Write the output Closed

    Hello Experts I am having 3 different sheets: In sheet 1, I have columns A- K & Sheet 2, I have columns A-G. I need to find column H values from Sh...

    shreven | Latest reply: TrowaD Aug 8, 2019
    1 reply
  • Creating a data input sheet with excel Closed

    Hi, So I am attempting to create a dashboard whereby data can be inputted in different categories and then once the data is submitted it is sent t...

    excelmatt23 | Latest reply: TrowaD Aug 6, 2019
    1 reply
  • Count cells containing text per row Closed

    Hello, I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time ...

    c | Latest reply: TrowaD Aug 6, 2019
    1 reply
  • Excel Formula to identify similar text Closed

    Good day, I am looking for help with an excel formula to identify similar text within two columns. In column A there will be a specific word wit...

    Reinette | Latest reply: TrowaD Aug 6, 2019
    5 replies
  • Search using variable Closed

    Hello, I am trying to enter a value (name or partial name) and perform a search in the specified column. I can easily put a specific string in the ...

    Roger | Latest reply: ac3mark Jul 29, 2019
    1 reply
  • Auto-populate a sheet with data from different other sheets Solved/Closed

    Hello, I have been having problems with having a general data sheet in my workbook. My problem is as follows: I have 3 different sheets, all of w...

    ThanatosTalos | Latest reply: ac3mark Jul 29, 2019
    59 replies
  • Copy rows to other sheets based on value in column Solved/Closed

    Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to...

    MsBluebird | Latest reply: vcoolio Jul 26, 2019
    16 replies
  • transfer data from sheet1 to sheet2 Closed

    Hello, i have data in sheet1 from range a1: f91 when i fill data and transfer to sheet2 it also transfer the empty rows here i wanna delet...

    alhagag | Latest reply: ac3mark Jul 26, 2019
    7 replies
  • macro code vba exel sum dublicate data and delete Closed

    hi, everybody i need help code vba exel i have data in sheet1 begening from cells a2:g100 many data are dublicateed i would the sum dublicate ...

    abdelfatah | Latest reply: ac3mark Jul 19, 2019
    24 replies
  • Copy Template, Rename based on a reference list from a different spreadsheet Closed

    Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my templa...

    Sublimus | Latest reply: vcoolio Jul 18, 2019
    1 reply
  • Replace 'sheet' reference in a formula (not copy data, but get averages) Solved/Closed

    Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...

    cmigoya | Latest reply: vcoolio Jul 13, 2019
    5 replies
  • Copying Excel data from one sheet to another based upon contents of a cell Closed

    Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email address Col ...

    DittDott | Latest reply: TrowaD Jul 11, 2019
    3 replies
  • Am not too good on percentage calculation Solved/Closed

    Hello please what is the 10 percent of,7200000000

    Anonymous | Latest reply: kieferschild Jul 10, 2019
    1 reply
  • How to duplicate rows x number of times Closed

    Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A, Col...

    carlos.guerr... | Latest reply: ac3mark Jul 9, 2019
    4 replies
  • Follow up Q to how to add a certain number of days to a date in excel Closed

    Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column, depending ...

    Izanagi7 | Latest reply: TrowaD Jul 8, 2019
    1 reply
  • Macro to copy/paste down X times (where X is the number of rows) Solved/Closed

    Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...

    JW32 | Latest reply: TrowaD Jul 8, 2019
    41 replies
  • Compare sheets macro Closed

    Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the two ...

    Avisek21 | Latest reply: TrowaD Jul 4, 2019
    1 reply
  • Which macro (of many) changes the data in my workbook Closed

    I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the...

    GarySchmidt | Latest reply: TrowaD Jul 4, 2019
    1 reply
  • Formula to subtract one cell value from another. Closed

    Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?

    autigers71 | Latest reply: vcoolio Jul 1, 2019
    1 reply
  • Auto Transfer questioner with right answer to another sheet Closed

    Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer is ‘N...

    Fairuz | Latest reply: TrowaD Jul 1, 2019
    1 reply
  • Insert Picture in Ms Excell Closed

    Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures auto...

    anjumje | Latest reply: ac3mark Jun 27, 2019
    1 reply
  • partial matches in lists of 6-digit numbers Closed

    Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by typi...

    baxterkix | Latest reply: TrowaD Jun 20, 2019
    3 replies
  • Formula to create generations based on birthday Closed

    I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers (194...

    KristyAnn8000 | Latest reply: TrowaD Jun 20, 2019
    3 replies
  • Copy and paste selected cells a given number of times Closed

    Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which copies t...

    AndrasN | Latest reply: ac3mark Jun 19, 2019
    1 reply
  • Send mail if today is the birthday. Solved/Closed

    Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...

    RWomanizer | Latest reply: bkdroid13 Jun 19, 2019
    11 replies
  • Comparing Two Excel Sheets and copying like data to third sheet Solved/Closed

    Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...

    coz2992 | Latest reply: TrowaD Jun 18, 2019
    11 replies
  • Getting multiple largest values with specified limits Closed

    Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers not re...

    M | Latest reply: TrowaD Jun 18, 2019
    1 reply
  • Extract data from few XML file into Excel. Closed

    Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML files...

    GizmoIE | Latest reply: ac3mark Jun 14, 2019
    24 replies


    parshv | Latest reply: TrowaD Jun 13, 2019
    1 reply
  • Trying to insert multiple rows between rows in excel with copied data. Closed

    Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is on ...

    ElderVisco | Latest reply: TrowaD Jun 13, 2019
    1 reply
  • Using a Named Field for Autofill Solved/Closed

    I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...

    excel987 | Latest reply: excel987 Jun 12, 2019
    2 replies
  • Find and Replace using VB; from a txt file, find all commas "," Closed

    I need to find all occurances of a comma "," in a txt file and replace it with a blank space and output a csv file. Is there an easy way to do this in...

    lenbrown_8273 | Latest reply: ac3mark Jun 12, 2019
    1 reply
  • Excel Macro - Set and autofill a range? Solved/Closed

    Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column with a...

    KT | Latest reply: excel987 Jun 11, 2019
    28 replies
  • Excel autofilter stops filtering Solved/Closed

    Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I di...

    Lucy | Latest reply: thankful Jun 11, 2019
    45 replies
  • Formula for conditional format to color cells Closed

    hi, need a formula or conditional format: if cell a1 has text, then apply the color RED to cells underneath say a2-a15. then, once numbers are i...

    kipp2019 | Latest reply: TrowaD Jun 11, 2019
    14 replies
  • Save excel file as specified titles in different workbook Closed

    Hello Trowa and team, I just saw you solved a task for another user, who wanted to recreate a file with specified names in the list. I have a s...

    Anna | Latest reply: TrowaD Jun 11, 2019
    3 replies
  • If a cell contains any text then add a value Solved

    I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to s...

    cbrizz | Latest reply: Pharmanumbers Jun 5, 2019
    20 replies
  • How to copy a data from one sheet to another, when specific criteria is met Closed

    Hello, If, for instance, the criteria changes in column "C" - it gets higher number, how to transfer the row data to other sheet2, copying the row d...

    TomasSurvilas | Latest reply: TrowaD Jun 4, 2019
    13 replies
  • Need to delete rows in multiple sheets simultaneously Closed

    Hi I have a worksheet that has 3 sheets. Sheet 2 and 3 have data linked from sheet 1. If I delete a row in sheet 1, I want to have the correspondi...

    ightbet | Latest reply: TrowaD Jun 3, 2019
    1 reply
  • VBA Code to apply in each monthly worksheet Closed

    Hi, I have a monthly creditor file (create new tab for each month when required) and want to calculate the amount outstanding each month, which is ...

    Micwhsct | Latest reply: ac3mark May 31, 2019
    13 replies
  • Formula in Excel to turn numbers into text Solved/Closed

    Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I wan...

    ashwin12289 | Latest reply: venkatesan May 31, 2019
    4 replies