Excel Forum

Ask a question
Search
Close
Results 7401 - 7450 of about 9,830
  • Compare columns Closed

    Hello, I have two columns of IDs. Column A is the bigger of the two. Column B has IDs that are part of Column A. How to produce all IDs that are n...

    divya | Latest reply: rizvisa1 Jun 22, 2010
    3 replies
  • EXCEL-MACRO link between 2 documents Closed

    Hello, I am working on a table(in document A) which needs to be referred to another document(document B, not sheet 2 of document A). I used macro to...

    abcde | Latest reply: venkat1926 Jun 22, 2010
    1 reply
  • Macro help Closed

    Hello, I'm very, very new to vba. I have 2 worksheets. Sheet one has a long list of invoices and details. In sheet two I would like to have a user i...

    Annie | Latest reply: venkat1926 Jun 22, 2010
    1 reply
  • 2 spred sheet- 1 pivot table Closed

    Hello, I have 2 sheets in a file and both have some similar data in columns and some colums are diferent in both sheets , now i want to manage bot...

    gaurang | Latest reply: venkat1926 Jun 22, 2010
    1 reply
  • Assign Value to Variable (Excel VBA) Closed

    Hi I have a variable name CountNumber. I want it to have a value from the formula "count from A2:A500 range. How can I write the code in VBA with...

    tor | Latest reply: Kranthi Jun 22, 2010
    2 replies
  • Excel 2000 Question Closed

    Hi there, hope i can get some help with this. i have office 2007 at home and have created a sheet,....but my excel 2000 at work wont let the cond...

    dbstan | Latest reply: rizvisa1 Jun 21, 2010
    1 reply
  • Disable buttons in Macro Closed

    Hello, I want to know how to disable the buttons or grey them out in the macro window, when we click on Tools > Macro > macros > we get the window...

    Ron | Latest reply: rizvisa1 Jun 21, 2010
    3 replies
  • Open specific xl spreadsheet Closed

    Hello, Plse help! I save info from one spreadsheet to another.When i press the save button and the info goto sheet 2 and the word "filter" appear in ...

    Gouws | Latest reply: rizvisa1 Jun 21, 2010
    1 reply
  • excel formula help Closed

    Hello, Dear Sir I am beginner in excel i have a question i want in a cell if i type a number in a cell and press enter the cell should contain "hel...

    Ahmed | Latest reply: rizvisa1 Jun 20, 2010
    1 reply
  • load sheet with drop down menu Solved/Closed

    Hello I have the userform1, and a combo box linked to two cells callled "UNIVERSAL BOL" AND "BLANK BOL", plus two sheets called "BOL" and "BLANK BO...

    Alexandra | Latest reply: Alexandra Jun 20, 2010
    4 replies
  • Need vbcode to compare excel sheet and access Closed

    Hello, I have one excel sheet, data of material receipts which is maintained by warehouse, ID is purchase order Number which is unique, and another...

    mohan | Latest reply: rizvisa1 Jun 20, 2010
    1 reply
  • Excel extraction Closed

    Hello, I have two excel sheets. Sheet A with all the IDs and sheet B with volumes of IDs and corresponding datas about them. The ID values in sh...

    Pras | Latest reply: rizvisa1 Jun 18, 2010
    1 reply
  • Compare names for match in 2 columns Closed

    Hello, I am trying to pull/filter a subset of names (formatted "First Last") where a matching name is found in a second column. I have tried using...

    empeyo | Latest reply: kk Jun 18, 2010
    2 replies
  • Deleting empty rows in excel Closed

    Hello, I have a worksheet which will have certain status like incomplete, rejected or approved in the Column C. If the status is rejected or inc...

    Aks | Latest reply: rizvisa1 Jun 18, 2010
    1 reply
  • macro to vlookup Closed

    Hello, I have an excel with 9 worksheets i wanted to vlookup in all the sheets from the 9th sheet if found any new cell it should add automaticall...

    syed | Latest reply: rizvisa1 Jun 18, 2010
    1 reply
  • excel code Closed

    would like to ask on how to do in excel this matter: i have three excel file named AA, BB, CC from AA i will remove the name in A1 cell and plac...

    ajcusco | Latest reply: rizvisa1 Jun 18, 2010
    1 reply
  • excel formula Closed

    Hello, i have one excel sheet which is having two columns, but in third columns i want to show the missing no. how, pl send mi the tips or any formu...

    rajesh | Latest reply: rizvisa1 Jun 18, 2010
    1 reply
  • Multiple columns into rows Closed

    Hello, Can someone please give me some guidance on how I can do this? Let say I have: Sheet1 : usergroup a user xx1 xx2 xx3 xx4 x...

    ybtronic | Latest reply: rizvisa1 Jun 17, 2010
    1 reply
  • Excel Move Cells to Right. Solved/Closed

    Hello, I have a task to move several cells in a few column to the far right column (like below) Number of column can be up to 25. ...

    j3kj3k | Latest reply: j3kj3k Jun 17, 2010
    4 replies
  • community help with excel Closed

    Hello, I want a formula to select a certain sel if today's date falls between a date range. For example: today's dat is 16/6/2010 and if falls bet...

    mulchara | Latest reply: rizvisa1 Jun 17, 2010
    1 reply
  • Protecting column in worksheet Solved/Closed

    How to protect only one particular column in worksheet?

    Nav | Latest reply: Saky Jun 17, 2010
    4 replies
  • EXCEL 2007 FIND MAX VALUE Solved/Closed

    Hello, date time value 05/11/2008 205 102 FALSE 05/11/2008 205 110 TRUE 05/11/2008 205 108 FALSE 05/11/2008 240 123 TRUE 05/11/2008 240 104 FA...

    bigband | Latest reply: rizvisa1 Jun 17, 2010
    9 replies
  • post a data to an other sheet. Closed

    Hello, i have a date that contain 8 column and 26 rows, i want to post this data to an other excel sheet through a botten Configuration: Windo...

    sohail | Latest reply: venkat1926 Jun 17, 2010
    1 reply
  • Copy and paste macro into the next open cell Closed

    Hello, I have an Excel spreadsheet that I need a Macro for. The workbook contains 6 worksheets (5 data entry sheets and 1 overview sheet). I nee...

    tpnass1 | Latest reply: rizvisa1 Jun 16, 2010
    20 replies
  • Required help for writing a excel macro Closed

    Hi all, I am new in excel macro programming. I need a macro for update the pending works lists as describes below. ####### Master Sheet(Work...

    ALAM | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • excel definitions Closed

    Hello, what is in the botton right hand corner of an active cell? Configuration: Windows XP / Internet Explorer 8.0

    rilo | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • need explaination how macro works thanks! Closed

    Hello, Dim lAtRow As Long Dim lThisRow As Long Dim Cell As Object dim something as integer etc Dim lAtRow As Long Dim lThisRow As Long ...

    Chris | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • Excel Activex Textbox1 question. please help! Closed

    Hello, I have a text box on which i write a word, whenever i enter a work in text box and hit enter I want it to trigger the macro that i have....

    Chris | Latest reply: rizvisa1 Jun 16, 2010
    2 replies
  • Excel Formula Closed

    Hello, I am working on a spreadsheet and dealing with cells that don't just have the date in them they also have other information in the same cell....

    Katie | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • how to remove seekbrowser from mozilla fire Closed

    Hello, how to remove seekbrowser from mozilla fire thankyou

    jr. | Latest reply: anon Jun 16, 2010
    3 replies
  • I want the enter key to triger macro,pls help Closed

    Hello, I want the enter button in my keyboard to triger macro in my excel file when i write any work in the text box field and hit enter it that...

    Chris | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • Excel Macro to sort columns of diff category Closed

    I have a spreadsheet that i'm supposed to "automate" because the source keeps changing I'm not sure how to so.. I'm here.. I need to figure out a way ...

    sporty9x | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • Excel Macro to insert a new row Solved/Closed

    Hello, I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for th...

    Joper | Latest reply: rizvisa1 Jun 16, 2010
    4 replies
  • Excel Macro Closed

    Hello, I have 24 cells(12 historical data and 12 forecast data) row-wise and they are not in continuous order. I need a macro code that would make...

    ab | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • adding files or rows of my selection excel Closed

    Hello, The book must be able to, select automatically files or rows according to a title somewhere in the sheet. For example A ...

    Alexandro | Latest reply: rizvisa1 Jun 16, 2010
    1 reply
  • Sum of numbers using macro Closed

    Hello, Please help me write a macro to sum the numbers in a column . Thanks ,

    Lavanya | Latest reply: rizvisa1 Jun 16, 2010
    4 replies
  • Macro to Insert a row below Closed

    Hello, I want to insert a whole row below each found "input" in a coulumn. ie. A Time Elapsed 0:05 0:05 0:10 0:05 ... and ...

    Andie | Latest reply: rizvisa1 Jun 15, 2010
    1 reply
  • Help with If VBA Statement Solved/Closed

    Hello, I have this code that i can not get to work all the way i get the error of "Too many local, nonstatic variables" i am new to this and all i...

    Boysenb | Latest reply: Boysenb Jun 15, 2010
    2 replies
  • Macro for Select next line Closed

    Hello, I need help, i have macro in that file Column A already i have 10 lines of data. again i have to include few data for that how can i fine n...

    Sugu | Latest reply: rizvisa1 Jun 15, 2010
    1 reply
  • Excel function or macros Solved/Closed

    Hello, I have a table in which every number from 1 to 52 expresses a specified text For example 1 = Sofia 2 = London ... I n...

    Philip | Latest reply: Philip Jun 15, 2010
    2 replies
  • Browsers not working Closed

    Hello, here is my hijackthis log, I am currently in safe mode. Please help, thanks. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 7:29:57...

    nate | Latest reply: Xander Jun 14, 2010
    1 reply
  • Link column data to row cells - formula Closed

    Hello, I am trying to copy data on one worksheet that is in a column to a separate worksheet that is in a row. Worksheet 1 B C O...

    Smgmarino | Latest reply: rizvisa1 Jun 14, 2010
    1 reply
  • Create sheet base on the header Closed

    Hi, Can some one help me? I have a data with 2 worksheet 1)Data source 2)Data with header I would like to know how can i match the header wit...

    bb | Latest reply: rizvisa1 Jun 14, 2010
    11 replies
  • Macros Solved/Closed

    Hi, I need a macro coding for the below scenario. In column D(Application) i have created a validation in which i have included the list of appl...

    Saky | Latest reply: Saky Jun 14, 2010
    18 replies
  • Macro to show nonzero data in dialog box Closed

    Hello, i want to create a macro to show the data from the sheet in a dialog box. Let suppose i have a sheet where i record the rent information a...

    KENZO | Latest reply: rizvisa1 Jun 14, 2010
    1 reply
  • excel formula Closed

    Hello, okay, say i had six new customers and out of six i closed three on a sale. that is closing 50% of customers. so, if V12=6 AND X1...

    m.c | Latest reply: rizvisa1 Jun 14, 2010
    2 replies
  • Macro, Range Selection Closed

    Hello, I have a macro that chooses dates from a field which is a general download from our information system. It then sorts the dates Ascending, a...

    OT | Latest reply: vijay Jun 14, 2010
    3 replies
  • Date copy issue in excel Closed

    Hello, I need to copy dates from a webpage, it is displayed as JUN 12,2010 00:31:26 and I need the same date in excel as 12/05/2010 00:31 I'm u...

    Naga | Latest reply: rizvisa1 Jun 14, 2010
    5 replies
  • Date wrong after converted in Excel Closed

    Hello, I have data pulled from database to CSV file which can be opened with Excel. The date in the spreadsheet shows as "201003" in text format, an...

    Mask | Latest reply: rizvisa1 Jun 13, 2010
    1 reply
  • Excel Help with Percent calculations Solved/Closed

    Hello, I use "=AVERAGE(B2:AR2)" to calculate percentages based on information from 40 sheets. Example, On one sheet that compiles the data from 40 she...

    Scorchy | Latest reply: rizvisa1 Jun 13, 2010
    8 replies