Excel Forum

Ask a question
Search
Close
Results 6851 - 6900 of about 9,870
  • Macro help Closed

    Hello, Is there a Macro available that will allow me to only pull unique data from one worksheet to another? For example, I have a bunch of data,...

    Jess | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • urgent help in macro Closed

    Hello, happy nEW year i need your urgent help in macro . i have some data like below in excel A B C E F Customer Name RDS ID Device ID Produ...

    usha | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Calculating time in an Excel formula Closed

    Hello, I have an Excel formula that works: =WORKDAY(A2-13.5/24,1)+IF(NETWORKDAYS(A2,A2), IF(MOD(A2,1)*24

    treehouse | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • How to chang text color automaticaly in excel Closed

    Hello, I want to chnge the text color if the value of other relative cell is changed. For eg. I have cell range from B11 to XAV11, if any value...

    sanchit bedi | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • HELP IN MACRO Closed

    Hello, happy nEW year i need your help in macro . i have some data like below in excel A B C ...

    ANU | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Excel 2007 Moving information button Closed

    Hello, I need to create a button which movies an information from one row in one sheet to other row in another sheet. I can create it with macro 1 b...

    Moncevas | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Compare two worksheets macro Closed

    Hello, I was looking for some help as far as setting up a macro that compares to worksheets into a third worksheet and came across this macro. Thank...

    dhunter | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Try to match cells and return values Closed

    Hello, I need help!! I have a table containing the following: Column A Column B Column C Column D product Country State Date ...

    Paulie462 | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • vb macro to copy image from file to cell Closed

    Hello, I have a VB issue, i have a excel sheet where i wish upon entering a number in column C (starting at row 10) a jpeg with the same name will...

    euan_444 | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • EXCEL 2007 HIGHLIGHT MAX&MIN VALUES Closed

    Hello, I have lists around 500 rows long each group of dates ×& marks separated by an empty row is there a macro to highlight the max&min values ...

    bigband | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • create a new matrix in excel macro Closed

    Hello, I would like to create a new matrix under some conditions from old dataset. Basically, I want to choose rows from the old data as long as ...

    Karen | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Data entry in two excel files using a form Closed

    Hello, I have two excell files "a.xls" and "b.xls" both are having Three sheets "Sheet1", "Sheet2" and "Sheet3". Both the sheets are protected by...

    bhavikalkesh | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • how to check for the last row of excel Closed

    hi, i am writing data from csv file to excel using c#, by data contains more that 80000 rows, so i want to check the end of the excel file i.e the ...

    new_c# | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Countif macro codes on multiple criteria Closed

    Hello, I need a macro codes with condition applied in formulae. I have a text as below in excel from C1 to C33 and i want a macro to count of "f...

    waseem | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Highlighting Cells based on Dates of other ce Closed

    Hello, I am working on the following. I have names of customers in column A and dates in columns B, D, F, H, J and L. I am trying to highlight the...

    Dave | Latest reply: rizvisa1 Feb 9, 2011
    3 replies
  • Rollup or summary sheet Closed

    Hello, i am quite a 'newbie' at VBA and have run into something that i can't seem to get started. i have sheets by month that have the same amoun...

    JagMan | Latest reply: rizvisa1 Feb 8, 2011
    4 replies
  • Copying data excel worksheets Closed

    Hello, Can someone give me an easier way to do this? I have in column A; Team 1, Team 2, 3,4 etc down to 30. In coloumn B, I have 'week 1' Afte...

    Welshjessy | Latest reply: rizvisa1 Feb 8, 2011
    1 reply
  • Match Excel Data and return associated data Closed

    Hello, I have an excel sheet that I am trying to match data up on. Essentially, my data looks like this: Column A Column B Column C Col...

    scotth3680 | Latest reply: Ambucias Feb 8, 2011
    2 replies
  • Microsoft Excel Look Ups Closed

    Hi Guys, Please can you help. I am trying to do a formula which allows me to look take a cell, for example the word 'help' and look for it in a...

    Excel_Novice | Latest reply: rizvisa1 Feb 8, 2011
    1 reply
  • Excel-format exported file to proper col/rows Closed

    Hello, This is my problem: I generate a report from my accounting system and export the data to Excel. As an example, if i generate a sales order ...

    Jjudy | Latest reply: rizvisa1 Feb 8, 2011
    3 replies
  • Excel Search & display query Closed

    Hi All, I am a non IT person.. I have a simple requirement, but dont know how to go about. The requirement is My data. Sno Release Project ...

    Shiny | Latest reply: rizvisa1 Feb 8, 2011
    11 replies
  • may i request help with comparing two columns Closed

    Greetings everyone, I needed some help and would appreciate any comments or advice if possible. I am working in development finance and i got ...

    zorroaccountant | Latest reply: rizvisa1 Feb 8, 2011
    1 reply
  • vba search & find, select entire row and move Closed

    Hello, Hi, Can anyone help????? I need vba for cmdbutton on userform to move one row data into another row. I have a worksheet "details1" ...

    rach1234 | Latest reply: TrowaD Feb 7, 2011
    1 reply
  • Macro to class interval Solved/Closed

    Hello, I have a workbook of employee data and at dth column i have ages of employee. in eth column i have to define age interval like. 18-25...

    rahul | Latest reply: TrowaD Feb 7, 2011
    1 reply
  • VBA for excel Closed

    Hello, I need to open one after another xls files from the spec. folder, then activate another workbook and copy 4 cells from it, then paste those...

    gunsrima | Latest reply: venkat1926 Feb 7, 2011
    3 replies
  • I need information to move to the next cells. Closed

    Ok, so my problem is probably simple, but since I'm new to this, I'd like a little help. So, I have stuff that I have in "Quote Download" tab, and I n...

    theritz226 | Latest reply: venkat1926 Feb 5, 2011
    1 reply
  • macro code for making a graph in excel Closed

    Hello, I would like to create a graph from a macro. Here is what I have got so far. Charts.Add ActiveChart.ChartType = xlXYScatterLinesN...

    Shandor | Latest reply: Neil A Feb 4, 2011
    10 replies
  • macro regarding the cell color Closed

    Hi I would like to have a macro for the following when i type "red" in a cell the whole cell turns red when i type "orange" in a cell the whole ...

    rommy | Latest reply: TrowaD Feb 3, 2011
    1 reply
  • Extract info from Excel Closed

    Hello, I wonder if you could please help me. I thought this would be something simple but after an exhaustive search and using filters and Vllookup I...

    Amanda | Latest reply: TrowaD Feb 3, 2011
    1 reply
  • Excel less than but greater than Solved/Closed

    Hello, How would I get into L2 if J2=>10 then "lates", if J2=

    Welshjessy | Latest reply: Welshjessy Feb 3, 2011
    2 replies
  • Excel-extracting names into seperate elements Closed

    Hello, I have several hundred names in an excel file written like this Doe, John A and I want to seperate them into 2 columns with first names in ...

    GoldBar | Latest reply: Steveinuk Feb 3, 2011
    1 reply
  • Excel 2007 date 20100915 without formatting Closed

    Hello, I have a column of dates (around 800 rows) with dates entered in as 2010/09/15 as date format. I need to convert these to GENERAL format an...

    heidist | Latest reply: Steveinuk Feb 2, 2011
    1 reply
  • find and replace in EXCEL Closed

    Hello, all i have been suffering to find a solution for a problem which is : I have three categories which I call region (Central, Northern and ...

    Talahjer | Latest reply: venkat1926 Jan 28, 2011
    8 replies
  • How to add COUNT to a column w/ 3000+ rows? Closed

    Hello, I have a column with numbers in them (1) Column, over 3000+ rows. How can I simply add the 'COUNT' text in each cell without having to ent...

    Cha-Cha | Latest reply: rayh Jan 28, 2011
    1 reply
  • Highlight max/min in excel 2007, VBA Closed

    Hello, I'm quite new to Excel VBA and need some help doing the following. I have a lot of data and need to highlight (or change the background ...

    Algae | Latest reply: Algae Jan 27, 2011
    2 replies
  • Macro - check name and then insert blank row Closed

    Hello, Would appreciate any help on below. I need a macro that would insert a blank row after each unique entry. To illustrate imagine follo...

    Miknas | Latest reply: rizvisa1 Jan 27, 2011
    1 reply
  • Excel Formula to populate fields Closed

    Hello, I have a spreadsheet with Employee names (A2...A150) & one of 5 Divisions that they work for (B2...B150). What I am trying to do is put the...

    graphictees | Latest reply: rizvisa1 Jan 27, 2011
    1 reply
  • Copy 5 columns and paste to next 5 columns Closed

    Hello, I have to run daily reports where I have to add new day data to the right end of the spreadsheet. Example is below. I want to create a macr...

    ichiban85 | Latest reply: rizvisa1 Jan 27, 2011
    1 reply
  • How to copy sheet1, sheet 2, sheet3 in Sheet4 Closed

    Hello, How to copy sheet1, sheet2, sheet3 and Sheet 4 in Sheet 5(same excel workbook) using macro? I want to copy columns A-W The rows will ...

    Sam | Latest reply: rizvisa1 Jan 27, 2011
    1 reply
  • how to do in excel Closed

    Hello, I've four columns: A (with Names), B (with date of birth), C(random name of column A) and D (the result i want automatically). What formul...

    luis | Latest reply: rizvisa1 Jan 27, 2011
    1 reply
  • COlor change macro Closed

    HI All, I need an excel macro where i require to do the following things: if i type RED then the cell in which i type RED turns red, SImilarl...

    Rommy | Latest reply: venkat1926 Jan 22, 2011
    1 reply
  • Excel if function Solved/Closed

    Hello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...

    PM | Latest reply: PM Jan 20, 2011
    4 replies
  • Macro to find and copy all columns Closed

    Dear all, I've searched online for 2hours but still unable to find suitable threads, please direct me to the information or help me out with the fo...

    iceteee | Latest reply: rizvisa1 Jan 19, 2011
    1 reply
  • Excel Macro assistance please. Closed

    Hello, I am trying to write a simple Macro which would look at a corporate organizational chart in Excel. The Macro would list the company name an...

    vanilla_thun... | Latest reply: rizvisa1 Jan 19, 2011
    1 reply
  • Excel Macro, Time input button Closed

    Hello, Excel Macro Help PLEASEE!!!? Ideally i want a time in and a time out button, so that when workers sign in they click the timein button a...

    nickrenwick | Latest reply: rizvisa1 Jan 19, 2011
    1 reply
  • excel hide column formula Closed

    Hello, I'm trying to find a way to hide a colum in my excel workbook when I would select one of 3 drop down menu items. The drop down list is lo...

    rimx | Latest reply: rizvisa1 Jan 19, 2011
    1 reply
  • Copy Paste multiple rows - incrementing issue Closed

    Hello, I'm having a problem, I have 9 rows of data that contain formulas that pick up data from other worksheets. When I copy and paste to the nex...

    perkind1 | Latest reply: rizvisa1 Jan 19, 2011
    1 reply
  • excel: don't print when cell value is 0 Closed

    Hello, Please, I have an excel file with several worksheets. I made a macro that when I click a button, the worksheets are printed. There are sev...

    WvL | Latest reply: rizvisa1 Jan 19, 2011
    1 reply
  • Filter Problem in Excel 2007 Closed

    Hello, Im Xishan, using excel 2007 & facing problem while delteing rows of filtered data. When i delete filtered rows, other rows(unfiltered ones) ...

    Xishan | Latest reply: Sastry Jan 17, 2011
    1 reply
  • Help! Trying to copy rows of data via macro Closed

    Hello, I could really use some help. Here is what I am trying to do.I have a mound of data that i want to break up into different sheets. I want to u...

    Cman | Latest reply: venkat1926 Jan 16, 2011
    5 replies