Excel Forum

Ask a question
Search
Close
Results 7101 - 7150 of about 9,830
  • Macro insert into another sheet Closed

    Hello, Please I need some codes for this excel prob. Can anyone help me??? sheet 1 doc num accnt num 2000149110 1123 2000149110 1124 ...

    harris | Latest reply: rizvisa1 Sep 1, 2010
    24 replies
  • Comparing two excelfile worksheets Closed

    Hi, One more scenario I have . If I have three columns in worksheet1 of file1(book1) and 1 column in worksheet2 of file2(book2), I should get only ...

    kish1975 | Latest reply: THIRU Sep 1, 2010
    4 replies
  • Excel 2007 - Generate and Excel from Another Closed

    Hi, I have been stuck with this problem for a bit. The problem is - I am sending this excel file to my customers to fill in the bare minimum inf...

    videh | Latest reply: Ray Aug 31, 2010
    1 reply
  • Run Same VBA Macro Code On Multiple Sheets Closed

    Hello, I am trying to run the following code on multile sheets in a workbook. so far this code is working fine for one worksheet. Can someone help...

    issa | Latest reply: Issa Aug 31, 2010
    2 replies
  • Excel Help Closed

    Hello, Configuration: Windows XP / Internet Explorer 6.0 I am using a spreadsheet where column A will have as part of the cell text string L3 o...

    dazza | Latest reply: Dazza Aug 31, 2010
    2 replies
  • Excel formulas Closed

    Hello, I would like to ask for help on how to go about writing a formula in Excel. I have a bank statement that is approx. 2500 to 3000 line i...

    Juniore | Latest reply: Trowa Aug 31, 2010
    2 replies
  • Changing Dates into a Month on VBA Closed

    Hello, I have a column which lists the dates of certain activities in dd/mm/yy format. In the next column I would like the macro code in vba to re...

    sjpm84 | Latest reply: Trowa Aug 31, 2010
    1 reply
  • office03 excel file not open in win7 offic07 Closed

    Hello, Configuration: Windows 7 / Internet Explorer 8.0I newly installed windows 7 with office 2007 in my system. office 97- 2003 format excel...

    mozhi | Latest reply: netsa77 Aug 31, 2010
    1 reply
  • creating macro's Closed

    Hello, We have two excel sheets say sheet-1 and sheet-2. I have to copy particular cells say, from column 'A' first cell to column 'A' 25th cell. ...

    Deepu | Latest reply: venkat1926 Aug 30, 2010
    1 reply
  • Help! Find/search within text in Excel issue! Closed

    Hello, I need help, my boss wants me to put together an excel doc. with 4 columns -A, B, C, D - that when you do CTR+F you only retrieve/search in...

    Patricia As | Latest reply: Ray Aug 30, 2010
    1 reply
  • EXCEL Closed

    Hello, How can I have excel copy the entire row of data from excel file "sales" to another excel file called database if column N contains COMPANY...

    Goober | Latest reply: Ray Aug 30, 2010
    1 reply
  • Excel Formulas Closed

    Hello, Please help me with this ? I know what the percentage being deducted and I know what the end total is, I would just like to know how to ...

    grant77 | Latest reply: Ray Aug 30, 2010
    1 reply
  • merge cells into one Closed

    Hello, Need help to merge range of cells [on selection] into the last selected cell [using - sign as a separator]. Is there a Function or a macro...

    AD | Latest reply: Trowa Aug 30, 2010
    3 replies
  • Excel Macro to find last cell in Sheet Closed

    Hello, I'm building a compare using Excel and the macro is going to be used on all sorts of data sizes. Could be 100 rows, could be 2000 rows. ...

    DCecil07 | Latest reply: DCecil07 Aug 30, 2010
    4 replies
  • How to match two columns Solved/Closed

    Hello, I have 2 excel sheets with exactly the same format, in column A, I have the name of my customers and in Column B, the value of their sales. th...

    Paris | Latest reply: nitin Aug 30, 2010
    13 replies
  • Excel Condition format based on Specific Date Closed

    I'm trying to use conditional format in Excel to turn the cell GREEN if the date entered is AFTER Sep 30, 2009. Default is Red. I appreciate any gu...

    Marc | Latest reply: Ray Aug 27, 2010
    1 reply
  • Please Help! Excel Formula needed! Solved/Closed

    Hello, I have a spreadsheet with many columns: date issued, invoice number, gross£, net£, vat£, date due, date paid. until the invoice is paid ...

    felloutthesky | Latest reply: Ray Aug 27, 2010
    2 replies
  • Run macro by choice in data validation list Closed

    Hello, Excel 2007-I have a macro that I want to run IF one choice of a data validation list is picked. I've read through the site and don't unders...

    LolaZ | Latest reply: Ray Aug 27, 2010
    1 reply
  • Need Macro Excel Net to Zero Closed

    Good Morning All, I would love to hear from all the experts on this forum. I have a set of data that consists of many rows and columns. All the tr...

    buDDHA | Latest reply: Ray Aug 27, 2010
    3 replies
  • Macro to copy row in new sheet if text found Closed

    Hello, I need help in creating a macro that will copy all rows of a sheet into a new sheet if a text is found. The sheet with the data is ca...

    edz | Latest reply: edz Aug 26, 2010
    1 reply
  • Complicated Lookup in Excel Solved/Closed

    For me at least..... I have two spreadsheets that I am trying to use a lookup on. It's a little more than a VLookup. PTCI and TECI are the names ...

    DCecil07 | Latest reply: DCecil07 Aug 26, 2010
    5 replies
  • excel problem. Closed

    Hello, i am having a worksheet (excel 2003)with the details as bellow: coloum a: stock name coloum b: high coloum c: low coloumc...

    shovidya | Latest reply: rizvisa1 Aug 26, 2010
    5 replies
  • Current time by clicking comm button in excel Closed

    Hello, how to get the current time by clicking command button for any active cell

    geoganesh_80 | Latest reply: venkat1926 Aug 26, 2010
    5 replies
  • Copying data from one worksheet to another Solved/Closed

    Hello, I have created a worksheet with 1000 rows of information that has 12 columns that vary with input information. Each row could have 1 or up ...

    rencharles | Latest reply: TopherPUSA Aug 25, 2010
    1 reply
  • excel date format Closed

    Hello, i have got an excel sheet which is prepared by some tool having two columns with custom and the format is mm-dd-yyyy hh:mm:ss. when i am r...

    Nune | Latest reply: goodscoolxh Aug 25, 2010
    2 replies
  • Macro for a range Closed

    Hello, I have this macro below that works only on single cell. How can I change the coding from just singl cell to a range of cell (a1:a30). Thanks....

    dzrdw0 | Latest reply: dzrdw0 Aug 24, 2010
    2 replies
  • MAC EXCEL Closed

    Hello, I have had my macbook pro since April and without issue. Now all of the sudden my excel software will not open I get the following message:...

    polly | Latest reply: rizvisa1 Aug 24, 2010
    1 reply
  • Trouble with functions in Excel Closed

    Hello, I'm currently making a spreadsheet which is designed to take the start and end time of a staff members shift and use conditional formattin...

    Glitch | Latest reply: rizvisa1 Aug 24, 2010
    1 reply
  • Macro to divide column into multiple columns Closed

    Hello, I have a monthly report which is run and exported to Excel. I have one column of data which may be between 5K-10K rows depending on number...

    Cosmo71 | Latest reply: rizvisa1 Aug 24, 2010
    1 reply
  • Comparing 2 Columns and returning an answer Closed

    Hello, I'm trying to figure out a formula. If Column D = X then I want to return the value in Column B from the same row. Does that make sense? I...

    Lenny | Latest reply: rizvisa1 Aug 24, 2010
    1 reply
  • convert Worksheet_change event to macro Closed

    Hello, How can I convert WorkSheet_change event becomes a macro. Please see code below. thanks. Private Sub Worksheet_Change(ByVal Target As Ex...

    dzrdw0 | Latest reply: rizvisa1 Aug 24, 2010
    4 replies
  • how to merge an excel file to database? Solved/Closed

    Could someone please instruct me how to merge an excel file to database (MS Access/FoxPro/Oracle)?

    ecaep5791 | Latest reply: satya Aug 24, 2010
    10 replies
  • Find string/date, copy row to another sheet Closed

    Hello, I'm new to VBA and currently working on a macro wherein I wanted to search for a specific date (e.g. 08/17/2010) then copy the entire row f...

    Karlo | Latest reply: venkat1926 Aug 23, 2010
    7 replies
  • macro to round up (ceiling function) Closed

    Hello, I have a bunch of raw data [in cell range $B$2:L499] I want a macro which will read each of the cells and re-populate with Integers. I'v...

    Netscur | Latest reply: Netscur Aug 23, 2010
    5 replies
  • Excel Formulas Solved/Closed

    Hello, I am having difficulty copying fromulas on excell from different sheets to form an analysis page. I have 52 different sheets and need to ...

    BEAR833 | Latest reply: rizvisa1 Aug 23, 2010
    30 replies
  • Compare two excel columns Closed

    Hello, I have two excel sheets. One has Server Names only. Second has server names with other columns with more data like OS,Supplier,Application...

    avinash | Latest reply: Game Start Now Aug 23, 2010
    1 reply
  • Excel - Formula in text count Solved/Closed

    Hello, I Need a formula in text count For Example P=1 P+P+P+P+P= 6 What is the formula in excel please defineConfiguration: Windows XP / ...

    Sam | Latest reply: sk Aug 23, 2010
    3 replies
  • copy / paste specfic DATE to other worksheet. Solved/Closed

    Hello, I've got a few columns of data in which 3 columns contain dates (in date format : dd/mm/yyyy) . Now, I want excel to seperate the entire row ...

    carman | Latest reply: carman Aug 22, 2010
    11 replies
  • Date Counting in Excel Closed

    Hello, How can I count rage of date in excel? Configuration: Windows XP / Internet Explorer 6.0

    Ahijit | Latest reply: Game Start Now Aug 22, 2010
    1 reply
  • find and replace cell value macro help pls Solved/Closed

    Hello, i have these 20 formulas (1 per stock code) in my spreadsheet that come from etrade =PROStaticData(2, "mqg.ASX", "2010/08/10;2010/08...

    jonny | Latest reply: jonny Aug 21, 2010
    6 replies
  • NEED HELP WITH EXCEL!!! Closed

    Hello, I have two sheets with 5 columns each; item number, description, quantity on-hand, price & total value. I want to match the columns on shee...

    LIZ | Latest reply: JayHerring Aug 20, 2010
    2 replies
  • Macro: Watch a cell and copy if changed Solved/Closed

    Hello, The problem in a nutshell is that I have 5 pivot tables on one worksheet, each with a field called "date" above the main text. Each day the...

    IneptMacro | Latest reply: JayHerring Aug 20, 2010
    4 replies
  • List unique values from multiple columns Closed

    Hello, I am kind of new in advanced programming with Excel. I have a table that gathers a number of sentences which I classify with 3 category c...

    Socio | Latest reply: Swami Aug 20, 2010
    2 replies
  • Excel2007 copy cell from sh1 to sh2 range Closed

    Hello, I would like to copy the variable text content of Cell K8 on Sheet2 to a cell range of D6 to D35 on Sheet1 so that the text entered into K8...

    alfiepanda | Latest reply: jziutsa Aug 20, 2010
    2 replies
  • Search for accounts balances Excel or Access Closed

    Hi guy's, I need your help with the following problem. I have a list of accounts in an Access Database, each account has a balance next to it. ...

    PM | Latest reply: rizvisa1 Aug 20, 2010
    1 reply
  • Excel Formula add data if columns match Closed

    Hello, I am basic excel user who is slowly needing to use formulas. I have two seperate charts that I've put into 2 worksheets with similar informati...

    kv | Latest reply: rizvisa1 Aug 20, 2010
    3 replies
  • Matching a cells in different columns Closed

    Hello, I want every cell in Column A find a matching cell in Column B, if there is a match, then I want results shown in column C in the same row ...

    vg | Latest reply: rizvisa1 Aug 20, 2010
    1 reply
  • read data from Excel 2003 to write to SQL Closed

    Hello, Help please I have to read data from Excel 2003 to write to SQL server using .net, so every time user modify data it shuld refelect to...

    jo | Latest reply: rizvisa1 Aug 20, 2010
    1 reply
  • Excel formula help Closed

    Hello, I have the following problem and need someone to help me solve it. I want to concatenate items in column A, but it must only concatenated ...

    Walter | Latest reply: rizvisa1 Aug 20, 2010
    1 reply
  • Excel Formula Clarification Closed

    Hi Guys and Gals, Is there a formula that can make the value of any given cell always display the 1st day of the current month? I am aware of th...

    Shonky | Latest reply: rizvisa1 Aug 20, 2010
    4 replies