Excel Forum

Ask a question
Search
Close
Results 1101 - 1150 of about 9,830
  • Record Scenario Iteration Results macro Closed

    Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...

    iuberrys | Latest reply: ac3mark Jul 24, 2017
    1 reply
  • Record Iteration Results Closed

    Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations and record the ...

    iuberrys | Latest reply: iuberrys Jul 24, 2017
    0 replies
  • Creating an auto updating sheet based on copy paste information Closed

    Greetings and salutations. I've been trying to figure out how to create a score card sheet for our field technicians based on some automatically ge...

    newman101 | Latest reply: newman101 Jul 24, 2017
    0 replies
  • Copy data from workbook to another work book using date range Closed

    Hello, i am new to this form and need some assistance in solving my problem i have below code which copy data into same workbook between 2 date ranges...

    narsing18 | Latest reply: narsing18 Jul 24, 2017
    0 replies
  • Reading text file containing data and output data in excel Closed

    Hi, ...

    idrees_azad | Latest reply: idrees_azad Jul 22, 2017
    0 replies
  • Send reminder email 3 days before the date Closed

    Hello, I'm new at this, any help will be appreciated. I need excel to send automatic email 3 days before expiration date. On my sheet theres...

    katherina03 | Latest reply: katherina03 Jul 21, 2017
    0 replies
  • Converting data in one column spanning three to four rows Closed

    dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...

    rhinoramanan | Latest reply: BrianGreen Jul 21, 2017
    5 replies
  • Macro for coloring cells according to the value of the cell Closed

    Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

    PeriGr | Latest reply: ac3mark Jul 20, 2017
    1 reply
  • Macro for coloring cells according to the value of the cell! Closed

    Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

    PeriGr | Latest reply: ac3mark Jul 20, 2017
    1 reply
  • Repeating a simple macro loop up to 1,500 times Solved/Closed

    Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...

    shassall | Latest reply: TrowaD Jul 20, 2017
    5 replies
  • Excel external data connection not working properly Solved/Closed

    Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...

    kvil | Latest reply: kvil Jul 19, 2017
    1 reply
  • Highlighting Multiple Cells When Using Complete or Partial Text Closed

    I currently work at a distribution center, and each day we perform lane assignments for outbound products. Attached is an image of our lane assign...

    lonewolf4001 | Latest reply: lonewolf4001 Jul 19, 2017
    0 replies
  • Value look up Closed

    Hello, On excel I have a master Sheet that I enter Names of people which is used to transfer the names to other sheets making it simple to print. H...

    clemiere | Latest reply: clemiere Jul 19, 2017
    0 replies
  • Conditional Row Copy/Consolidate Closed

    Hello, I am working with a database that deals with student scheduling in schools. I am getting repeated lines for each class a student is enrolle...

    iowen | Latest reply: ac3mark Jul 18, 2017
    3 replies
  • How to create a macro to copy and paste Closed

    How do I create a macro in excel to copy and paste row 1 through 18 in column A into column C. I want to copy and paste every 18 rows in order in colu...

    johncarr1973 | Latest reply: ac3mark Jul 18, 2017
    3 replies
  • Auto create new columns Closed

    Hello, I have a spreadsheet where I track attendance for my church throughout the year. We have events that happen on a daily basis. Most days I o...

    mwood6275 | Latest reply: mwood6275 Jul 18, 2017
    0 replies
  • Macro for coloring cells depending on values and presenting them Closed

    Hello guys!! I have an excel file with 2 columns of percentages. The first column has theoretical values of an experiment and the second column has...

    PeriGr | Latest reply: TrowaD Jul 18, 2017
    1 reply
  • Index formula questions Closed

    I have an index formula that will be calculating price points based on the values entered into the excel document. Is there a way to make sure that th...

    taylorwood09 | Latest reply: taylorwood09 Jul 17, 2017
    0 replies
  • Using VBA macro logic in Excel Closed

    One static Excel workbook with a ton of raw data that has a static number of columns (A-EK) that is always the same but the lines (1-X) is not static ...

    jordan112901 | Latest reply: jordan112901 Jul 17, 2017
    0 replies
  • Macros Closed

    I have a spreadsheet of 15000 lines, I need to copy the Cell ranges B:E onto the next line B:E, then go down to the next populated cell and do the sam...

    saratexas2001 | Latest reply: saratexas2001 Jul 17, 2017
    0 replies
  • Help creating macro Closed

    Hi, I have multiple excel sheets in multiple folders. I want to copy part of excel sheets which are in multiple folders and paste it in a new excel sh...

    Preethi3290 | Latest reply: Preethi3290 Jul 16, 2017
    0 replies
  • What function of Excel does this? Closed

    Hello, I know there must be a function in Excel that does this but I don't know what. If you know, please share or if I need a piece of code then ...

    iowen | Latest reply: iowen Jul 16, 2017
    0 replies
  • I need to create a formula IF with dates and 2 variables Closed

    Im trying to create the following formula in excel If theres number greater than 0 in a column and if the date in the other column is before one mon...

    adrianmty | Latest reply: Mazzaropi Jul 15, 2017
    1 reply
  • Compare two column from two different sheets Closed

    Hi...I want to compare two column from two different sheet which contain time and date.In sheet A column with date and time.In sheet B , there are two...

    Rana2604 | Latest reply: ac3mark Jul 14, 2017
    1 reply
  • Search option did not getting in Filters Closed

    Hi All, Hope you doing well !! When I update fliter in my Excel sheet then I did not getting the search like this, please find the snip below. ...

    swtmona | Latest reply: ac3mark Jul 14, 2017
    1 reply
  • Urgent Help-VLookUps in Excel Closed

    Hi, can we compare 2 excel sheets in which we have date related to Emails ID'S (Email recipients) but one sheet is having 230 rows and other 160 , i n...

    SatRud | Latest reply: ac3mark Jul 14, 2017
    1 reply
  • Create a date from 3 different cells Solved/Closed

    Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...

    Trowa | Latest reply: Udeni Jul 13, 2017
    11 replies
  • Check register with VLookup Closed

    Check Register Col.A Col. B Col.C Col H Col I 1 Payee ...

    Jude2007 | Latest reply: TrowaD Jul 13, 2017
    1 reply
  • Comparing Two Excel Sheets and copying like data to third Closed

    Hello, I used the below answer and it works but i actually need to tweak it to copy from the second sheet. So I have sheet 1 has full data and co...

    tyhipo | Latest reply: vcoolio Jul 13, 2017
    3 replies
  • Creating a Calendar that autopopulates from multiple sheets Closed

    Hi all, I am attempting to make a calendar that will auto populate or vice versa from multiple other sheets. This is all to track training hours fo...

    Bmaker23 | Latest reply: kadrleyn Jul 12, 2017
    1 reply
  • +1 for every letter "S" Closed

    I am trying to add 1 for every letter "s" between C5:C53,F5:F53,I5:I53. So far I have this formula =SUM(IF(C5:C53="S",1,0)) Which is giving...

    bored2 | Latest reply: Mazzaropi Jul 12, 2017
    5 replies
  • Macro to insert multiple rows between existin Solved/Closed

    Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...

    informme808 | Latest reply: Pedro Jul 11, 2017
    7 replies
  • Conditional Format help Closed

    I have an excel spreadsheet set up with 4 columns: Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date What I wo...

    jamie_ut | Latest reply: Mazzaropi Jul 11, 2017
    1 reply
  • Student position formula Closed

    Hello sir : I want to find the student position. But those student who fail in exam not incldue in the position.

    Zakirullah | Latest reply: Help-Jason Jul 11, 2017
    1 reply
  • Macro for creating separate files with fixed password from colum Closed

    Hi All, I need urgent help for a macro which will create separate files from a column value I have this data in the picture attached http://sta...

    pamla143 | Latest reply: pamla143 Jul 10, 2017
    1 reply
  • Copy and past the not equal value using macro Solved/Closed

    Hi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...

    ctran123 | Latest reply: Sam Jul 10, 2017
    3 replies
  • Free tools to compare data between two excel sheets Closed

    Hello, I need to compare 2 excel files and find the difference in data which needs to be highlighted. Though there are many online sources to c...

    Ramya | Latest reply: Ramya Jul 10, 2017
    0 replies
  • Adding delimiters between value of two columns in excel sheet Closed

    I have an problem, i made an excel macro for adding delimiters between value of two columns in excel sheet. Suppose i added delimiters between columns...

    garuna | Latest reply: garuna Jul 10, 2017
    0 replies
  • Generate workbook files from excel list Closed

    Hi, I have an excel questionnaire. It like to email it out to persons on an excel list with email addresses, first names etc. The problem is I w...

    sudhanraj | Latest reply: sudhanraj Jul 9, 2017
    0 replies
  • CF using date to change Font/Backgroundcolor to another cell Closed

    Hello, Good day, can you help me how can I change the font/background color of another cell base from the list in another cell. Example in A...

    edz | Latest reply: Mazzaropi Jul 9, 2017
    1 reply
  • Excel formula Closed

    who to pass in exam give the grade and who to fail in exam not give the grade show the empty cell excel formula

    zakirullah | Latest reply: Mazzaropi Jul 9, 2017
    1 reply
  • Auto Fill macro when data varies Closed

    I need to auto fill as a step in my macro but because the data will vary day to day it's breaking! Can someone help me? I need to auto fill column b ...

    Alh14 | Latest reply: Alh14 Jul 9, 2017
    0 replies
  • Logic or macro series created by entering single value in cell Closed

    hii need solution for excel i have series which is to be called / created by entering single value in cell for e.g i hv to call series for 55 it...

    vijayrsable | Latest reply: vijayrsable Jul 8, 2017
    0 replies
  • Require macro or logic in Excel Closed

    Hi i am looking for solution refer attached excel snapshot need to call or create predefined series in column by entering single value in cell ...

    vijayrsable | Latest reply: vijayrsable Jul 8, 2017
    0 replies
  • Need to compare data on the work book by giving deferent colour Closed

    Hi There are columns in a workbook with numbers in various cells. I want to compare values in each column with the previous column. Cell b1 should...

    ganesh7nadar | Latest reply: ganesh7nadar Jul 8, 2017
    0 replies
  • Script is really slow and sometimes crashes Solved/Closed

    Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...

    josh07429 | Latest reply: vcoolio Jul 7, 2017
    5 replies
  • Need VBA Macros to copy specific data based on condition Closed

    Suppose I file A which contains yearly data which we update on daily basis. lets say File A contains the data for year 2017 with following columns. ...

    sayureepreeti | Latest reply: ac3mark Jul 7, 2017
    1 reply
  • Compare five Excel workbooks and copying matched data to new one Closed

    I'm trying to compare five workbooks in excel and have matching column data copy the entire rows into a new workbook (ReportWorkBook). Ex: Compare ...

    net1media | Latest reply: net1media Jul 6, 2017
    0 replies
  • Help required to apply IF formula Closed

    Hello, I need a favor to add multiple if formulas for below conditions Column A Column B Column C Result Transactions ...

    hksanthosh | Latest reply: hksanthosh Jul 6, 2017
    0 replies
  • Need Help Creating a Formula for EXCEL Closed

    I'm not too familiar with excel, i'm trying to start a small home business and i'm creating invoices using excel. I need help with a formula that woul...

    five2588 | Latest reply: five2588 Jul 5, 2017
    3 replies