Excel Forum

Ask a question
Results 1301 - 1350 of about 9,840
  • any one can help. Closed

    Hi All, column C is from 1 to 12 column D is an amount I have a table of numbers which categorized the numbers with specified amount and catego...

    mekko | Latest reply: mekko May 8, 2017
    0 replies
  • Data draw issues Closed

    Hello, We're trying to create a document that displays the amount of homework hours for students based on the totals found in separate excel docum...

    Randalf_the_Red | Latest reply: Randalf_the_Red May 7, 2017
    0 replies
  • Conditional Formatting Closed

    Hello, I am trying to change a text color of one column based on another columns value. For example in Column A if it shows a W then the Dollar amou...

    Chris172 | Latest reply: Mazzaropi May 7, 2017
    1 reply
  • How do I use conditional formatting in Excel Solved/Closed

    Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...

    newbie | Latest reply: Mazzaropi May 6, 2017
    3 replies
  • Parent/Child flat heirarchy formula needed Closed

    Hello, I need to compare data from one column to a another column in a hierarchy level, so if the level is 1, there is information in different co...

    jgroverm | Latest reply: jgroverm May 5, 2017
    0 replies
  • Move named data from rows to same named columns Closed

    I have a spreadsheet that has different test results for the same patient listed n multiple rows. I need to have all the results for the same patient ...

    kcliff | Latest reply: kcliff May 4, 2017
    0 replies
  • How to simplify data entry Closed

    Hi All ok I have a daily sheet that i fill in every day it contains 5 fields I have another worksheet that i then copy the information from the...

    Gofreo | Latest reply: x May 4, 2017
    12 replies
  • (Excel Vba) Copy paste of multiple columns Closed

    Hi All, I am stacked with a simple VBA macro. I have an excel sheet containing a number of columns and i have created a Montecarlo simulation where c...

    carlius83 | Latest reply: TrowaD May 4, 2017
    1 reply
  • onclick the button view the time in activecell Closed

    Hi, I am using this code it's run successfully but each time click the button then overall change the cells. I want each cell view the current time...

    vaali | Latest reply: TrowaD May 4, 2017
    1 reply
  • Clear the previous Image Closed

    Hello, I have inserted the image in excel sheet by entering the code in VB. On reload it overwrites the new image on the old image rather than firs...

    harshesh | Latest reply: harshesh May 3, 2017
    0 replies
  • Transferring Data Closed

    I have monthly payment sheet for each student. I need to take the full roster of payments made to transfer to the individual monthly payment sheet fo...

    jmitchell93 | Latest reply: jmitchell93 May 2, 2017
    0 replies
  • Date drop down on front sheet that will create new dated tabs Closed

    Hello, I am trying to create a workbook for recording daily pressure readings from different systems and I am trying to create a front page with a...

    fozzauk | Latest reply: ac3mark May 2, 2017
    1 reply
  • Excel VBA - Find and Expand matching cell entries Solved/Closed

    Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...

    RabbitWarren | Latest reply: x May 2, 2017
    1 reply
  • How to populate information on multiple sheets at once Solved/Closed

    Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...

    JPSpark | Latest reply: TrowaD May 2, 2017
    14 replies
  • Unable to download complex tables data on webpage using Query Closed

    Hello, I am trying to figure out a way to download the data from this webpage, which has 4 collapsible sections but no luck whatsoever yet. htt...

    kl.rameet | Latest reply: TrowaD May 1, 2017
    3 replies
  • Comparing Excel Sheets and copying changed data into a new sheet Closed

    I'm trying to compare a master excel sheet to updated excel sheets and create a new sheet with the new data. For example: Master Data Sheet has Name...

    trixxzie | Latest reply: trixxzie Apr 30, 2017
    0 replies
  • Creating 1 master sheet from data from multiple sheets Closed

    Hello, So I am at a complete loss on how to solve my problem. I'm brand new to excel and any help would be much appreciated. What I'm wanting t...

    ExcelNoNothing | Latest reply: vcoolio Apr 29, 2017
    1 reply
  • Copy and insert rows n number of times in Excel Solved/Closed

    I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 A2 999 90 M 25 ...

    SentiaD | Latest reply: SentiaD Apr 28, 2017
    0 replies
  • Populating a Summary Report Closed

    I've been tasked with taking a large worksheet (>20K rows and 25 columns) and populating a summary report in a (pre-labeled) different worksheet. The...

    ExcelNewb17 | Latest reply: ExcelNewb17 Apr 27, 2017
    4 replies
  • Autopop Info on Sheet based on Criteria from Master Sheet. Closed

    Hi All, I am creating a Master spreadsheet that has information across rows. I want this information to auto-populate on a different spreadsheet dep...

    MBrownie | Latest reply: vcoolio Apr 27, 2017
    4 replies
  • Date format not valid Closed

    Hello, Sir i would like you to help me on the following problem, i am filling an application form and i have done everything but on the date side ...

    chimwemwe nk... | Latest reply: Zohaib R Apr 26, 2017
    1 reply
  • Splitting data from worksheet to workbooks based on column Closed

    Hello, The code gives prompts me to enter the column on which the split needs to be done, but soon after that thrown an error:Run-time error '1--4...

    CHitra | Latest reply: Zohaib R Apr 26, 2017
    1 reply
  • If/and function Closed

    i need to update a spreadsheet on the progress of documents being approved. i want to create a function that states if the document is "approved" (...

    kath7564 | Latest reply: Zohaib R Apr 26, 2017
    4 replies
  • Automatic when excel open reminder mail go through outlook Closed

    Hello, I wan to know how to send reminder mail from excel when it open and when before due dates of 3, 7, 30 days before multiple reminders I wan...

    kalpna | Latest reply: kalpna Apr 26, 2017
    0 replies
  • Shortcut to edit a cell without using F2 key Solved/Closed

    Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...

    Ben | Latest reply: BenFromSingapore Apr 25, 2017
    7 replies
  • Selecting a block of cells depending on the values of two others Closed

    Hi all I'm pretty new to macros and I have been unable to find the answer to this question anywhere. I'm trying to write a macro that will selec...

    jwilson28 | Latest reply: TrowaD Apr 25, 2017
    4 replies
  • Conditional formatting based on column of values Closed

    Hello, I would like to do conditional formatting column B if its part of text matches with values in any cell of column C. Could you please help m...

    Sivanesan | Latest reply: TrowaD Apr 25, 2017
    1 reply
  • Macro to create worksheets and copy data from a summary page Closed

    I have a workbook called Sales Commission and sheet 1 is my summary page. I want to write a macro that will look at the summary page and from column ...

    annamcd | Latest reply: vcoolio Apr 25, 2017
    1 reply
  • Conditional format if hyperlink Solved/Closed

    Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...

    Obonden | Latest reply: ac3mark Apr 24, 2017
    12 replies
  • convert a sentence in a cell with the American date Closed

    Hello, I am trying to convert a sentence in a cell with the American date last to the sentence with Canadian date last. ex. CASH OVER/SHORT 04/01...

    grbrck | Latest reply: TrowaD Apr 24, 2017
    1 reply
  • copy and paste values automatically to empty cells below Closed

    Hi - for background, I created a "slot Machine" in excel that combines three random number generators and generates either a -$1 or +$10 if you don't ...

    m22capital | Latest reply: TrowaD Apr 24, 2017
    1 reply
  • VBA Help Needed Closed

    Hello, I have written code to prompt the user to state how many new sheets they want to add. But I need for the data on the "Main" sheet to always ...

    jetski1202 | Latest reply: TrowaD Apr 24, 2017
    5 replies
  • Compare the words in 2 columns in Excel Solved/Closed

    I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...

    chongml | Latest reply: TrowaD Apr 24, 2017
    11 replies
  • Drop down menu, copy/transfer 2 new sheets only if cell has data Closed

    Hello, I am trying to create a sheet that references items if they are selected from another sheet from a drop down menu. IF they are selected then...

    cory_boss | Latest reply: TrowaD Apr 24, 2017
    13 replies
  • Excel forum within a range Solved/Closed

    Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...

    Gerberreinette | Latest reply: Gerberreinette Apr 24, 2017
    2 replies
  • Need to delete columns based on Column header Solved/Closed

    Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...

    yesare | Latest reply: topazfae Apr 21, 2017
    7 replies
  • Compare 2 columns on different sheets and move data when match Closed

    Hello, I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one workshe...

    AnnetteeBrown | Latest reply: ac3mark Apr 21, 2017
    1 reply
  • Copying An Entire List of Formulas into another Work Sheet Closed

    Hello, I have a list of sumif statements that I would like to copy from one excelsheet to another. Can this be done all at once, without changing ...

    ChattyKathy | Latest reply: ac3mark Apr 21, 2017
    1 reply
  • Caculating the number of months between a set of dates Closed

    Hi, I am trying to calculate the number of months between two dates that relates to a specific time frame (financial year). Is anyone able to su...

    Help123 | Latest reply: Help123 Apr 21, 2017
    0 replies
  • Auto Generate Dates Closed

    Hi All, I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only we...

    gerry_itac | Latest reply: TrowaD Apr 20, 2017
    1 reply
  • Summery Sheets Closed

    Dear All, I am maintaining a File in Excel for Employee's Vacation and every year has a different file. In this file I am adding a new Sheet by the...

    Rizvi14 | Latest reply: TrowaD Apr 20, 2017
    1 reply
  • Auto generation of code Solved/Closed

    Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...

    karthick | Latest reply: TrowaD Apr 20, 2017
    1 reply
  • what is the Numbe shoud be instead of ?? Closed

    what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...

    selajam | Latest reply: TrowaD Apr 20, 2017
    1 reply
  • Need macro to copy certain data from a form on one tab to a log Closed

    Hello, Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user ...

    sand3045 | Latest reply: ac3mark Apr 19, 2017
    1 reply
  • VBA Coding to copy data from one worksheet to another worksheet Closed

    Hello, I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria an...

    tippy99001 | Latest reply: ac3mark Apr 19, 2017
    3 replies
  • filter between 2 dates Closed

    Hello, please i want to filter data between 2 dates (start date and end date) with textbox and button command, i am new to programming in vba; plea...

    elngoma | Latest reply: kadrleyn Apr 19, 2017
    1 reply
  • How to use VBA Macros in excel 2016 Closed

    Hi, Need a bit help for now. I am going to make transmittal that has two sheets which includes input(data) and output(transmittal). This will be my tr...

    Ferls | Latest reply: Ferls Apr 19, 2017
    0 replies
  • Excel - A macro to create new workbook and copy data Solved/Closed

    In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...

    Shridharb2002 | Latest reply: TrowaD Apr 18, 2017
    29 replies
  • How to populate sub sheets based on criteria from a master Closed

    Hello, I'm working on a master file with sub sheets. I'd like to auto populate data from rows A-S to sub sheets (Dave, Jamal, Addi), based on data ...

    EMS360 | Latest reply: EMS360 Apr 15, 2017
    0 replies
  • Excel - macro to create multiple sheets Solved/Closed

    Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...

    Mariaca113 | Latest reply: vcoolio Apr 14, 2017
    5 replies