Excel Forum

Ask a question
Search
Close
Results 3251 - 3300 of about 9,840
  • conditional Formating a column Solved/Closed

    Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...

    Ian | Latest reply: Ian Oct 8, 2015
    2 replies
  • Find words within cell & put value in adjacent Closed

    Column has Organisation Name Need to Search and Create a category to the next 5 columns A Organisation can have key word in more than 1 category...

    Grouchoed | Latest reply: Mazzaropi Oct 8, 2015
    1 reply
  • Help Request - for Advanced Filter Macro VBA Closed

    Hello, I would like to have data from my master sheet to another one based on multiple criteria filter. My master sheet can be manually filled and ...

    evergreenX | Latest reply: evergreenX Oct 8, 2015
    4 replies
  • Copy cells based on conditions Solved/Closed

    Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...

    pefler | Latest reply: pefler Oct 8, 2015
    2 replies
  • Comparison of Cells Closed

    Hello, I want to compare two different cells in two different sheets and print the same in third sheet. 1) For Example in sheet1 is P and sheet2 is...

    Neelakanta | Latest reply: Neelakanta Oct 8, 2015
    0 replies
  • VBA macro to color a range of cells based on value of other cell Closed

    Hello, I' am using a shared file and hence could not use conditional formatting. I want range C2:F2 should turn Blue is the value in cell G2 is...

    Ashok | Latest reply: rizvisa1 Oct 7, 2015
    3 replies
  • Another Excel macro copying cells based on criteria Closed

    Hi Excel Virtuosos, I've really been scratching my head over this one. I'm compiling a summarised history of a project since its conception 7 years ag...

    igdent | Latest reply: igdent Oct 7, 2015
    0 replies
  • Automate some of my daily Activity in Excel using Excel Macros Closed

    Hello, I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I wo...

    ccmsri | Latest reply: ac3mark Oct 7, 2015
    3 replies
  • Copying data from workbook to workbook using button Solved/Closed

    Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...

    Oxy | Latest reply: ac3mark Oct 7, 2015
    4 replies
  • Change color to different cells based on another cells text. Solved/Closed

    Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...

    Riggs2015 | Latest reply: Riggs2015 Oct 7, 2015
    4 replies
  • Need to find multiple Words to I Category (column) Closed

    Apple, Pear, Peach example in one cell to be dragged down to 10000+ =IF(ISERROR(SEARCH("*apple*",A1,1)),"","Category ")

    Grouchoed | Latest reply: Grouchoed Oct 7, 2015
    0 replies
  • Auto notify or mail when excel sheet updated. [Solved/Closed] Closed

    Hello, I have used following VBA, but still I am not getting the solution. Please help I am unable to change the following field. answer = M...

    Sudhakar M | Latest reply: rizvisa1 Oct 7, 2015
    1 reply
  • Unable to get email notifciation Closed

    Hello, I have placed below noted in my excel. but I am unable to get the email to my ID. Please help me Private Sub Workbook_BeforeSave(ByVa...

    Sudhakar M | Latest reply: rizvisa1 Oct 7, 2015
    3 replies
  • Excel Workbook Closed

    Hello, I have a workbook with over 100 sheets. One of the sheets has a title of labels, I am trying to set it up ina way that if i type in sheet 10,...

    Lucas | Latest reply: rizvisa1 Oct 7, 2015
    1 reply
  • Copy cell, unless another call says specific text Closed

    Hello, In my spreadsheet, currently C1 copies the number in A1. (=A1) I need this command to be overridden if B1 contains the text VISUAL Tha...

    Damo | Latest reply: rizvisa1 Oct 7, 2015
    3 replies
  • Multiple line to Single line in Single cell Closed

    Hello, i have document in word, need to transfer the data to Excel, So copy sentecence and paste in Excel cell, but i will come like multiple line...

    sun | Latest reply: sun Oct 7, 2015
    0 replies
  • Compare two worksheets and Remove duplicated data from one Solved/Closed

    Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...

    fillup56 | Latest reply: fillup56 Oct 6, 2015
    3 replies
  • Search for matches from columns on separate sheets. Solved/Closed

    Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...

    Tim | Latest reply: Tim Oct 6, 2015
    2 replies
  • Adding days to an auto populated date in Excel Closed

    Hello, I want to add 3 business days to a auto populated date in another field. So for example. B1 will have the auto date (Based on a system ent...

    Don | Latest reply: ysantana Oct 6, 2015
    6 replies
  • Macro help required Closed

    Hi, If anyone can help me to create the excel macro on- I have 12 rows data in excel with cell position A to BT. My requirement is- I want to copy ...

    jk_1 | Latest reply: rizvisa1 Oct 6, 2015
    1 reply
  • Help please, VBA userform, MsgBox! Closed

    Hello. I have a userform that I use to introduce some data on excel. Most of the data must be filled (that are textbox that the verifications d...

    alfa_eng | Latest reply: rizvisa1 Oct 6, 2015
    1 reply
  • excel formula using Julian calendar Closed

    Hello, Can someone please help me create a formula in excel to convert A16612009 to 6/15/2015. The letter A stands for the year 2015, 166 stands ...

    judy | Latest reply: rizvisa1 Oct 6, 2015
    1 reply
  • How to lock/unlock a workbook with multiple passwords Closed

    Hello, I would like to lock/unlock a work book with multiple passwords. I would also like to add a Log tab and have the unlock record the user, d...

    Jennifer | Latest reply: rizvisa1 Oct 6, 2015
    1 reply
  • How to use macro to copy data from workfile A to workfile B Closed

    Hi, COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :- Source data copy from:-...

    MilliY | Latest reply: Sad Oct 6, 2015
    2 replies
  • Macro to transfer data from single to multiple columns Closed

    So I have been doing research but have been unable to find a macro that does what I need. Basically, I have multiple items on different carts, labeled...

    NoWhiteFlags | Latest reply: TrowaD Oct 6, 2015
    1 reply
  • display a new entry in a column in a separate cell in excel Closed

    Hello, I am having a column; A B 1 ab 2 abc 3 abcd 4 abcde 5 xyz 6 I want the next entry in 6 row of A to ...

    vivek | Latest reply: TrowaD Oct 5, 2015
    1 reply
  • Converting number into alphabetic word Closed

    Kindly help in converting this 1,055.25 into alphabetic word... Thanks, Melvin Manila, Philippines

    Melsky | Latest reply: TrowaD Oct 5, 2015
    1 reply
  • Whole Numbers and Decimals Closed

    Forgive me if I was an anonymous user who had only a single question to ask after searching the internet for hours, and didn't know there were courtes...

    ConcernedMat... | Latest reply: Mazzaropi Oct 5, 2015
    1 reply
  • Remove data on one worksheet if it appears in the other Closed

    I have two separate worksheets "Customers" & "Members". Some customers are also members. I want to remove all Customers from the Members sheet. T...

    fillup56 | Latest reply: fillup56 Oct 4, 2015
    0 replies
  • Conditional formatting Closed

    Hello, I am trying to format a column B2 to B56 with different dates in each row to change yellow when each date is 30 days before the due date and ...

    barrywood | Latest reply: barrywood Oct 4, 2015
    0 replies
  • Whole Numbers and Decimals Closed

    Hello, So my problem is that I have a big chart with lots of numbers in it. Some are whole numbers "1,2,3,4,etc." and others are decimal numbers "1...

    ConcernedMat... | Latest reply: ConcernedMathStudent Oct 3, 2015
    0 replies
  • create Automatic tabs by sales rep Closed

    I have this information on one single tab (50 sales reps) Colum A - Sales Reps Colum B Revenue sold I need to create a single worksheet for each ...

    Cynthia | Latest reply: ac3mark Oct 2, 2015
    1 reply
  • Date formatting Closed

    Hi, When I fetch raw data from a portal, the date comes in this text format Oct-02-2015. I make it in proper format 02-Oct-2015 through delimited a...

    Vikrant Sharma | Latest reply: Mazzaropi Oct 2, 2015
    1 reply
  • If blank cell value of 1 + add 9 cells together Closed

    Hello, I need a formula where if the cell is blank it gets a value of 1, then I need it to add 9 cells together (in the same row). If something (te...

    Teej | Latest reply: Mazzaropi Oct 2, 2015
    1 reply
  • Finding Customers Names Closed

    Hi i am struggling to find my customers names on Excel Spreadsheets i have tried the format box and used the find box i also tried the name box can so...

    Tomousema | Latest reply: RayH Oct 1, 2015
    1 reply
  • greater than and less than Closed

    Hello, i need help. A4 is the input i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any sug...

    slim | Latest reply: RayH Oct 1, 2015
    1 reply
  • Macro for formatting Raw data Closed

    Hello, I need a macro that could format my data . Data in report comes as Col1 Col2 Col3 Col4 Name1 Date proj task hrs .. . . Tota...

    Girish | Latest reply: Girish Oct 1, 2015
    0 replies
  • How To Copy Data Between Several Sheets on VBA Solved/Closed

    Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...

    fcbarros | Latest reply: TrowaD Oct 1, 2015
    7 replies
  • looking up text values in a col. and replace text in another col Closed

    Hello, I am trying to lookup a partial text value in column 1(e.g. lookup all cells with the suffix AAL in cells that have an actual text of say AAL68...

    theorganist | Latest reply: theorganist Oct 1, 2015
    0 replies
  • Comparing two columns with other two columns Closed

    Hello, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20...

    Sana | Latest reply: Sana Oct 1, 2015
    0 replies
  • values from one workbook to another Solved/Closed

    Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...

    charms72 | Latest reply: charms72 Sep 30, 2015
    2 replies
  • I want to add 9 if conditions is it possible Closed

    Hello, I want to add 9 if conditions is it possible in Excel?

    rajkumar | Latest reply: TrowaD Sep 29, 2015
    1 reply
  • Range of cells depending on a condition. Solved/Closed

    Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...

    Milvy | Latest reply: Milvy Sep 29, 2015
    2 replies
  • excel problem Closed

    I have two lists containing FAA pilot certification information. One list is basic information on each person in the database, the second list contai...

    sirsohailhyder | Latest reply: sirsohailhyder Sep 28, 2015
    0 replies
  • Please Solve my promlem if any body can ? Closed

    Hello, if i make 10 invoices for a company on sheet 1 to sheet 10, each invoice has amount about Rs. 10000/- i need a auto covering letter on sheet ...

    Shehzad Naqvi | Latest reply: Mazzaropi Sep 28, 2015
    1 reply
  • excel formula Closed

    Hello, i need the formula on excel sheet for find out percentage if the number is >=3499 than find out 5% and if the number is

    sushil kumar | Latest reply: Mazzaropi Sep 28, 2015
    1 reply
  • match cells in excel with all characters same except one Solved/Closed

    Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...

    Murtuza | Latest reply: ac3mark Sep 27, 2015
    13 replies
  • Please Help Create Sub Sheet w/Master Sheet using VBA/MACRO Closed

    Hi, I have a master spreadsheet that I want to pull certain information from without losing the format and formulas. I need it to link with my mast...

    anniesmash | Latest reply: RayH Sep 27, 2015
    1 reply
  • Comparing orders vs customers to find the ones who didnt order Closed

    Hello, I have a list of 500 customers on one sheet with multiple columns of data for each one, Last name is column O, first is column P. On th...

    Rosario | Latest reply: Rosario Sep 27, 2015
    0 replies
  • Query Closed

    Hello, if cell A2 contain any text then B2 should highlight with color Configuration: Windows 7 / Chrome 45.0.2454.99

    ganesh | Latest reply: ganesh Sep 26, 2015
    0 replies