Excel Forum

Ask a question
Search
Close
Results 5601 - 5650 of about 9,870
  • Enter data in a Workbook worksheet and Save it in a other Worksh Closed

    Hi, I Created a excel file requisition and user input details requesting materials I need to have this data go to a other sheet with two section ...

    jlockem | Latest reply: TrowaD Jun 13, 2013
    1 reply
  • Is there a way to make a default option for Autofilter? Closed

    Hello, I have an excel sheet that I am trying to display 3 different tables on, but I want to make it so that I can filter the tables down to just ...

    indydude71 | Latest reply: TrowaD Jun 13, 2013
    3 replies
  • Macro to add # of rows based on data in the sheet Closed

    I am trying to make a guest list that will insert rows automatically and fill in some data. I can get the primary data from one worksheet (i.e. com...

    ardale | Latest reply: TrowaD Jun 13, 2013
    4 replies
  • EXCEL - Create a bulleted list in a single cell from a list Solved/Closed

    Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...

    morocog | Latest reply: TrowaD Jun 13, 2013
    3 replies
  • Excel Spreadsheet date comparison Closed

    Hello, I am trying to compare 2 columns of data to determine if one date is prior to or after another date. (Is date in column A on, before, or aft...

    JohnnyB3 | Latest reply: aquarelle Jun 12, 2013
    1 reply
  • return selected characters in an excel cell Closed

    I have a alphanumerical number like the following: C297320 I need to return the last 3 digits of this number in a separate cell. Thus, I need...

    luiyoo | Latest reply: aquarelle Jun 12, 2013
    1 reply
  • Have macro select range but exclude empty columns Closed

    Hello, I have a worksheet in which a range gets copied and pasted into an email using a RangeToHTML function from Ron de Bruin's website: https:...

    Pluggie | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • vba insert new cell to a dynamic range Closed

    Hello, Hi, Could anyone plz help me to achieve what I need ? I want a code to insert and autofill a new cell to the range depending on what ...

    tornado1981 | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • Excel solution Closed

    I have one Master Sheet, sheet1 in excel 2007 where I have entries of customer details from mixed cities Code ContactPerson Company Add1 ...

    eexpert | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • Insert Rows according cells value in excel table Closed

    Dear All, I need a Module that allowed me when I run it to add Rows down according upper cells Value for Example; Total Names 2 Sami 5 Rami ...

    loftier | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • If there is value in one column then a $ generates in another Closed

    Hi there, I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. W...

    KiwiJess | Latest reply: TrowaD Jun 10, 2013
    1 reply
  • Number to Words Closed

    Dear Kioskes, Ex: 45,450.55, Forty five thousand four hundred and fifty & 55/100 only could please replay me

    syed abdulra... | Latest reply: TrowaD Jun 10, 2013
    5 replies
  • Adding 1 to an existing number if criteria is matched? Solved/Closed

    In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...

    rshelton22 | Latest reply: ac3mark Jun 8, 2013
    5 replies
  • Find the sum of data that has multiple conditions in Excel Solved/Closed

    Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...

    acohen12 | Latest reply: Kevin@Radstock Jun 7, 2013
    1 reply
  • Formula Closed

    Hi, I need to create a formula for a whole team. It is based on the number of people in the office for each calendar month. The spreadsheet I have ...

    Jenna3009 | Latest reply: TrowaD Jun 6, 2013
    2 replies
  • pdf to excel convertor Closed

    Dear Sir, I want to install pdf to excel convertor to my PC! Help me pls!

    Kyawt.tzs | Latest reply: ac3mark Jun 6, 2013
    1 reply
  • Formula for change of dates daily for one month of working days Closed

    Hello. I am looking for a formula to add one day to a column of working days in a month. I wish to start the first cell in the column to 1/07/2013 an...

    thirsty | Latest reply: ac3mark Jun 6, 2013
    9 replies
  • VB Column Width and Sheet Name Closed

    Hi, I am really new to VB, but I work a ton with Excel. I have a spreadsheet that I have to parse out into multiple spreadsheets for some reporting p...

    hsolo30k | Latest reply: hsolo30k Jun 5, 2013
    2 replies
  • Excel 2010; Need help w/If, Then formula Closed

    I need a formula that if there are duplicate values in column A, then it will sum the values in column D for the rows with duplicate values in column ...

    tmsblevis | Latest reply: ac3mark Jun 5, 2013
    1 reply
  • Autofilter range by selecting cell from a column in that range Closed

    Hello, I have a 6 column overview with Description rule sets for Titles and Subtitles of Product groups. Each set consists of two rows: The desc...

    Pluggie | Latest reply: Pluggie Jun 5, 2013
    0 replies
  • Transfering data from one sheet to another, but not duplicating. Closed

    Good day all. Checking to see if anyone could help out, as iam very new to the excel world. I have a sheet that I am transferring data to another s...

    RR2105 | Latest reply: TrowaD Jun 4, 2013
    3 replies
  • Macros for formatting a data dump Closed

    Hi All, I am new to macros and was looking if some 1 could help in coding a macros for formatting of the data. Below are the issues/Steps 1. Th...

    mch24 | Latest reply: TrowaD Jun 3, 2013
    3 replies
  • Excel: Unique count of values in one column conditional 2nd colu Closed

    Hello, Column A Column B: WEST-WARD,INC. 00015 WEST-WARD,INC. 00015 HOSPIRA 00016 ROXANE LABS. 00017 GLOBAL P...

    Piggy70 | Latest reply: rizvisa1 Jun 1, 2013
    1 reply
  • Conditional Formatting in Excel Closed

    I have built a GANTT chart using Excel, and have been able to create the formulae in the task bar cells that allows the proper display of those bars i...

    austin5283 | Latest reply: rizvisa1 Jun 1, 2013
    1 reply
  • Error when creating mailmessage Solved/Closed

    Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...

    Pluggie | Latest reply: rizvisa1 Jun 1, 2013
    1 reply
  • Calculating days between clinic visits Closed

    Hello, I have a database with two columns, column A is date of clinic visit, and column B is patient name. I would like to be able to calculate th...

    eyedoc2020 | Latest reply: rizvisa1 Jun 1, 2013
    1 reply
  • Copy data to another workbook and auto fill Closed

    Hello, First, I Have excel data base that he have information in 3 Column A(id numbers),B(First Name),C(last Name). I have another Excel workbook ...

    kobi077 | Latest reply: rizvisa1 Jun 1, 2013
    1 reply
  • From Excel, Open a word document and goto a page question Solved/Closed

    Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...

    Anonymous User | Latest reply: rizvisa1 Jun 1, 2013
    9 replies
  • Getting a Cell to Flash When it's Below a Value Closed

    Hi I am trying to make cell B3 flash when the value in it drops below 500 and stop when it goes above it. I have this macro running but it does not...

    Anonymous User | Latest reply: Anonymous User May 30, 2013
    0 replies
  • Create macro to search for a cell value Closed

    I have 2 separate excel (2010) workbooks I'm working with and I would like to create a macro that, when run, will copy a variable value that is in cel...

    jesanicholls | Latest reply: TrowaD May 30, 2013
    1 reply
  • Making a counter in Excel.. Closed

    To Whom this may concern, I have been trying to make a counter on excel. I have been reading some of your posts but they talk about counter with a...

    ballred | Latest reply: TrowaD May 30, 2013
    1 reply
  • MAX value in one coulmn based upon another column Solved/Closed

    Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...

    Piggy70 | Latest reply: Piggy70 May 30, 2013
    2 replies
  • how to extract particular data's from sheet 1 into sheet 2 Closed

    Hello I have three different columns in Sheet 1 with names Number, Step Description and Results. Each column have data's up to 100 rows. I want to ...

    sathi2090 | Latest reply: TrowaD May 28, 2013
    1 reply
  • Transferring data from a column into several rows Closed

    I have data in a column on one sheet that needs to go into several rows in another sheet. Example: Column A has the following data (A1:A200): 1 2...

    LJ30 | Latest reply: TrowaD May 28, 2013
    1 reply
  • how to remove 0s from excel pivot (2010) Closed

    Hello, Do you know guys how it is possible to remove zeroes from an excel pivot when the field is not in the report filter but in row label. I have...

    DG83 | Latest reply: TrowaD May 28, 2013
    2 replies
  • Highlighti Row/ colour fill through VB Solved/Closed

    Hello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...

    DevRatan | Latest reply: TrowaD May 28, 2013
    3 replies
  • How to do in excel Closed

    Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subscrip...

    ugn10 | Latest reply: TrowaD May 27, 2013
    2 replies
  • VBA - How to open a pop-up that does not stop the macro? Closed

    Hi everyone, I would like to add a pop-up (like MsgBox) but I don't want the macro to wait for the user to click on any button. This mean a MsgBox sa...

    Maxine S | Latest reply: TrowaD May 27, 2013
    1 reply
  • Number of decimals in a conditional format Closed

    Dear reader, I need to highlight a cell that contains more than 2 decimals. ex. 2,89 is good and should not be highlighted 2,899 is wrong a...

    boon1d | Latest reply: TrowaD May 27, 2013
    1 reply
  • Comparing Data in Excel Solved/Closed

    Hello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...

    sointly | Latest reply: TrowaD May 27, 2013
    1 reply
  • multiple functions in single cell Closed

    Hello, I want to put following 2 functions in single cell ROUND((C365*0.9144),2) CEILING((D365),0.05) Pls advise

    sudarshandalvi | Latest reply: TrowaD May 27, 2013
    1 reply
  • Conditional Formatting Excel 2010 based on content in other cell Closed

    Hello, I have a conditional formatting issue - and I think maybe the cause is that outcome is already a formula? In cell U5 I have the following...

    Pille | Latest reply: TrowaD May 27, 2013
    1 reply
  • Re: Make a macro run when data entered in a cell -multiple event Solved/Closed

    Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...

    tosinsog | Latest reply: TrowaD May 27, 2013
    1 reply
  • compare columns match and insert data from another column Closed

    Hello, have a sheet with following info A B C D E F G H I J date-sum-item percentage- date sum item now i need to match the date su...

    Mfrendo | Latest reply: TrowaD May 27, 2013
    16 replies
  • Daily attendance sheet that calculates monthly percentage Closed

    I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance ...

    jazzygirl77 | Latest reply: TrowaD May 27, 2013
    1 reply
  • conditional format Solved/Closed

    Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...

    boon1d | Latest reply: boon1d May 27, 2013
    2 replies
  • Comparing Data Closed

    I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered into any ce...

    sointly | Latest reply: sointly May 26, 2013
    0 replies
  • excel Closed

    Within an entire excel sheet, I would like the entire row to turn into red font when I type the number 10 into any cell in column H. For example, ...

    Vikmanu | Latest reply: Vikmanu May 23, 2013
    0 replies
  • How to print data in multiple excel sheets Closed

    Dear All, I am new to excel coding. I need help regarding the below issue The below sub routine is the first sub routine. It gets the details fr...

    narayanpvg | Latest reply: narayanpvg May 22, 2013
    0 replies
  • Copying Excel Formula in different ranges Closed

    I want to copy a formula using different data ranges. The formula can't take dynamic range once copied. Example I want to use sumif formula from...

    Khurrum Iqbal | Latest reply: TrowaD May 21, 2013
    1 reply