Excel Forum

Ask a question
Results 6551 - 6600 of about 9,840
  • Excel/VBA 2010 - searching for wild cards Closed

    Hello, I'm wondering if it is possible to write a code that will search for wild cards. For example: we have a pattern of numbers that come up in ...

    whitepanther | Latest reply: whitepanther Jul 10, 2011
    8 replies
  • Variable Sharepoint link into Excel Closed

    Hello, Configuration: Windows XP / Internet Explorer 7.0 Looking to allow a cell value to dictate a link to a spreadsheet in Sharepoint. S...

    Dave | Latest reply: Ambucias Jul 8, 2011
    1 reply
  • VBA Macro Matrix Multiplication with a scalar Closed

    Hello, I've been struggling with what should be a simple operation using Excel VBA and was hoping someone could please help me out. Basically I hav...

    VBAConfused | Latest reply: MANMANI Jul 8, 2011
    6 replies
  • Please help with user form in Excel. Closed

    Hello, Hello, I'm getting stumped and just need someone to help out. I know I am over looking something simple but can't figure it out. My user ...

    jkperez | Latest reply: rizvisa1 Jul 6, 2011
    3 replies
  • Excel Office2007 macro Solved/Closed

    Hello, I writting a macro to clean up the format of a report down loaded into excel. I'm stuff on on section. I have filter column A for blank cell...

    SOS | Latest reply: rizvisa1 Jul 6, 2011
    3 replies
  • VBA Excel 2010 Closed

    Hello, One more question! I'm looking for a code that will allow us to compare rows of data and highlight which rows are different. We have 2 ...

    whitepanther | Latest reply: whitepanther Jul 5, 2011
    4 replies
  • EXCEL - Cells formatted as NUMER PESEL ??? Solved/Closed

    Hello, Firstly, just a quick one: I want to use conditional formatting to check if a cell ( say A1) has a red background and if it does then re...

    XLR8R | Latest reply: rizvisa1 Jul 5, 2011
    5 replies
  • Excel - Macro to search & paste to new sheet Closed

    Hello, I am working on a log for items that have gone in a machine at work. Some of the items come out damaged and therefore are void. These are a...

    Theta Sigma | Latest reply: rizvisa1 Jul 5, 2011
    4 replies
  • deleting and combining rows in excel with con Solved/Closed

    Hello, I hope someone knows the answer: I have simple table Column A: item # Column B: text example: Item # Text 2 text 1 2 t...

    archie9999 | Latest reply: TrowaD Jul 5, 2011
    3 replies
  • copy paste autofilter data macro to new sheet Closed

    Hello, Dear all, I have a worksheet "data reqd" which will be generated by a macro based on the input of another sheet. I am herewith attaching my...

    suryam | Latest reply: rizvisa1 Jul 4, 2011
    1 reply
  • Copy/paste cell A to new sheet if cell B=1or2 Closed

    Hello everybody, I am slowly trying to learn about Macros to make my data sorting and report running easier and am asking for some help/guidance fr...

    Jeremy | Latest reply: rizvisa1 Jul 3, 2011
    1 reply
  • Microsoft Excel Closed

    Hello, In column A I have specific numbers in each cell (i.e. A1= 1, A2=2, A3=3, A4=5), then in column B I have cells that have numbers as well (i.e...

    jms31280 | Latest reply: rizvisa1 Jul 2, 2011
    1 reply
  • Excel conditional formatting help Closed

    Hello, Really need some help with an Excel problem. I have to try and change the cell background colour under certain conditions. I've tried con...

    JPMorini | Latest reply: rizvisa1 Jul 2, 2011
    1 reply
  • Split Worksheet Solved/Closed

    Hello, Is it possible to Split one worksheet to different workbooks( files). I am having a statement to be send to 10 branch offices. sample...

    PMARI | Latest reply: rizvisa1 Jul 2, 2011
    5 replies
  • macro to check the last 7 values against mean Closed

    Hello, I am looking for help writing a macro to check the values of my last set of 7 results against a mean of the last 30 points. -Say I have ...

    Colin | Latest reply: RWomanizer Jun 30, 2011
    1 reply
  • partial match multi-sheet comparison Solved/Closed

    Hello, I am trying to compare a manufacture's part number in a spread sheet with a spreadsheet that we have to match these part numbers to their U...

    LostIntern | Latest reply: RWomanizer Jun 29, 2011
    5 replies
  • Excel VBA Macro coding/ data look up Closed

    Hello, I have a single workbook with multiple sheets. one of my sheets contains a list of information (ie date,name,owner,description, and a cate...

    keendiggz | Latest reply: venkat1926 Jun 28, 2011
    3 replies
  • MS Excel 2007 won't read in 2003 Closed

    Hello, I have a excel 2003 file. My application is excel 2007. When I save the file as .xls, I lost all the format. So, I save the file as .xlsm...

    duoduo | Latest reply: DrewTech Jun 27, 2011
    10 replies
  • copy columns Closed

    Hello, i need to copy column values from 1 worksheet into another if the em id is the same in the two worksheets... that means worksheet 1 has empi...

    nivi | Latest reply: RWomanizer Jun 27, 2011
    1 reply
  • i want to delete rows except certain values Closed

    Hi any one plzzzzzzz help me, this sheet has 5 columns column A COLUMN B COLUMN C COLUMN D COLUMN E row 1 --- vegetable,...

    vani | Latest reply: rizvisa1 Jun 26, 2011
    1 reply
  • Copy non adj. cells from two sheets into one Closed

    Hello, On two occasions in the past this community has been of incalculable help to me, and I was wondering if there might be one more assist th...

    ChrisCOR | Latest reply: ChrisCOR Jun 24, 2011
    1 reply
  • 404 error in mozila firefox browser Closed

    Hello, I want to connect oracle10g throw JSP code.I already implement registration page but after inserting some value when I click submission bu...

    Bishu | Latest reply: Ambucias Jun 24, 2011
    1 reply
  • retrieve a range chart through macro Closed

    Hello, I am trying to add a new series in a graph through macro. Range of the new series is similar to the other series already plotted in the ...

    BV | Latest reply: rizvisa1 Jun 23, 2011
    1 reply
  • Search for a values in 2 sheets using macro Closed

    Hi, I have Response XMl Schema from 2 different environment of an application in sheet1 and sheet2 on the msexcel . I have a collection of xml ta...

    priya | Latest reply: rizvisa1 Jun 23, 2011
    5 replies
  • Inserting/Copy rows, Transpose vba HELP Solved/Closed

    Hello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my prob...

    cswiss | Latest reply: shameem007 Jun 23, 2011
    9 replies
  • conditional copying into different worksheets Closed

    Hello, i have excel 2003. what i am trying to do is set up a complaint sheet for 4 different people. In total there are 5 sheets (Main, Al, Bri...

    jleschyson | Latest reply: rizvisa1 Jun 22, 2011
    1 reply
  • Excel formula needed to look up and copy data Closed

    Hi, I have a list of aged debtors that is updated weekly, Im looking for a formula that will search the previous list via the invoice date and if ...

    AlexA | Latest reply: RWomanizer Jun 22, 2011
    1 reply
  • Merge rows if it meets criteria in Excel Solved/Closed

    Hello, I would like to know if I can merge rows if it meets certain criteria in Excel. If Project ID on column A is matched, it will merge all the ...

    cacaip89 | Latest reply: rizvisa1 Jun 21, 2011
    6 replies
  • excel 2007 is not working properly Closed

    Hello, We are using office 2007. My problem is, we are type 2400 or other number in my excel sheet. It hides the last to digit. It show only 24 .We ...

    Ganesh | Latest reply: Excelguru Jun 21, 2011
    1 reply
  • Help with Excel macro Closed

    Hello, Hi. I am not a programmer and have not used Visual Basic before so that's probably my first problem (!) but I am trying to debug a macro in...

    iano | Latest reply: Excelguru Jun 21, 2011
    1 reply
  • Pulling ordered parts from sheet 2 and insert Closed

    Hello, What I'm attempting to do is create a master list of items ordered and what they are ordered for. Sheet 1 is a list of tasks generated b...

    AviationGuy | Latest reply: venkat1926 Jun 20, 2011
    1 reply
  • Import Data into Excel Closed

    Hi, I have 2 excel sheets namely A.XLS and B.XLS. I would like to import the data from A to B by running a command button in spread sheet B. Can an...

    BN Rao | Latest reply: venkat1926 Jun 20, 2011
    1 reply
  • Conditionally deleting rows in excel 2007 Solved/Closed

    Hello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D a...

    Alta | Latest reply: aquarelle Jun 20, 2011
    5 replies
  • excel data updation Closed

    Hello, Configuration: Windows XP / Internet Explorer 8.0 I have date in an excel spreadsheet that gets updated automatically every minute. ...

    prakash | Latest reply: venkat1926 Jun 19, 2011
    1 reply
  • Need help in saving file which macro download Closed

    Hello, I have a macro which login to one of my site and download a file based on the no what the macro picks up from the excel file. While doing...

    hari | Latest reply: hari Jun 17, 2011
    2 replies
  • Webpage to excel Solved/Closed

    Hello, Could you please help me in downloading data's from a web page to an excel. If that web page has multiple pages ( 1,2,3,4.... ), i want all ...

    priyaa | Latest reply: TrowaD Jun 17, 2011
    1 reply
  • macro to copy certain data Closed

    Hello, I regret to say that I missed using hello and other polite words in my earlier post. I do respect the people behind the forum. I know that ...

    Kumar | Latest reply: venkat1926 Jun 16, 2011
    9 replies
  • Copy an excel worksheet multiple times Closed

    Hello, I have an excel worksheet, which I want to make 38 copies of, and rename each copy with the initials of the person to whom it belongs. The ...

    TJ | Latest reply: rizvisa1 Jun 14, 2011
    1 reply
  • How can i compare two excel sheets using VBA Closed

    Hello, I am having two text files ( which is a comma separated file).The template of the two file is given below. SD,CurrentDate,RecordCount ...

    Rajesh | Latest reply: rizvisa1 Jun 14, 2011
    1 reply
  • Linking excel sheets and getting 0's all over Closed

    Hello, I have a document that we adjust the master, and then each fiscal year I want on separate sheets but to be updated with the master. I linke...

    Michellllah | Latest reply: rizvisa1 Jun 14, 2011
    1 reply
  • formula: to count cells and then add number. Solved/Closed

    Hello, All Hope you can help! I have a list of actions 1 Contacts 2 Appointments 3 Estimates 4 Sales contacts counts as 1 contact,...

    Stormdronk | Latest reply: rizvisa1 Jun 14, 2011
    3 replies
  • Macro not working in shared work book Closed

    Hello everyone, my macro works fine, but when i share my work book it is throwing some error, Run-time error '1004': AdvancedFilter method of R...

    arockiad | Latest reply: rizvisa1 Jun 13, 2011
    5 replies
  • Needed a VBA. Solved/Closed

    Hello, I'm very new to progamming kind of stuff... i need to generate a report from a excel sheet. Coloumn Q of "data" sheet has only 0 or 1, whi...

    doss | Latest reply: rizvisa1 Jun 13, 2011
    6 replies
  • Update the value of excel files Closed

    Hello, i wanted to ask if there is a method so that i can keep other excel files updated when i make some changes in a particular file.....suppos...

    dgenx | Latest reply: rizvisa1 Jun 12, 2011
    1 reply
  • move rows to columns using macro Closed

    Hello, need help with macro to move rows to columns please E-Mail ID is removed for your security if you can help with this. thanks

    a123577 | Latest reply: rizvisa1 Jun 12, 2011
    1 reply
  • Excel "if" for letters to equal values Solved/Closed

    Hello, I have a yes or no sheet, one column for yes and one column for no. I want the end column to calculate a 1 for yes, and 0 for no, and in s...

    Charles | Latest reply: TrowaD Jun 9, 2011
    1 reply
  • VBA Transfering Data To Next Sheet Closed

    Hello, I'm applying this code to transfer data from sheet 1(source) to sheet 2(destination). Sub TransferData() For Each cell In Range("B...

    azmiismail | Latest reply: RWomanizer Jun 9, 2011
    1 reply
  • Macro help Closed

    Hello, i use a macro for filering my data into another and macro code is Sub Extract1() ' ' Extract1 Macro ' extract ' ' Keyboard S...

    doss | Latest reply: Ambucias Jun 8, 2011
    1 reply
  • Excel 2007 Closed

    Hello, I am a very novice/beginner Excel user. I have a table of Company information in a vertical column which I want to convert to a horizontal...

    dharris01 | Latest reply: rizvisa1 Jun 7, 2011
    1 reply
  • EXCEL Move A1 to A2 in a formula Closed

    Hello, I have a 9 digit zip code in column A. I need to phyically move the first 5 digits to column B cell by cell, i.e. A1 to B1, A2 to B2, e...

    Kent | Latest reply: bionik Jun 6, 2011
    1 reply