Excel Forum

Ask a question
Results 2551 - 2600 of about 9,840
  • What does this macro code mean? Closed

    Hey, The below macro was posted by another user, aquarelle, and is very useful for inserting copies of rows in an excel sheet. I tried asking them ...

    nbe9 | Latest reply: nbe9 Apr 21, 2016
    4 replies
  • How to copy Data from one excel sheet to another by criteria vba Closed

    I have data in Sheet1 and am trying to copy Range("A1:B8") from sheet1 to Sheet2 But while copying there are some condition Conditions are as foll...

    alex4611 | Latest reply: alex4611 Apr 21, 2016
    0 replies
  • Compare Fields Closed

    Hello, My name is Swapnil Veer. I have two sheets in excel. I have to compare two different columns in sheets and add respective entry in front of...

    Swapnil Arju... | Latest reply: Mazzaropi Apr 21, 2016
    1 reply
  • VBA group by code Closed

    Hi Everyone, I have data which looks like MANUFACTURER BRAND SEGMENT VALUE COLGATE Colgate BASE 500 COLGATE C...

    Sonal | Latest reply: Sonal Apr 21, 2016
    0 replies
  • Compare two columns Solved/Closed

    Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...

    kumar | Latest reply: kumar Apr 21, 2016
    2 replies
  • Transfer an entire row from one sheet to another Solved/Closed

    Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...

    JC | Latest reply: vcoolio Apr 20, 2016
    5 replies
  • Auto fill a Macro Closed

    Hello, I want to auto fill a macro button down column A, that copies the information from several cells to a different sheet in the work book. here ...

    marco 1 | Latest reply: vcoolio Apr 20, 2016
    5 replies
  • Funct for adding +1 to a cell if there's a value in other cells Closed

    Hope someone can help me with this, idk if it's possible in excel 2007. So basically I have a series of cells where 1 needs to be added depending ...

    helloitsme | Latest reply: helloitsme Apr 20, 2016
    0 replies
  • Conditional formatting, graded color scale Closed

    Hello, I use graded color scale from green to red to color cells based on value Example: Value (color) 1 (green) 10 (yellow) 20 (red) If m...

    Henrik | Latest reply: Computertech Apr 20, 2016
    1 reply
  • Barcode scan Closed

    Hello everyone, I would really appreciate if someone could help me out.. I'm a small reseller but now I have over 600 items. I use the same barc...

    JC | Latest reply: vcoolio Apr 20, 2016
    1 reply
  • Add to Excel Macros Solved/Closed

    Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...

    Victoria | Latest reply: vcoolio Apr 20, 2016
    6 replies
  • Formula for Fetch Data from another sheet Closed

    Hello, First I would like to asked that how could I insert a excel file or create a link, to understand my query. because the query that I want t...

    smuneeb | Latest reply: smuneeb Apr 19, 2016
    2 replies
  • Formula to copy data based on the text in the cell Closed

    Hello, I need to find out how to do this (and would be grateful if anyone could help me with this): I have a tab (1) in Excel with ten thousand...

    Aska | Latest reply: Mazzaropi Apr 19, 2016
    3 replies
  • Locking/unlocking a range of cell depending on other cell Closed

    Hi, I need some help - in cell A2 there can be entered a value from 1-48. If A2 is 1, then only cell B2 in column B should be unlocked (one cel...

    Sippenip | Latest reply: Sippenip Apr 19, 2016
    0 replies
  • A macro to insert pictures into Powerpoint slide from Excel Closed

    Hi guys, I need your help with my problem. I have two files, one excel file that include a schedule for the whole year with 6 coloum (A Week, B ...

    rodi.ali1 | Latest reply: rodi.ali1 Apr 19, 2016
    0 replies
  • droplist of tab names Closed

    Hello, I have a dropdown list of all my tabnames in a workbook. I want to create formulas that will read the selection in the drop down list and ...

    ExcelMiner | Latest reply: ExcelMiner Apr 18, 2016
    0 replies
  • formula to check days of the month and display only weekdays Closed

    Hello, Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and...

    Middo | Latest reply: TrowaD Apr 18, 2016
    1 reply
  • Multiple sheet, find, copy specific cell and paste Closed

    Hello, i have a challenge for you. Im working on a doccument to pull information from a different sheet, that was imported from a web based huma...

    Jeremyknight85 | Latest reply: TrowaD Apr 18, 2016
    1 reply
  • Protected worksheet Solved/Closed

    Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...

    whatsit | Latest reply: whatsit Apr 18, 2016
    2 replies
  • Inserting image files from a directory specified by text string Closed

    G’day CCM forum Quick hypothetical; I have a list of image file names in a column on an excel spreadsheet and a cell at the top of the page contain...

    MattRNR | Latest reply: MattRNR Apr 18, 2016
    16 replies
  • Copy row only if one cell's value is not 0 Solved/Closed

    I would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!

    victhor1977 | Latest reply: vcoolio Apr 18, 2016
    3 replies
  • Update value from table1 to table2 Closed

    HI I have following two tables in excels. I want to copy values from table1 to 2nd one Criteria- we need to copy last five value. example shows in ...

    Jeet | Latest reply: Jeet Apr 18, 2016
    0 replies
  • F2+Enter key for Macro Closed

    Hi I would like to request for a Macro that which execute a F2 and Enter keys. Please don't make a selection for a cells. I have a sheet where ...

    smuneeb | Latest reply: smuneeb Apr 17, 2016
    2 replies
  • Help with simple 2 step macro? Closed

    Hello, I ask help to write a macro that 1. searches for 1 name "(Nghiem, Emily)" 2. and then types "X" in the next cell to the right. (What I tr...

    emilynghiem | Latest reply: ac3mark Apr 15, 2016
    1 reply
  • multiple IF to show different statuses Closed

    Hello, I am trying to have different status in my reports depending on the dates in different cells H START I ACTUAL START J DUE K DATE COMPLETED...

    annemarie ric | Latest reply: JasmineJasmineVV Apr 15, 2016
    1 reply
  • Copy Cells Relevant to Unquie Col Match and Save to Local Drive Closed

    Hello, I am new to VBA, and was going back and forth between the available codes trying to create VBA to execute the following, but was not able to...

    Shanl7 | Latest reply: Shanl7 Apr 15, 2016
    0 replies
  • Conditional Formatting based on Text in another Sheet Closed

    Hello! I'm currently using Google Sheets, but I believe the formatting is the same. I am working on two separate sheets, one "Cashflow" and one "In...

    katrich | Latest reply: katrich Apr 15, 2016
    0 replies
  • How to get a macro to work in all worksheets Closed

    I know I am missing something simple here. I made a macro to create a chart from a template based on two ranges in a worksheet (Brisbane April Sales ...

    Robbo | Latest reply: Robbo166 Apr 14, 2016
    3 replies
  • double conditional formatting Closed

    Hello, I would like to ask for your help with some conditional formatting, can’t really get my head around it. What I have: 1. Two columns in C an...

    leep94 | Latest reply: leep94 Apr 14, 2016
    0 replies
  • Put in today's date if other cell has color. Closed

    Hi there everyone, I have a question about excel and I would love if someone could help me with it! I have an accountant sheet with invoices. When a...

    Anands | Latest reply: Anands Apr 14, 2016
    0 replies
  • A variation on the compare 2 columns in Excel Solved/Closed

    Guys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...

    BrianGreen | Latest reply: BrianGreen Apr 13, 2016
    2 replies
  • Automatic Data Transfer Closed

    Hello, i am trying to extract data (certian colums )from one workbook to another workbook from a certian date, and everytime the orgininal workboo...

    shal | Latest reply: shal Apr 13, 2016
    0 replies
  • Call createJpg (reference sheet) Closed

    Hey I have a doubt on this code ... > With OutMail > .SentOnBehalfOfName = "***@***" > .Display > ....

    rodrigo723 | Latest reply: rodrigo723 Apr 13, 2016
    0 replies
  • Search for a word in a worksheet and return row Closed

    Hi, Hoping to get some help. I have a spreadsheet full of data in Sheet 1 from A1:AG159382. I would like to use a separate worksheet to search for...

    tina16marie | Latest reply: vcoolio Apr 13, 2016
    3 replies
  • If Then Formula Closed

    Hello, I am trying to build an If Then formula. I am trying to reference a cell with a specific text in one cell like A2=Light and only if Lights is ...

    The Glyde | Latest reply: vcoolio Apr 13, 2016
    3 replies
  • How to change word in cell using another word in another cell Solved/Closed

    Hello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...

    Cherietan | Latest reply: Cherietan Apr 13, 2016
    10 replies
  • copying macro Closed

    I want to write a macro where it groups my data by group # and copy the data of each group # into different sheets. Afterward, rename each sheets t...

    group123 | Latest reply: group123 Apr 12, 2016
    5 replies
  • How to extract&automate dailymaster excel sheet using macros/vba Closed

    Well, On daily basis I get master data sheet and create a excel reports manually, I can add columns and use formulas to get required result, you can s...

    bgn07 | Latest reply: bgn07 Apr 12, 2016
    0 replies
  • trying to get an if statement working Closed

    i am trying to make a formula that when these cells have text in them, a counter goes up. my code here =IF(ISTEXT(C3),1,"")+IF(ISTEXT(D3),1,"")+IF(...

    ayylamo | Latest reply: ayylamo Apr 12, 2016
    0 replies
  • Conditional formatting one cell value changes formatting Closed

    Hello, I am trying to create a comprehensive to do list for my work. I have a "Completed"(A1) column and a "Task"(B1) column. When I enter a va...

    Fahad | Latest reply: Fahad Apr 11, 2016
    0 replies
  • Compare 2 lists of numbers Closed

    Hello, I have 2 lists of serial numbers. One is a master list of all serial numbers and is 234 rows by 4 columns. There is a blank column next t...

    New to VBA | Latest reply: New to VBA Apr 11, 2016
    0 replies
  • IF Function Time Solved/Closed

    Hello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...

    Ashakil | Latest reply: Ashakil Apr 11, 2016
    2 replies
  • Check if there is a match to a cell in the rest of the workbook Solved/Closed

    Hello, I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that...

    Ixon | Latest reply: Ixon Apr 11, 2016
    0 replies
  • Making selections for unknown data in excel Closed

    If i have an excel spreadsheet that has 1491 items in a specific column and i want to select every 149th item in that column so that i select 10 items...

    gvrn | Latest reply: gvrn Apr 10, 2016
    0 replies
  • if in 1 row one cell are equal to another cell in th 2 row i ... Closed

    Hello, in excell i have 2 row and i have a cell from 1 row that equal to a different cell from the 2 row i want to copy the content from a different...

    DANIDIN | Latest reply: DANIDIN Apr 10, 2016
    0 replies
  • Copying an entire worksheet to another worksheet automatically Closed

    Hello, How can I automatically copy all data from one worksheet to another to include charts etc. Basically a copy of another worksheet tab. than...

    Andy | Latest reply: vcoolio Apr 9, 2016
    3 replies
  • changing font colour in a range based on conditions in another Closed

    Many thanks for the answer provided so far. But what I actually want have not been solved. For example if any cell value in the range D4:D40 is betwee...

    marshal | Latest reply: marshal Apr 8, 2016
    0 replies
  • How to make Macro Repeat Closed

    Hello, I am trying to run a macro where I multiply a range (B3: B615) by a number (B2). The problem is I want to do this for every column in my wo...

    Fred | Latest reply: ac3mark Apr 8, 2016
    1 reply
  • Changing font colour in a range based on criteria in another Closed

    Hello, I am trying to change the font colour in a range of cell based on conditions i set in another range of cell. How do i go about it, its giv...

    Marshal | Latest reply: ac3mark Apr 8, 2016
    1 reply
  • Relating today to other dates Closed

    Hello, =IF(M38>=A197;(M38);(O38)) M38 - date for the first payment A197 - =Today() O38 - date for the second payment What I wanted with th...

    Carolina | Latest reply: vcoolio Apr 8, 2016
    1 reply