Excel Forum

Ask a question
Search
Close
Results 5151 - 5200 of about 9,840
  • Last ID # Entered Closed

    I have a very long list of ID #'s that all start with the either BIL_ADMIN_ and then the number or with BIL_RECEIPT_ and then the number. Is there a ...

    clg710 | Latest reply: venkat1926 Jan 4, 2014
    1 reply
  • Column totals using macro Closed

    need help , how do I add sum totals at the bottom of columns of varying lengths using macros. eg I have data in columns a to f, I want columns c to f ...

    exhale | Latest reply: exhale Jan 3, 2014
    9 replies
  • A Macros to Pull Data from an automated Excel Sheet Closed

    Hello, I have a running spreadsheet where the data is automatically updated. On a separate sheet I am trying to pull information off the main sprea...

    Mike_Truong | Latest reply: Mike_Truong Jan 3, 2014
    0 replies
  • Help with text & number rule! Solved/Closed

    I wonder if anyone would know how to create the following rule in Excel: IF I enter a specific "text" in cell A, then Excel would insert a correspo...

    Alulus | Latest reply: Alulus Jan 3, 2014
    7 replies
  • Auto populating entire list based on DDL Closed

    Hi everyone! I've stumped myself once again in Excel and am desperate for help. I'm attempting to auto populate an entire list based on a drop dow...

    iwnixon | Latest reply: iwnixon Jan 3, 2014
    0 replies
  • Applying my macro to a range of cells... Solved/Closed

    I found this macro and it works perfectly....inserts an "x" on a single mouse click into cells, but I only want it active on a certain range of cells....

    lorihohen | Latest reply: ac3mark Jan 3, 2014
    5 replies
  • Conditional Fomatting Closed

    I am trying to add conditional formatting to a spreadsheet. It is an employee list showing drivers lic and med cards expiration dates. I want to forma...

    irene wallin | Latest reply: gm2612 Jan 1, 2014
    1 reply
  • Macro for creating text file and copy paste date Closed

    Hello experts, I need an another macro, a keypad shortcut triggered macro (Ctrl+j), which will copy ranges "A10:A45", create a new text file on the...

    gm2612 | Latest reply: gm2612 Jan 1, 2014
    5 replies
  • Help with comparing column data Closed

    Here is my situation, I have a DB with a column of customer #'s that I want to tie to a status column. Each customer # can have anywhere from 1 - 12 ...

    Lost in the ... | Latest reply: ac3mark Dec 31, 2013
    3 replies
  • paste 10 or more worksheets data in a single worksheet Closed

    I want paste 10 or more worksheets data in a single worksheet by using formula, is it possible?? Thanks in advance Mahfuz

    mahfuz19 | Latest reply: mahfuz19 Dec 31, 2013
    2 replies
  • Creating workbook and copying data Closed

    Hello, I have a work book in which the sheet - "Master list". Column D contains the master list of clients. 2nd sheet "Template" contains the maste...

    gm2612 | Latest reply: gm2612 Dec 30, 2013
    0 replies
  • Doubts on Sum Mulitple Sheets Closed

    Hi All, I have different kind of workbooks having records from A6to BB6 in this we can enter the details on daily basis sales . One more Master...

    vimal4184 | Latest reply: vimal4184 Dec 30, 2013
    0 replies
  • How to use formula for transfering data from Sheet 1 to Sheet 2? Closed

    Date & Time JOB NO PENDING 12/23/13 2:14 PM SICD-B00xxx * My question is, there are three cells named- Date & ...

    paulg100 | Latest reply: paulg100 Dec 28, 2013
    0 replies
  • Macro for copying cells with format from last sheet to new sheet Closed

    Hello, My project requires to maintain a database for all customers. I have already obtained an event macro from experts from this forum, which, I...

    gm2612 | Latest reply: venkat1926 Dec 27, 2013
    1 reply
  • Excel formula Closed

    I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If 0...

    apg913 | Latest reply: venkat1926 Dec 27, 2013
    1 reply
  • Macro for creating a new excel sheet based on certain conditions Closed

    Dear Experts, Greetings. My sincere thanks for the support you providing thorugh this forum. Now stuck with some requirements in the microsoft exce...

    gm2612 | Latest reply: gm2612 Dec 25, 2013
    7 replies
  • time calculation formula Closed

    Hello, what is the formula to calculate time between two different dates and times Thanks

    madhusupra | Latest reply: Kevin@Radstock Dec 25, 2013
    1 reply
  • date function Solved/Closed

    i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...

    gayathrialagu | Latest reply: venkat1926 Dec 24, 2013
    1 reply
  • list dependant drop down menu Closed

    Hello everyone, I have a worksheet with two columns (A and B) of data. I'm trying to populate a second worksheet (column A) using a drop down box t...

    wstring | Latest reply: wstring Dec 19, 2013
    0 replies
  • Applying conditional formatting to multiple cells Closed

    Hi all, I've actualy already done what I needed to do, but as this is a very sensitive document I would like to know WHY it worked, just to be sure...

    AndieArbeit | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Formula to highlight cell based on data value over 2 cells Closed

    Hi Guys and Girls, I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location. I want...

    insight1979 | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Conditional formatting to colour cell based on text in another Closed

    Hi, I have a workbook tracking submission of work ideas. In column C I have the date received. In column J I have status (approved, rejected, pendi...

    nicm123 | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Excel Closed

    Hello, Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String ...

    Reddy | Latest reply: TrowaD Dec 19, 2013
    1 reply
  • Conditioning Formatting Closed

    HI All, we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed. we have seve...

    Chamberlyn | Latest reply: ac3mark Dec 19, 2013
    1 reply
  • Formula Closed

    i

    manz26 | Latest reply: manz26 Dec 19, 2013
    0 replies
  • Remove duplicates and merge rows Closed

    A B C D E 2000 Mary 123 street1,street2 2000 James 123 street2 2000 Mary 123 street1 2.8...

    Annie1986 | Latest reply: Annie1986 Dec 19, 2013
    0 replies
  • Date formula Closed

    HI I want to set the formula for excel for when I insert date in cell ex. 1dec2013 then I will select any empty cell date change in to 31dec2013

    @vi | Latest reply: venkat1926 Dec 18, 2013
    1 reply
  • If command across multiple cells Closed

    Hi Guys, I can successfully use if command with text on a single cell, however I want the true or false outcome to be based on multiple cells. T...

    CuriousBaz | Latest reply: venkat1926 Dec 18, 2013
    1 reply
  • Writing a macro that copies data from multiple worksheets to one Closed

    I have a workbook that has over 580 different worksheets, and I need to copy a certain section from each worksheet onto a "master" worksheet. The data...

    Jasonlowery_1 | Latest reply: Jasonlowery_1 Dec 16, 2013
    0 replies
  • Find and Extract text from a cell content Closed

    I need to search a cell for content and extract and display a portion of the cells content. How do I do this? Here are more specifics. lets say...

    rdegrasse | Latest reply: rdegrasse Dec 15, 2013
    2 replies
  • Nested If logic is not working Closed

    Please tell me what's wrong in below formula: =IF((AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Green"))),"Compliant",IF((AND(AND((H...

    raj3076 | Latest reply: raj3076 Dec 15, 2013
    0 replies
  • Date Function using if_ else statement Closed

    My requirement is while writing a function using if statement : In a range of cells in say: P10: P20, containing dates, I want to writ...

    shiny thomas | Latest reply: venkat1926 Dec 15, 2013
    1 reply
  • Require Formula Closed

    I want to type only 1 in excel cell but require to come 100 and the same that 2 for 200, 3 for 300, 10for 1000, 50 for 5000, 100 for 10000 and so on. ...

    desai bandhu | Latest reply: venkat1926 Dec 14, 2013
    1 reply
  • How can I add blank line to the record using macro Closed

    Hi There, I am having difficulties with macro, I would like to have macro which checks the records in each row and if they do not match than it add...

    sylvans | Latest reply: sylvans Dec 13, 2013
    0 replies
  • Returning Text from Excel Closed

    I have customer names located in Column B Rows 12-56; I have dates that they returned letters to me in column J rows 12-56. My question is what is...

    mccormack.1087 | Latest reply: mccormack.1087 Dec 12, 2013
    0 replies
  • how to auto copy/past info from one cell . Closed

    Hi , I am trying to create a sheet that when i press a name it will ask me to where i want to copy it in a different sheet. For example If i pre...

    Avisub | Latest reply: Avisub Dec 12, 2013
    0 replies
  • Transfer data between sheets in excel Closed

    I currently have a sheet that sorts my data by customer, such as Part#, Qty ordered, Qty Shipped, Due date and so on. I would like to be able to trans...

    Rubidoux | Latest reply: Rubidoux Dec 11, 2013
    0 replies
  • Script :Scan Excel Sheet for Validity Date & Send Reminder Mails Closed

    Hello, I have a training manager in Excel that has different training records of about 100 employees. Each training has a certain validity. The re...

    IMR4N | Latest reply: IMR4N Dec 11, 2013
    0 replies
  • Excel IF argument Closed

    Dear All, I'm trying to use IF argument in a excel document for a calculation. But it is not working. I'm using more than 8 IF argument. My excel i...

    arahim01 | Latest reply: ac3mark Dec 10, 2013
    1 reply
  • How to move data to different sheets Closed

    I need to enter data into several different sheets and then would like some of the data to transfer automatic to a log sheet so I can then sort it. C...

    pb1927 | Latest reply: TrowaD Dec 10, 2013
    5 replies
  • moving data from rows into columns for every Solved/Closed

    Hello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...

    Rick | Latest reply: Glitchdata Dec 10, 2013
    20 replies
  • Transfer data from one workbook to another. Closed

    Hello, I am having a problem with the getting the form to transfer data. The post previously placed on this forum is not resolved. Please help me ...

    topinwebhost | Latest reply: topinwebhost Dec 9, 2013
    0 replies
  • Excel VBA Closed

    Hi, I have a VBA data entry user form where in 200 people will be updating it and updating different excel sheets and will be saving it. All the d...

    topinwebhost | Latest reply: topinwebhost Dec 9, 2013
    9 replies
  • copy rows with date as criteria Closed

    Hi i have a workbook with 3 sheets. sheet 2 has data that changes constantly and column A has the date entered when the change was made. sheet 3 ne...

    ANDREAAS | Latest reply: ANDREAAS Dec 8, 2013
    0 replies
  • Macro to sort worksheets by a value in a cell, least to greatest Closed

    I need a macro to sort my worksheets by the value in their cell "J65", least to greatest. The formula in cell "J65" is: =Sum(J35-H62). It is a USD...

    StarScott | Latest reply: StarScott Dec 8, 2013
    0 replies
  • how to check replicated data Closed

    Hello, I have a set of data ranging from column A to AW. They are shown in several sheets and there are 289 items in each sheet. Since the data wa...

    ichliebeprin... | Latest reply: ichliebepringles Dec 7, 2013
    0 replies
  • Change Cell Data by Format Conditioning Closed

    I need to how to used format conditioning to change a cell's data Example If Cell A1 = "F", then A3 background is Green (this is normal Format Con...

    Patrobyn | Latest reply: Patrobyn Dec 7, 2013
    0 replies
  • Combine Multiple Rows into One Row Closed

    Hello, I am in need of major help with a large spreadsheet that have over 500 rows. I need to take multiple rows and combine them into one row. ...

    iietntech | Latest reply: iietntech Dec 6, 2013
    0 replies
  • Comparing columns Closed

    I have a list of 77 names in column B and need to compare them to a list of 156 names in Column C- My objective is to determine if any names in column...

    cl1425 | Latest reply: venkat1926 Dec 6, 2013
    1 reply
  • Excel Macro: combine selected rows Solved/Closed

    Hello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...

    Steve | Latest reply: iietntech Dec 5, 2013
    6 replies