Excel Forum

Ask a question
Search
Close
Results 4751 - 4800 of about 9,870
  • Excel row removal/selection Closed

    Hello, I am trying to select certain rows from a very large data sheet. Ideally I would like to select every 25th row so as to get a random sample of...

    kateo | Latest reply: amaresh Jun 4, 2011
    5 replies
  • Excel 2007 conditional format question Closed

    Hello, I have an excel 2007 file which I wish to be able to highlight a row if the first two cells in that row equal "Large code model" in the fir...

    gedinfo | Latest reply: rizvisa1 Jun 3, 2011
    1 reply
  • Excel - Macro|group by|based on time interval Closed

    Hello, I need to write a macro for following example (copy and paste to excel with comma separated ',' delimiter). MS start and MS end column have...

    vreexs | Latest reply: vreexs Jun 3, 2011
    2 replies
  • Cut Entire Row To Another Sheet Based on Cell Closed

    Hello Dears, If any one can help me. I have 2 excel sheets, Sheet1 "All Invoices" and sheet2 "PAID Invoices". In sheet1 I have several column...

    issa | Latest reply: rizvisa1 Jun 3, 2011
    3 replies
  • Excel: check text in cell, add values Closed

    Hello, I'm trying to create a formula to check a cell for a certain string of text, and then if it contains it, take the value of a number in that...

    Mikaka | Latest reply: rizvisa1 Jun 3, 2011
    3 replies
  • Comparing & replicating data, 2 Excel sheets Closed

    Hello, all. I have 2 sheets of a spreadsheets I'm looking at in Microsoft Office Excel 2007. On the first sheet: a) I have 300,000 rows of user inf...

    Miguel | Latest reply: rizvisa1 Jun 2, 2011
    1 reply
  • Excel Help Closed

    Hi Everyone. Hope you guys can help. This is what I need I have 3 sheets in excel. Sheet 1 is my master and has products listed according t...

    Norb | Latest reply: rizvisa1 Jun 2, 2011
    3 replies
  • Excel Formula to Create Rows Based on qty Closed

    Hello, I have an Excel 2010 worksheet with the following data Name ID Qty Joe 123 15 Bob 456 8 Ed 234 ...

    ExcelDummy | Latest reply: RWomanizer Jun 2, 2011
    1 reply
  • Excel name match query Solved/Closed

    Hi I have a column (A) in excel that lists all of the staff in an organisation, and in column B is their telephone number. In column C is a list o...

    sarah | Latest reply: Guest user Jun 1, 2011
    5 replies
  • Need Individual Sheet Data to Copy to Main Sh Closed

    Hello, I have a workbook I've created to track sales leads. I have a main sheet called "directory" and individual sheets for each business I conta...

    Peter T | Latest reply: rizvisa1 Jun 1, 2011
    7 replies
  • Recording Macro with IF(OR(AND function Closed

    Hello, I have recorded a macro on Excel with the function IF(OR(AND done but when I try to run the macro file in the test datafile, an error occur...

    Stupidbear | Latest reply: rizvisa1 May 31, 2011
    16 replies
  • Split data into multiple sheets using macro Solved/Closed

    Hello, Configuration: Windows Vista / Firefox 4.0 I have an excel sheet with the data in following manner. a b c d 1 1 1 1 2 2 2 2 3 ...

    Suhas | Latest reply: rizvisa1 May 31, 2011
    16 replies
  • Inserting rows with formulae on existing data Closed

    Hello, I wanted to know if a macro could help me deal with the following: The data is something like this: Column Field1 Field2 Field3...

    Kardar | Latest reply: rizvisa1 May 31, 2011
    3 replies
  • Filter excel data using formula Closed

    Hello, I have some data in excel, where I need to run filter option. But due to some constraints, I cannot use the manual option of filter in exce...

    ankur01 | Latest reply: RWomanizer May 31, 2011
    1 reply
  • Need Excel Macro Closed

    Hello, I am looking for a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to s...

    Priya | Latest reply: rizvisa1 May 30, 2011
    1 reply
  • Excel linked to database Closed

    Hello, i m working on a excel sheet which is linked to database ,which means whenever i refresh it gets updated.i have created a new column in tha...

    swanky | Latest reply: rizvisa1 May 27, 2011
    1 reply
  • Excel Macro Help. Solved/Closed

    Hi, I was wondering if someone could help me develop a macro that would reference a row in another worksheet. So for example if Column H = "x" in ...

    Felicity86 | Latest reply: TrowaD May 27, 2011
    7 replies
  • Excel macro to identify/modify/combine cells Solved/Closed

    Hello, I have a collection of survey results in Excel that are coded from another software that I need to prepare to put in SPSS, the results come...

    Kate | Latest reply: TrowaD May 27, 2011
    3 replies
  • on the excel codes Closed

    Hello, I have copied the code, but from tools i try to run and a msg "type mismatch" pops up..what next?thanks Configuration: Windows XP / Inte...

    toolie | Latest reply: RWomanizer May 27, 2011
    1 reply
  • Excel help required Closed

    Hello, I have data from A1 to A10 I want A1 in sheet2A1 A2 in shett2A2 ........ and so on will u please hel...

    sandesh | Latest reply: RWomanizer May 27, 2011
    1 reply
  • MS Excel 2007 Date format issue... Closed

    Hello, I have an XL spreadsheet with abt 15k rows, with a variety of data, the important ones being the dates - a start date and an end date. Based...

    Sujesh | Latest reply: RWomanizer May 27, 2011
    2 replies
  • Excel search macro Closed

    Hello, I have a very tricky problem. I have got an excel sheet having some columns but more than 5000 rows. In those columns there are some names w...

    Game | Latest reply: Birpal_Buttar May 26, 2011
    4 replies
  • Excel macro for moving content Closed

    Hello, I need a macro that will search for a specific set of values in a specific column for each row of a subset of rows. Example data can be ...

    ExcelHelp3 | Latest reply: rizvisa1 May 26, 2011
    6 replies
  • VBA code for a IF Function Closed

    Hello, I need help on the following: Selecting a range on data e.g A1:A14 Searching for a certain value e.g 3000 if query is true then copy a ...

    PM | Latest reply: Mukesh May 26, 2011
    5 replies
  • Excel Formula Closed

    Hello, I have 1 Workbook with 2 sheets full of data, both sheets have identical data except for 2 Columns, DOB and Last name. I want a Formula on ...

    NeedHelp12 | Latest reply: rizvisa1 May 25, 2011
    1 reply
  • Macro to find Min value Closed

    Hello, I need code for part of my macro that will find the min value in a particular column and based on the min value clear the contents in other ...

    JV | Latest reply: SKhanY May 25, 2011
    12 replies
  • Excel goal seek doesn't go through a macro Closed

    Hello, I'm trying to use the goal seek function of excel to seek out a particular value of a cell (say Y) by changing values of another (say X). ...

    Mrunmoy | Latest reply: rizvisa1 May 24, 2011
    1 reply
  • Trouble recognizing data in excel sheet Closed

    Hi, Dear All, I asked some time back about a question on how to highlight thevalues etc that i entered in an excel file, and Mr. Trowa has...

    Umair | Latest reply: rizvisa1 May 24, 2011
    2 replies
  • code for firm which open excel sheet Closed

    dear sir, I want to create a one firm from where i want to open my existing excel file , how can i do this. Please help me. May I use some code fo...

    jitu | Latest reply: rizvisa1 May 24, 2011
    1 reply
  • Excel Macro help Closed

    Hello, I have an excel spreadsheet table (on one worskheet) that has several date rows in one column C, and one cell J12, for a permit number havi...

    Heather | Latest reply: RWomanizer May 24, 2011
    1 reply
  • Copy rows of data from one sheet to another Closed

    Hello, I have used the below code to copy selected rows ("x") of data from one worksheet ("QBank") to another ("TestSheet") within the same workbo...

    Lil MIS | Latest reply: RWomanizer May 24, 2011
    1 reply
  • VBA Excel Last Used Cell Closed

    Hello, I am trying to copy a range of data I have in several columns in a worksheet into one column (all the columns have the same name: OrderID) ...

    b_85 | Latest reply: RWomanizer May 24, 2011
    1 reply
  • Need Excel Macro Closed

    Hello, I need a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to search cell...

    Priya | Latest reply: Ambucias May 22, 2011
    1 reply
  • hiding a different sheet in workbook Solved/Closed

    Dear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...

    ram | Latest reply: venkat1926 May 21, 2011
    1 reply
  • Report from Excel Data Sheet Solved/Closed

    Dear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...

    ram sharma | Latest reply: ram May 21, 2011
    4 replies
  • I need help with an excel formula Closed

    Hello, I have a spreadsheet that I am trying to find a average of one column with several rows that if another column with several rows contains a...

    mics | Latest reply: venkat1926 May 20, 2011
    1 reply
  • Excel VB Macro Solved/Closed

    Hello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...

    b_85 | Latest reply: b_85 May 20, 2011
    4 replies
  • Excel issue Closed

    Hello, There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c. Table A contains p...

    Riti | Latest reply: RWomanizer May 19, 2011
    2 replies
  • Please resolve my issue ofMS Excel file highl Closed

    Deat Towa, http://www.speedyshare.com/... Please see the below mention link, What i want is, 1. Those bolt which are consumed completely s...

    Umair | Latest reply: venkat1926 May 18, 2011
    1 reply
  • Need Shortcut for full screen in excel Closed

    Hello, Anyone give me the Keyboard shortcut to change excel sheet into full screen mode.

    Mukil | Latest reply: anuj May 18, 2011
    5 replies
  • EXCEL MACROS; Clear, Compare and Replace! Closed

    Hi, I need help creating three Excel macro subroutines.... This is for office 2003! The first one clears cells that do not contain "arg1"...

    OilCan | Latest reply: OilCan May 18, 2011
    9 replies
  • Codes for Reminder creation in Excel VBA Solved/Closed

    Hello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...

    koyel | Latest reply: vivek May 17, 2011
    23 replies
  • Can someone help me write a macro? Closed

    Hello, I have a large database of information (inventory). The datbase is constantly having rows added and deleted. In column (1), there over 100...

    Maria | Latest reply: venkat1926 May 17, 2011
    1 reply
  • delete duplicate items in excel Closed

    Hello, I need to write a macro where it deletes duplicates but the marcos out there seem to delete all duplicates I just want it to delete a cell i...

    bamster | Latest reply: venkat1926 May 17, 2011
    1 reply
  • can not run macro Solved/Closed

    hello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...

    ram sharma | Latest reply: ram sharma May 17, 2011
    1 reply
  • how to create shortcut keys to xl 2007macros Solved/Closed

    Hi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...

    Gowind | Latest reply: RWomanizer May 17, 2011
    3 replies
  • Ignoring rows with zero value Solved/Closed

    Hello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...

    ChrisCoR | Latest reply: RWomanizer May 16, 2011
    3 replies
  • excel delete blanks help Closed

    Hello, I have a macro to delete rows where if the cell in column c is blank as follows: Columns("C:C").Select Selection.SpecialCells(xlC...

    ken | Latest reply: Game Start Now May 16, 2011
    1 reply
  • Highlighting the values entered in an excel Solved/Closed

    Hello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...

    umair | Latest reply: TrowaD May 16, 2011
    3 replies
  • Copying Data To Another Worksheet Solved/Closed

    Hello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...

    azmiismail | Latest reply: TrowaD May 16, 2011
    1 reply