Excel Forum

Ask a question
Search
Close
Results 4351 - 4400 of about 9,810
  • Conditional Formatting Closed

    Hello, I'm trying to create a table for a field trip. Essentially, I want the students name highlighted based on their homeroom teacher. There are...

    Phil | Latest reply: Mazzaropi Dec 13, 2014
    1 reply
  • Macro/command button help Solved/Closed

    Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...

    sillygoose2014 | Latest reply: vcoolio Dec 13, 2014
    12 replies
  • Copy info from one excel sheet to another sheet Solved/Closed

    Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...

    sstanger | Latest reply: sstanger Dec 12, 2014
    2 replies
  • Avoiding excel cropping text when next cell contains formula Closed

    Hello, If you have empty cells to the right, text from a cell will float over the columns following. However, if you have a formula placing "empty...

    Udi | Latest reply: Udi Dec 12, 2014
    0 replies
  • to check first letters of two columns are equal Closed

    Hello, could you please tell me how to check whether first letters of two columns are equal

    donaustin | Latest reply: TrowaD Dec 11, 2014
    1 reply
  • how to auto copy Closed

    Hello, My workbook contains about 1000 sales entries on sheet 1 . Some customers paid in full, but some other don`t. I will put a * beside the cus...

    im stupid | Latest reply: TrowaD Dec 11, 2014
    5 replies
  • What Type does it want? (VBA question) Solved/Closed

    Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...

    InsertNickna... | Latest reply: TrowaD Dec 11, 2014
    3 replies
  • comparing two columns Closed

    I have two columns both of which contain list of names.i want to get the output as true if the names are somewhat similar eg dane john and dwayne john...

    donaustin | Latest reply: TrowaD Dec 11, 2014
    4 replies
  • Auto Hide Rows & Columns Closed

    Hello, i have a worksheet with many formulas in it. i use bellow code for auto hide rows and columns when a a cell in that column or row is 0 or e...

    mathewmunna | Latest reply: mathewmunna Dec 11, 2014
    0 replies
  • copy info from one excel sheet to another sheet Closed

    I have sheet 1 that i call "FORM" that I enter information into. I would like to create a macro to copy the info that i put on the FORM onto sheet 2 "...

    sstanger | Latest reply: sstanger Dec 10, 2014
    0 replies
  • Excel Macro to Create a Workbook for Each Change in Column A Closed

    Hello everyone. I love forums like this where the community helps one another and solve real life problems faced by real users. I would very much ...

    RodExcel | Latest reply: RodExcel Dec 9, 2014
    0 replies
  • fix the last date Closed

    Hello, my target is 3900 but daily target is 50, how to fix last date for closing of my target. please define formula with examples Configurati...

    srinivas | Latest reply: TrowaD Dec 9, 2014
    1 reply
  • Conditional formatting??? Closed

    Hello, If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)... ...

    Ash | Latest reply: TrowaD Dec 9, 2014
    1 reply
  • VBA programming, copy wks from one file to another Closed

    Hi, I am struggling with the code to copy each sheet in workbook1 to workbook2) Dim NewWorkbook As Workbook Dim Wks As Worksheet Dim wb1 As Work...

    MisterTS | Latest reply: MisterTS Dec 8, 2014
    0 replies
  • Conditional Formatting to hide 00:00 in column Solved/Closed

    Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...

    sharky9000 | Latest reply: Sharky9000 Dec 8, 2014
    4 replies
  • coping & pasting data in first blank cell in same worksheet Closed

    Hello, I would like the vba code for a macro ( using a form button) that copies data from cell:M1 to A13:A30 depending on which is the first blan...

    Jim | Latest reply: TrowaD Dec 8, 2014
    1 reply
  • Conditional Formatting based on Checkbox Closed

    Hi, I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "...

    EClem | Latest reply: TrowaD Dec 8, 2014
    1 reply
  • help me on this formula to shorten Solved/Closed

    Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...

    mathewmunna | Latest reply: mathewmunna Dec 6, 2014
    5 replies
  • conditional format problem Closed

    I have 3 columns Column A start time (hh:mm) Column B finish time (hh:mm) Column C is total Time (hh:mm) where C is (24-A1)+B1 etc How can I hide the...

    sharky9000 | Latest reply: sharky9000 Dec 6, 2014
    0 replies
  • How to copy data from one spreadsheet to all others Closed

    Please, does anyone have a macro to copy data from a specific range on a standard sheet (ideally with formatting) to all but one other sheet active in...

    LEJN | Latest reply: rizvisa1 Dec 6, 2014
    3 replies
  • Copy data based upon cell value Closed

    Hello, Need help on copying data from file1.xlsx into multiple .xlsx file based upon column G values. The file1.xlsx contains... Column F Column...

    ShailShin | Latest reply: rizvisa1 Dec 6, 2014
    6 replies
  • Macro to insert pictures using 2011 excell Closed

    Hello, im trying to make a prototype for a POS that insert images into the invoicing system. for the most part i have this functional, but the boss ...

    Sean | Latest reply: Sean Dec 6, 2014
    0 replies
  • Excel Macro for copy row to another workbook. Closed

    Hello, New-ish to excel and I'm helping improve systems at the work place. The issue is I want to be able to copy a row. e.g. | New | 12345...

    orchslayer | Latest reply: vcoolio Dec 5, 2014
    1 reply
  • Transpose Column to Row Closed

    Hi All, I have list of data need to transpose as below. Anyone can help with the macro? Thank you. From Material Des ww1 ww2 A Q 1 4 B E 2 ...

    allykoh | Latest reply: allykoh Dec 5, 2014
    0 replies
  • Excel Picture Inserting Macro Help - Urgent Solved/Closed

    Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro which ta...

    nadimn | Latest reply: jackcluseau Dec 4, 2014
    25 replies
  • date formats Closed

    Hello, friends... i have problem in the date formats i have an excel sheet with data i am trying to filter by date 01/12/1999 this is the dat...

    vijay | Latest reply: vijay Dec 4, 2014
    0 replies
  • Create a formula in excel to scan workbook and move to new one Closed

    I want to know how to create a formula that scans all of column A only for duplicate data and if found than in a new worksheet copy the entire first r...

    mario | Latest reply: mario Dec 4, 2014
    0 replies
  • Conditional Formatting on Excel 2010 Closed

    Hi, I am trying to figure out the correct method in which to apply a formula in conditional formatting. The first row contain the document names....

    Clue J | Latest reply: TrowaD Dec 4, 2014
    1 reply
  • how autofill data from sheet1 to sheet2 in different order. Closed

    When we type numbers in any sequence in sheet1 but they out come countinusely in sorting sequence in sheet2

    nrchampak ka... | Latest reply: TrowaD Dec 4, 2014
    1 reply
  • Populating a column of data based on drop down selection Closed

    Hello, I am trying to populate a column with data from a seperate sheet based on a selection from a drop-down list. The drop list and the desire...

    pMazz | Latest reply: pMazz Dec 4, 2014
    0 replies
  • Making a table based on cell value. hide row. conditional format Closed

    Hello, This is for a machinery quotation, based on model type and specifications I have a sheet in which cell B2 has a drop down menu listing 4...

    belseat | Latest reply: belseat Dec 4, 2014
    0 replies
  • Multi percentage Calculation Closed

    Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I attac...

    Winndixie | Latest reply: Winndixie Dec 4, 2014
    4 replies
  • If dates range Closed

    Hello, I need help for a function. Lets say that we have the today date 4/12/2014. I need a formula to use in conditional formatting. If the da...

    Natassa | Latest reply: Natassa Dec 4, 2014
    0 replies
  • How to count different charecters Solved/Closed

    Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...

    mathewmunna | Latest reply: mathewmunna Dec 4, 2014
    5 replies
  • Date if statments Closed

    Hello, I have a if statement that I need help writing. I have a today date cell and I have closed date. I am trying to make the new cell check i...

    eric | Latest reply: eric Dec 3, 2014
    0 replies
  • Check if input number is minimum and display a pop up dialogue Closed

    Hi, I am novice VBA developer. I am trying to write a macro which does following. 1.When a user enter a particular value into cell 2.Check if ...

    mmk622 | Latest reply: Murali Dec 2, 2014
    2 replies
  • change date format Closed

    Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007

    tariq | Latest reply: ac3mark Dec 2, 2014
    1 reply
  • for progress billing Closed

    Hello, how can i automatically know the percentage area of a accomplished tiles by simply counting the tiles Configuration: Windows / Chrome 3...

    peter | Latest reply: ac3mark Dec 2, 2014
    1 reply
  • compare two excel sheets and get unique value from both into new Closed

    Hi, I have two excel sheets. Sheet 1 with 4 columns and sheet 2 with 2 columns. I need to compare column 1 of sheet1 with column 1 of sheet 2 if it m...

    Madhu | Latest reply: Madhu Dec 2, 2014
    0 replies
  • How can I transfer data from one spread sheet to another? Solved/Closed

    Hi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data ...

    elizatex | Latest reply: elizatex23 Nov 30, 2014
    5 replies
  • Finding data in different Excel sheets with month-sort by VBA? Closed

    Hello, I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a tabl...

    polarstorm | Latest reply: polarstorm Nov 29, 2014
    2 replies
  • automatically moving rows from sheet 1 to sheet 2 Closed

    My document has several sheets, but what I'd like to do is create a VBA to automatically move a row to sheet 1 from sheet 2 when I have selected 'Acti...

    spreadlove1 | Latest reply: vcoolio Nov 29, 2014
    1 reply
  • Repair Corrupt Excel File Closed

    I have an excel 2003 workbook that will not open. The file is huge. I have tried the repair utility within Excel but it still will not open. Has an...

    demetripan | Latest reply: alvarsson52 Nov 29, 2014
    1 reply
  • Data validation Closed

    I want a sheet of income tax calculation, so i like a input a cell pan no. so allow in cell LENTH 10 DIGIT AND first five text and mid four number and...

    ranwavijay | Latest reply: ranwavijay Nov 28, 2014
    0 replies
  • 2 macros in one sheet targeting same cells Solved/Closed

    This is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to automatically...

    chester4207 | Latest reply: chester4207 Nov 28, 2014
    2 replies
  • Lock Flag ignored:How is this possible? Closed

    Hello, Cells C4 and D4 are empty cells, and both are locked in Format Cells->Protection-> Locked. I go to Tools-> Protection-> Protect Workshee...

    SomeGuy | Latest reply: rizvisa1 Nov 28, 2014
    1 reply
  • Help me on this formula to shorten Closed

    Hello, please help me out to shorten this formula.. =IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="...

    mathewmunna | Latest reply: Mazzaropi Nov 28, 2014
    1 reply
  • How can we find data in different Excel sheets by VBA? Solved/Closed

    Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table wit...

    polarstorm | Latest reply: polarstorm Nov 27, 2014
    0 replies
  • Create a new sheet using data in one column copying data Closed

    Does any one know how to create a macro which takes the following data: A B C D 1 Rabbit Carro...

    LEJN | Latest reply: LEJN Nov 27, 2014
    0 replies
  • Copy rows from activesheet and create and paste in new sheet. Closed

    Hey guys I have a workbook with +-5000 rows of rooms in different buildings. I want use the column BUILDING_CODE and copy all the rooms that have ...

    heyxarno | Latest reply: heyxarno Nov 27, 2014
    2 replies