Excel Forum

Ask a question
Results 2251 - 2300 of about 9,840
  • Conditional Formatting Based on Data in another Cell Solved/Closed

    Hello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all...

    anniedavis1980 | Latest reply: ac3mark Jul 21, 2016
    4 replies
  • Excel has file big size Solved/Closed

    Hello, Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of th...

    RossHutton | Latest reply: RossHutton Jul 21, 2016
    4 replies
  • Copy a cell in the same row as a matched cell on a sheet2 Closed

    Hey, Let me try and explain this better. I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the mat...

    Matt | Latest reply: Mazzaropi Jul 21, 2016
    3 replies
  • Move Rows of Spreadsheet to second spreadsheet Closed

    Good Morning- I am keeping a spreadsheet of my projects. I want to keep the information for tracking and statistics later. Is there a way to move...

    Scott Hicks | Latest reply: vcoolio Jul 21, 2016
    1 reply
  • Macro to Copy Cells and Save multiple entries Closed

    Hello, I am looking to create a macro (never done this before). Here is what I want it to do. 1) I have a master store name excel file (for exampl...

    campbell0822 | Latest reply: ac3mark Jul 20, 2016
    3 replies
  • Conditional Formating: formula cell text change color Solved/Closed

    Hello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...

    Marshall | Latest reply: ac3mark Jul 20, 2016
    3 replies
  • Colour in spreadsheets that are formulated Closed

    Hello, I would like to know how to do the following on excel Same sheet with the amount of calls taken in number form goes into a cell then the ...

    Spud | Latest reply: ac3mark Jul 20, 2016
    4 replies
  • How to highlight the extra data in column Closed

    Hello, I want to get the extra data in a column when compared to other column. For Ex: If ColumnA has following data 1 2 2 3 5 & column B...

    Sumit | Latest reply: Sumit Jul 20, 2016
    2 replies
  • Transfer between excel worksheets Closed

    Hello, I would like to be able to transfer an entire row of attendance of students when it hits zero for attendance to another sheet or at the bot...

    Vira | Latest reply: vcoolio Jul 20, 2016
    1 reply
  • Correlation with complex Arrays Closed

    Hello, I understand how to do a basic correlation. But, if I have thousands of student data and want to run correlations of student test scores i...

    Teacher | Latest reply: Teacher Jul 19, 2016
    0 replies
  • Automatically transferring rows of data between sheets Closed

    Hello, I am creating an excel spreadsheet that will be used to keep track of my organization's board member and supporter attendance at events. I ...

    jzendran | Latest reply: vcoolio Jul 18, 2016
    3 replies
  • date format *dd/mm/yyyy and dd/mm/yyyy Closed

    LS, Hello, Please help me with the following question; What is the difference between the format dd/mm/yyyy and *dd/mm/yyyy when uploading dates an...

    HorsemanNL | Latest reply: ac3mark Jul 18, 2016
    1 reply
  • Conditional Formatting when a cell says "NO" Solved/Closed

    Hello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...

    Grace C | Latest reply: Mazzaropi Jul 18, 2016
    3 replies
  • If a cell has a certain value after certain date, color the row Solved/Closed

    Hello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...

    ManxMaggie | Latest reply: ManxMaggie Jul 18, 2016
    4 replies
  • Matching 2 values from one spreadsheet Solved/Closed

    Hello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...

    sargiesan59 | Latest reply: sargiesan59 Jul 16, 2016
    3 replies
  • Copying a range of data between 2 values Closed

    Hello, Please could someone assist. I have a workbook with 97 sheets and I am wanting to create a macro that can copy a certain range of data bet...

    Roxyg | Latest reply: Roxyg Jul 16, 2016
    0 replies
  • Help please need formula Closed

    Hello, I need for anything in column J that says complete to be moved to another sheet. How do I do that ?

    Bee | Latest reply: Bee Jul 15, 2016
    0 replies
  • How to count how many times a number appears in a spreadsheet? Solved/Closed

    Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...

    kimipapineau | Latest reply: kimipapineau Jul 15, 2016
    4 replies
  • Conditional formatting from other spreadsheet Closed

    Hello, Every day I update my excel spreadsheet based on customer demand. My boss uses a separate spreadsheet that pulls from mine. He wants to be ...

    cleggwde | Latest reply: ac3mark Jul 15, 2016
    1 reply
  • excel formula Closed

    I need to generate a number list of 1-20000. is there any method?

    theja123 | Latest reply: theja123 Jul 15, 2016
    0 replies
  • Automatically copy data from one sheet to another Closed

    I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question. I have an excel workboo...

    atera7 | Latest reply: vcoolio Jul 15, 2016
    1 reply
  • Removing false statement Closed

    Hello, I would like to remove a FALSE statement, want it to show nothing. My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23...

    Formula | Latest reply: Mazzaropi Jul 14, 2016
    1 reply
  • send email when a cell changed in excel Closed

    Hello, hi guys, straight off, im stupid, extremely stupid so if you can help me please keep it simple as im barely technical at all :) anyways, im...

    disposablehero | Latest reply: Haval Jul 14, 2016
    4 replies
  • calculate to distance between two addresses on google maps excel Closed

    Hello Friends, please help me if you can. what im trying to do is, i need to calculate the distance between two addresses on google maps and want t...

    lynng | Latest reply: lynng Jul 13, 2016
    0 replies
  • Creating multiple lists from one master data table Closed

    Hello, I am trying to create a master data tab where expenses will get coded. I need each subsequent tab to be for a specific account and that ta...

    KelliG | Latest reply: vcoolio Jul 13, 2016
    2 replies
  • How do I extract specific data from a cell in excel? Closed

    Hello, what function would I use to extract just the city name from the cells below?...thanks! 6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A. ...

    mcat79 | Latest reply: ac3mark Jul 12, 2016
    5 replies
  • Conditional Formatting Based on Data in Another Call Closed

    I'm a new member and I hope my question is clear. I need to change the background field color of cells in a column based on a value in a different fi...

    anniedavis1980 | Latest reply: anniedavis1980 Jul 12, 2016
    0 replies
  • Change color of text or cell if the value entered is same Closed

    Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before. Ex. I wanted the font or...

    Mark | Latest reply: Mazzaropi Jul 12, 2016
    1 reply
  • comparing the two names respective of Upper & Lowercases letters Solved/Closed

    Hello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...

    KICK | Latest reply: ac3mark Jul 11, 2016
    7 replies
  • macro for inserting multiple rows between data Closed

    Hello, I need a macro that will insert 45 new blank rows between each existing row that I have now. can someone help me with this? Also, I have li...

    vba dummy | Latest reply: TrowaD Jul 11, 2016
    1 reply
  • Count if it is monday? Closed

    Hey all; I could not manage to work this out after 1 day research and try my chance here. I have dates on column A and numbers (both positive,negat...

    serdargurlek | Latest reply: tunnde80 Jul 11, 2016
    1 reply
  • Copy data from one sheet to another based on condition using VBA Closed

    The data looks like this A B C D 1 3.45 ...

    tunnde80 | Latest reply: tunnde80 Jul 11, 2016
    0 replies
  • Macro to Merge Data Based on Condition Closed

    Hello Dear, I have multiple sheets with different columns, the headers are mentioned in row 3 and there are few headers which are common across al...

    Chanti | Latest reply: Chanti Jul 11, 2016
    0 replies
  • Transferring data by row onto new tab Unpaid and Paid Sales Closed

    Hi I am new to this forum. I have an excel spreadsheet which looks like this: Date Description Invoice Destination Amount Status ...

    MILIMINX | Latest reply: vcoolio Jul 11, 2016
    1 reply
  • format copy upon condition Closed

    Hello, I have a workbook with two worksheets, one with a legend using 2 columns. Column a for name b for colors. On The first worksheet i am ...

    nonya | Latest reply: nonya Jul 10, 2016
    0 replies
  • add the value of one cell only if another cell has a certain # Closed

    Hi everyone. I'm trying to make a spreadsheet to categorize business expenses into IRS categories. For example Column C has the cost for each ex...

    SilentWhisper | Latest reply: SilentWhisper Jul 10, 2016
    0 replies
  • Totaling amount from 1st tab depending on another column states Closed

    Hello, I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 sta...

    jenny | Latest reply: Mazzaropi Jul 9, 2016
    1 reply
  • How to populate data to another tab Closed

    Hey there, If anyone could please spare a moment to help me with this, it would be much appreciated, more than you will know ! What I want to d...

    gxxrgx_ | Latest reply: RicSan Jul 8, 2016
    4 replies
  • comparing 2 columns from 2 different spreadsheets Solved/Closed

    Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...

    agauth | Latest reply: agauth Jul 8, 2016
    2 replies
  • Copy 10 sheets (along with data) into new 10 sheet in Same excel Closed

    Hello, I have an Excel which contains 10 Sheets with data.., Once a Go button is Clicked it new 10 sheets should be opened in same Workbook along ...

    Aswinraj | Latest reply: TrowaD Jul 7, 2016
    1 reply
  • set a conditional year end date outcomes Closed

    Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/201...

    Kevdfw | Latest reply: Mazzaropi Jul 7, 2016
    1 reply
  • Macro code Closed

    Hi there. So I have a question. I want to create a macro that makes uses the list of name in cells B6:B60, E6:E60, B66:B119, and F6:F74 to make a tab ...

    Shekiah | Latest reply: ac3mark Jul 6, 2016
    1 reply
  • compare two columns input value from another Solved/Closed

    Hello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...

    blmcamp | Latest reply: Maureen Jul 6, 2016
    2 replies
  • Macros - How to populate data to another tab Closed

    Hey there, What I want to do is this: I have data on sheet 1, which is separated into columns, Headings are: Property Code, Customer, Document, ...

    gxxrgx_ | Latest reply: gxxrgx_ Jul 6, 2016
    0 replies
  • If Then for date outcomes Closed

    Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31...

    KevDFW | Latest reply: KevDFW Jul 5, 2016
    0 replies
  • Macro for automatic paste in sequence Closed

    Hello, I have a calculation sheet for experiment results with time. Everytime I am manually copy paste results from result raw to another raw i...

    Jayen | Latest reply: Jayen Jul 5, 2016
    0 replies
  • Automate copying data from one sheet to another Closed

    Hello, Could you help me with the below issue please? I have 2 different sheets in 2 different locations (say one is the Master sheet). I need ...

    Jithin | Latest reply: Jithin Jul 5, 2016
    0 replies
  • Highlight cell if another cell contains any text Solved/Closed

    Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...

    LvH | Latest reply: LvH Jul 4, 2016
    4 replies
  • Senior accountant A/R Closed

    Hello, i cannot transfer data more than 54 column to another sheet(can not write more than 54 cell same row in the code) Configuration: Windows...

    Mohamed | Latest reply: Mohamed Jul 3, 2016
    0 replies
  • So close! Script creates worksheet and populates BUT Closed

    Over the last 10 hours I have researched and pondered and really enjoyed the process of building up this program, but my shift is almost over and I wo...

    MitchLPN | Latest reply: MitchLPN Jul 1, 2016
    0 replies