Excel Forum

Ask a question
Search
Close
Results 7601 - 7650 of about 9,840
  • office(Excel) 2007 shortcut keys Closed

    Hello, Sir this is vivek, can anyone provide me shortcut keys for excel 2007. wud b vry gr8fl thx...Vivek Configuration: Windows XP / Saf...

    love2garv | Latest reply: rizvisa1 May 18, 2010
    1 reply
  • Excel - Macro copy Date for "n" month Solved/Closed

    Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...

    mama_tracy | Latest reply: rizvisa1 May 18, 2010
    3 replies
  • Kindly Help me on Macros Closed

    Hi All, Kindly provide me a Macro for find and replace for an X no of dots in to a single / Example: manoj..............Kumar Rajesh..........

    Manoj | Latest reply: rizvisa1 May 17, 2010
    1 reply
  • mapping jpeg name to excel database Closed

    Hello, I've got a folder with a number of jpeg pictures each named after employee names. i need to rename with full names (First Middle Last Name) ...

    smd_excel | Latest reply: rizvisa1 May 17, 2010
    2 replies
  • Macro-To Create 1 [.csv] using multiple excel Closed

    Greetings, I have more than one Excel Workbooks containing multiple worksheets in each of them. It would be a great help if some one provide me ...

    AJ | Latest reply: rizvisa1 May 16, 2010
    9 replies
  • Excel 2007 VBA If then offset Closed

    I have a sheet where the rows size varies and I am looking for code to lookup column F starting in row 3 to the bottom and if the cell has a "Q" then ...

    TJ | Latest reply: rizvisa1 May 15, 2010
    3 replies
  • Internet connected but cannot browse? Closed

    Hello, well here's the background to my problem: I'm running xp sp3 on a dell inspiron 1300 and 4 years old, and yesterday it updated and ran a ...

    Wunnsberg | Latest reply: mrrigga May 15, 2010
    4 replies
  • Remove value of "0" from blank Excel cell Closed

    Hello, I need to set conditional formatting so if the number 0 - 999 is typed in a cell, the cell fill will be yellow. If the cell is blank, I need...

    TDB | Latest reply: rizvisa1 May 15, 2010
    1 reply
  • Excel issue - how to return data from a list Closed

    Hello, I'm using Excel 2007 and I simply can't do what I need to and can't find an answer anywhere! I have a large table of approx 500,000 ...

    Katie Watkins | Latest reply: rizvisa1 May 14, 2010
    7 replies
  • Macro for more than 3 conditional formats Closed

    Hello, I recently used the attached link to circumvent the limitation of excel's conditional formating (i.e. 3 conditions) and used the macro to exten...

    JFC1 | Latest reply: rizvisa1 May 14, 2010
    1 reply
  • Excel every 25th row Closed

    Hello, I have over 7,000 rows and I need to find every 25th one and don't want to hand count. Is there a way to sort or is there a formula to find ...

    amess | Latest reply: rizvisa1 May 14, 2010
    1 reply
  • excel urgent Closed

    hi. This is possiable? i have a, large amount of employee data .sometime some employee runaway,or after vacation not come back.in this case i want to...

    milan | Latest reply: rizvisa1 May 14, 2010
    1 reply
  • insert multiple columns then copy data Closed

    I want a macro to insert varying number of columns then copy the corresponding data original data: ColumnA ColumnB Col...

    dors | Latest reply: rizvisa1 May 14, 2010
    1 reply
  • Excel - Copy rows "n" times with calculation Solved/Closed

    I need to have a macro that will copy rows from sheet1 to sheet 2 . The catch is from sheet 1 col C for e.g. C2 may have the number 5 in it. I need to...

    Tracy | Latest reply: rizvisa1 May 14, 2010
    3 replies
  • EXCEL Solved/Closed

    hi i always make our employee salary in excel. this file is very big. every month I have to put only OVER TIME,WORKING DAY and ABSENT...and i make all...

    milan | Latest reply: rizvisa1 May 13, 2010
    5 replies
  • Can a macro add a number? Solved/Closed

    I am working on a excel project where I will be able to click a button and the result would be a number added on another cell. For example, counting a...

    Giorgio.usa | Latest reply: rizvisa1 May 13, 2010
    7 replies
  • copy columns one below another Solved/Closed

    Configuration: Windows XP / Internet Explorer 7.0 hi i have data in the following form a b c d 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 1...

    sun_dands | Latest reply: rizvisa1 May 13, 2010
    7 replies
  • Combining 2 cells to 1 Solved/Closed

    Hi, I have data like below in two column of excel sheet: 1-Jan | 2004 23-Jul| 2004 12-Feb|2003 ................ ......... Out out require...

    Shashi | Latest reply: Shashi May 13, 2010
    2 replies
  • excel Closed

    Example : I have column A' where i am entering a number and this number (given by the user) has to be multiplied by 10 and the value/answer should app...

    bobbymullick | Latest reply: rizvisa1 May 12, 2010
    1 reply
  • help excel: click & automatically copy paste Solved/Closed

    I need some help Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: popula...

    isabelle | Latest reply: rizvisa1 May 12, 2010
    1 reply
  • Macro to allow users to modify? Closed

    Can anyone please create a macro that will give access only to few users to allow modifying data in an excelsheet.

    Erei | Latest reply: rizvisa1 May 12, 2010
    2 replies
  • Sorting and Suming # in Excel Closed

    Hello Everyone, I need your expertise in this. I want to do the following. In a list I input data consisting of Amounts, Expense Type, and Date...

    Betevang | Latest reply: rizvisa1 May 12, 2010
    1 reply
  • To read records from excel file and the limit Closed

    I am preparing the code to read the records from the excel worksheet and convert the .txt file of that worksheet.. If i run my program than a .txt fi...

    reenada | Latest reply: rizvisa1 May 12, 2010
    1 reply
  • Ignoring blank cells Closed

    I have a formula along the lines of..... =IF((a1=b1),1,0) How can i get the formula to ignore blank cells? Configuration: Windows XP / Interne...

    adamsalter | Latest reply: rizvisa1 May 12, 2010
    1 reply
  • Excel Date and Time issue Closed

    Hello All, I wanna subtract "12/05/10 08:29:25" from "12/05/10 08:48:31' . Please help me out. Thanks and Regards, Subramanyam T C, Bangalore.

    Mani | Latest reply: venkat1926 May 11, 2010
    1 reply
  • Search and Replace macro for microsoft excel Solved/Closed

    I have two workbooks with identical setup. item name address 1 address 2 address 3 x 12 34...

    Doyle1010 | Latest reply: rizvisa1 May 11, 2010
    3 replies
  • Excel Macro formula for groups of numbers Closed

    I have strings of numbers in a column (n) I need help with a macro that will total the groups with the sum in column (o) right of the last row of the ...

    Sandy | Latest reply: rizvisa1 May 11, 2010
    1 reply
  • Copying Specific Data Selection to new sheets Closed

    How can I select entire rows based on a specific value found in a column via a macro when the occurence of the specific value is variable? eg. My ...

    shevy | Latest reply: rizvisa1 May 11, 2010
    1 reply
  • Macro to make upper case lettersto lower..... Closed

    Please design a macro that will make the Name copied and pasted in all upper case, for example (KATIE) in the cell A1, when I run the macro I want KAT...

    ADIT | Latest reply: rizvisa1 May 11, 2010
    6 replies
  • Excel 2007 VBA #n/a Lookup Closed

    I have a sheet receiving imported data and sometimes it does not come in correctly so I use Vlookup to verify it against the correct code as part of a...

    Tjones4852 | Latest reply: rizvisa1 May 11, 2010
    1 reply
  • hide rows in multiple sheets Closed

    Please help me If I have data in range A1:D35 in every sheet of the 20 active sheets, so I want to write a macro to hide all the rows that have a z...

    philippos | Latest reply: rizvisa1 May 11, 2010
    3 replies
  • Excel - Unique Filtering Closed

    I have a two columns: Name and Amount. I want to apply a unique filter on the Name and retrieve the Sum of all the repeated Amounts. How do I do this...

    fnkhan111 | Latest reply: rizvisa1 May 11, 2010
    3 replies
  • Add cells with other identical attributes Solved/Closed

    I'm looking to create a formula which can be copied into other cells that will add numbers in one column, where their attributes in another column are...

    armatt | Latest reply: armatt May 11, 2010
    2 replies
  • [excel] Pastlink Closed

    Hi , could someone please help me with this problem I have . I need to pastlink values from sheet 1 columns A1 and column B1 ,column A2 and column B...

    Raveen | Latest reply: rizvisa1 May 11, 2010
    1 reply
  • Help with Excel data selection Solved/Closed

    I would like to take a worksheet and create new worksheets for each specific value in a column. for example, one of my columns is "customer". I want...

    shevy | Latest reply: rizvisa1 May 11, 2010
    1 reply
  • Excel formula problem Closed

    Hi there, Was hoping some one out there could help me with an excel formula problem... I have a Table ---- A B C ...

    Brujah | Latest reply: rizvisa1 May 10, 2010
    8 replies
  • Excel formula help!!!!!!! Closed

    I am doing a spreadsheet for a fishing league and would like to know eg: f6 h6 ...

    del | Latest reply: rizvisa1 May 10, 2010
    2 replies
  • Excel 2007 VBA Find Last Solved/Closed

    I have a mutipage workbook where I am coping information from three sheets and consolidating the information to another sheet so I can export into a c...

    Tjones4852 | Latest reply: rizvisa1 May 10, 2010
    1 reply
  • Combining data in Excel 2007 Closed

    I have a list of names on one worksheet (Sheet2). Doe, Jane Smith, Joe Hawthorn, Mya On a seperate tab in the same workbook I have another ...

    carstarr | Latest reply: rizvisa1 May 10, 2010
    1 reply
  • Excel Copy Cells Based on Condition Closed

    I have an Excel file with a list of contacts on the first sheet. This sheet is labeled "Master List". In column B of the Master List sheet I am putt...

    Rookie | Latest reply: rizvisa1 May 10, 2010
    1 reply
  • Macro to Find a info in more than one column Solved/Closed

    Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [t...

    AJ | Latest reply: rizvisa1 May 10, 2010
    13 replies
  • excel Closed

    hi... i am trying to do set formula one excel file to another file but it's not working.if i set formula same file but another sheet it's worked... i...

    milan | Latest reply: rizvisa1 May 10, 2010
    3 replies
  • Excel reset button Closed

    Hi all , I am using a form, inputting lots of data into many cells to get a quote, I wonder if there is a way of having a master reset button that ...

    Andy | Latest reply: rizvisa1 May 10, 2010
    5 replies
  • Help me for the following problem(Excel) Closed

    Dear All, I have an excel sheet which looks like following with the column header(part, Assembly,AVG) Part assembly AVG ...

    kanti | Latest reply: rizvisa1 May 10, 2010
    1 reply
  • Excel 07 to excel 03? Closed

    Configuration: Windows Vista / Firefox 3.6 So I have multiple files I created on my new win7 os.... doing the work at home instead of at the job. N...

    jwchef013 | Latest reply: rizvisa1 May 9, 2010
    1 reply
  • Sorting Dates using Excel / VBA Closed

    Configuration: Windows XP / Firefox 3.6 Hello All, Just wondering if you can help me in writing VBA sorting logic for Date in asc or dsc order....

    kuldeps | Latest reply: rizvisa1 May 9, 2010
    5 replies
  • Excel query Closed

    Hello, I have a query. Whenever I export a file from internet the data gets saved into a new excel file instead of the excel sheet I am working i...

    tans | Latest reply: sunil May 9, 2010
    10 replies
  • Excel frame a Do While Loop or macro Solved/Closed

    Hi All, Could anyone help me to frame a Do While Loop or a suitable macro? I need a method to copy formulas present in Cells F10 to Q10 in She...

    madambath | Latest reply: madambath May 9, 2010
    13 replies
  • Excel Macro to select the latest date Closed

    Hi, I have a excel sheet with 6 sheets (1,2,3,4,5,6). The macro for the excel sheet would select all the rows with status 'In Progress' in column P...

    Sachin | Latest reply: rizvisa1 May 9, 2010
    5 replies
  • excel date format to be change Closed

    WOULD LIKE TO CHANGE THE DATE 07.05.2010 TO 07-05-2010 FORMAT

    charles | Latest reply: rizvisa1 May 8, 2010
    1 reply