Excel Forum

Ask a question
Results 6251 - 6300 of about 9,840
  • macro for deleting row with condition Closed

    Hello, suppose I have one column in which there are 24 rows i.e. A1:A24 and these rows contain some value I need to make one macro in which I ...

    deepak | Latest reply: Maoharan Meghala Jan 29, 2012
    8 replies
  • Delete rows that don't match another data set Closed

    Hello, Excel 2010. I have essentially two data sets. One is a dump from an analytics tool that contains about 8,500 rows of data with about 3 c...

    HiDrewsah | Latest reply: venkat1926 Jan 28, 2012
    1 reply
  • Excel Solved/Closed

    Hello, My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i wan...

    amit | Latest reply: RayH Jan 26, 2012
    1 reply
  • VBA Code to copy row based on dates Closed

    Hello, I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In...

    bbourque96 | Latest reply: pcsces Jan 24, 2012
    1 reply
  • VBA code in excel Solved/Closed

    Dears who can help me to write VBA code to solve the following case: I have Excel sheet to calculate overtime, includes several rows for each month...

    issa | Latest reply: issa Jan 24, 2012
    2 replies
  • Compare 7 colums of data in 17 worksheets Closed

    Hello, I am a complete beginner with Excel, so please excuse me if this makes no sense !! I have made a spreadsheet for driving hours which add...

    noggsy | Latest reply: noggsy Jan 23, 2012
    2 replies
  • Excel 2003 Color Drop Down Menu limit of 3? Closed

    Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatting"...

    Lone_Star_38 | Latest reply: Lone_Star_38 Jan 23, 2012
    2 replies
  • MACROS Closed

    Hello, I want to create a VBA code which if can fiend in column "B" the value ICA to copy the row in another worksheet. EX A B C D 1 ICA 2...

    Iulia | Latest reply: Jackie Jan 22, 2012
    1 reply
  • Macro or VB in Excel 2007 Solved/Closed

    Hi. I have next to no experience with macros & VB. But I have a problem that I need resolved. I have 11 sheets in excel. 10 sheets need to pull in...

    Jlee1978 | Latest reply: pcsces Jan 22, 2012
    2 replies
  • To get cell contents into Excel file property Solved/Closed

    Hello, Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very ...

    jansch | Latest reply: venkat1926 Jan 21, 2012
    1 reply
  • Copying certain cells from one column Closed

    Hello, I want to copy certain cells depending on their value contents from a column into another column but follow their order. If some cells ar...

    Emma | Latest reply: venkat1926 Jan 21, 2012
    1 reply
  • Excel Macro to insert row based on data Solved/Closed

    Hello, I have a large spreadsheet w/ over 9,000 rows of data. I would like to know if a macro can be built to add a row(s) based on the month. In t...

    Asa | Latest reply: Asa Jan 19, 2012
    4 replies
  • Excel 2010 Using Absoloute reference Closed

    Hello, Hello, I would really appreciate if you could help me out, I'm trying to copy a forumula using the $ absolute referencing. My column is...

    Mary | Latest reply: TrowaD Jan 19, 2012
    1 reply
  • Excel 2003 color drop down menu limit of 3? Closed

    Hello, I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatt...

    Lone_Star_38 | Latest reply: pcsces Jan 18, 2012
    1 reply
  • Using Excel Closed

    Hello, I'm trying to find the necessary formula or formulas that will let me enter a single or double digit number into one cell, example C3, tha...

    Charles | Latest reply: TrowaD Jan 17, 2012
    1 reply
  • match different columns and return a value Closed

    Hello, Hi Guys, I have a list which looks like this A B C 2 0 3 3 4 4 67 67 89 14 8 8 What i want to do here is match the tw...

    varun | Latest reply: pcsces Jan 16, 2012
    1 reply
  • Copy cell contents from worksheet function Closed

    Hello, I have a question re: Microsoft Excel 2007 :- I have a worksheet of raw data named 'raw'. I also have another worksheet named 'graphs...

    LlionRoberts | Latest reply: venkat1926 Jan 16, 2012
    1 reply
  • Sharing info between worksheets based on term Closed

    Hello, Configuration: Windows Vista / Firefox 8.0.1 I have a master pipeline and in the Status column there will be terms such as "closed",...

    Tally38 | Latest reply: pcsces Jan 15, 2012
    1 reply
  • Excel - How do I compare 2 columns 4 differnc Closed

    Hello, I'm trying to figure out how to compare two columns (i.e. reports) in Excel 2007/2010, where one is a comprehensive report listing every em...

    Mel | Latest reply: pcsces Jan 15, 2012
    1 reply
  • querey-ms excel2010 Closed

    Hello, HI I have a work book which has few spreadsheets 1 spreadsheet name FC SECOND sheet name SV81 , third sheet name SV83 ,fourth sheet n...

    sri | Latest reply: pcsces Jan 15, 2012
    1 reply
  • Combining three different macros Closed

    Sir, I am a beginner in writing codes(macro's). With great difficulty i have written three different macro's to copy data from main sheet to thre...

    kishore | Latest reply: venkat1926 Jan 15, 2012
    14 replies
  • Copy info from several cells into one cell Solved/Closed

    Hello, Could you please help me solve my issue bellow? I have several sheets in Excel, i.e. Sheet 1, Sheet 2 and Sheet 3. I wanted that A1 cell from...

    ShkeT | Latest reply: ShkeT Jan 14, 2012
    4 replies
  • Excel Data - Matching and Sorting Closed

    Hello, I have 2 spreadsheets, Spreadsheet 1 with names and contact information, and SS 2 with contact information and an ID number. Names are in C...

    redhead | Latest reply: venkat1926 Jan 13, 2012
    1 reply
  • Comparing columns and returning value Closed

    Hello, I have an spreadsheet where I want to compare values between two columns and return the value from the relating row in a third column. If A...

    Gunhild | Latest reply: venkat1926 Jan 12, 2012
    1 reply
  • Macro to find and copy cells Closed

    Hello, I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells ...

    AB | Latest reply: venkat1926 Jan 11, 2012
    1 reply
  • excel 2010 absolute reference Closed

    Hello, Hi, I'm trying to copy a forumula using the $ absolute referencing. My column is as follows: Jan =$c46 Feb =$D46 Mar =$E46 etc ...

    Mary | Latest reply: Mary Jan 11, 2012
    0 replies
  • Copy a row to another sheet with conditions Closed

    Hello, I am very new with coding in excel. I have a sheet called AFF with rows containing different information. If a cell in column Q is not e...

    Danielnowizard | Latest reply: Danielnowizard Jan 11, 2012
    1 reply
  • Excel macro selecting column Closed

    Hello, I need to select a specific column relative to the active cell in a macro. Specifically, regardless of the Active cell on a given row, I want...

    excel challe... | Latest reply: Carla Jan 10, 2012
    2 replies
  • one column multiple rows (data in sets) Closed

    Hello, I'd be grateful for any suggestions... So what I have is gene A 1 2 3 4 gene B 1 2 3 4 and what I would like is gene...

    Olivia Alder | Latest reply: lkc Jan 9, 2012
    4 replies
  • Macro Help In Excel COPY PASTING Closed

    Hello, I am trying to copy data from a excell spread sheet that is actually a set template i.e. Name:John Doe Age...

    theloniousmonk | Latest reply: Erwin VDB Jan 9, 2012
    5 replies
  • vba - compare two sheets Closed

    Hello everybody, I have two sheets: - sheet1 holding 3000 entries of all the guys - sheet2 holding the transferred guys i need a macro that...

    supereliseo | Latest reply: supereliseo Jan 8, 2012
    4 replies
  • Excel Data Reading from another Excel Shheet Solved/Closed

    Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are maintai...

    Mohinder | Latest reply: ger Jan 6, 2012
    15 replies
  • using functions in excel, match, vlockup Closed

    Hello, I have two columns with numbers and i need to find the numbers in 1st column that apear in 2nd and vice versa. But my problem is next: when...

    viki | Latest reply: viki Jan 6, 2012
    7 replies
  • "">[no.]=true & ""<[no.]=false in excel ???? Closed

    Hello, as the title says why excel treats same kind of formula in 2 different ways??? thanx

    mizan | Latest reply: mizan Jan 5, 2012
    2 replies
  • percentage formula for microsoft excel Closed

    Hello, Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ...

    Dougie | Latest reply: KEGS Jan 5, 2012
    6 replies
  • Identifiying data that does not match inExcel Closed

    HI There, I have two columns in excel, I would like to verify that the information in Column A, is the same as in Column B, and if not I would lik to...

    DannyB | Latest reply: pcsces Jan 5, 2012
    1 reply
  • Format Cells based on a letter in other cells Closed

    Hello, Sorry I'm new at Excel, but here is what I'm trying to do: I'm making a work schedule. 3C through 3AG represent the days of the week. ...

    Jeremy | Latest reply: Jeremy Jan 3, 2012
    0 replies
  • lookup problem from excel 2007 Closed

    Hello, Just want to seek for assistance about my problem for lookup data.Actually i have data as per below. PO Items Qty 0001 a 2 0001 b 10 ...

    marvs | Latest reply: pcsces Jan 3, 2012
    1 reply
  • Excel data Extraction issue Closed

    Hello, I have the following issue with data extraction with Excel. I have a list of data (barcodes) dynamically populated - which means that ever...

    milva | Latest reply: rizvisa1 Jan 2, 2012
    3 replies
  • how to compare several columns...? Solved/Closed

    Hello, could anyone help me with this. I would like to compare two columns: A B C D Peter 4 John 3 John 3 Peter 5 G...

    György | Latest reply: DG83 Jan 2, 2012
    4 replies
  • Using Macro for conditional formatting Closed

    Hello, Im in desperate need of help!!! I have an excel sheet with a list of employee number,rank,primary schedule, and secondary sched, years of e...

    RA | Latest reply: venkat1926 Jan 2, 2012
    1 reply
  • How to extract info from csv files to excel Solved/Closed

    Hello, I have 74,340 .csv files I need to extract information from Col. A-C & Rows 1-143 into an excel workbook, Sheet1. Every .csv file has diffe...

    weenie | Latest reply: weenie Jan 1, 2012
    5 replies
  • EXCEL VBA macro Closed

    The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g Uncleansed = OFFSET...

    Sam | Latest reply: Sam Dec 30, 2011
    3 replies
  • Reg: Excel query Closed

    Respected Sir/Madam, This is regarding a query that i have in MsEXCEL. I would like to know is there any formula or script so that i can get the...

    jith | Latest reply: RayH Dec 30, 2011
    1 reply
  • Transfer data to match on Excel Closed

    I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit sco...

    Dan | Latest reply: Dan Dec 29, 2011
    2 replies
  • Paste to all sheets except some with criteria Solved/Closed

    Hi, How can I make a macro paste copied data into some sheets of a worksheet but not other sheets. For example, I have 10 sheets in my worksheet ...

    nzstorm | Latest reply: nzstorm Dec 28, 2011
    2 replies
  • Formating a column using macro Solved/Closed

    Sir A forum member helped me in writing a macro to copy certain data from sheet one to sheet two. I modified basic macro to suit as per my require...

    Kishore | Latest reply: Kishore Dec 27, 2011
    2 replies
  • Excel VBA User Form Closed

    Hello, I am quite new to Excel VBA and I , desperately, need an expert help. am trying to create a user form that generates customer IDs made of 9 ...

    oggow | Latest reply: rizvisa1 Dec 27, 2011
    1 reply
  • Call an excel document to another sheet Closed

    Hello, Can any one suggest how to call a separate document(or) a Cell from one excel sheet to another excel sheet. For Example Book 1 got he...

    TKM | Latest reply: rizvisa1 Dec 27, 2011
    1 reply
  • Automatically copy from one page to excel Closed

    Hello, I want to copy information from one sheet to another regarding the categories. For example if I have airline company name, aircraft type, ...

    minne | Latest reply: venkat1926 Dec 26, 2011
    1 reply