Excel Forum

Ask a question
Results 6201 - 6250 of about 9,850
  • VBA to protect sheet in excel Closed

    Hello, I need any help if some one can help me. I make an overtime sheet in excel that allow the employee to fill in the date and time only and i...

    issa | Latest reply: TrowaD Mar 5, 2012
    12 replies
  • [Excel] Macro on Grouping Closed

    Hello, I need help on developing a macro on grouping a set of negative amount & quantity against a set of positive amount & quantity. Using positi...

    justoneG | Latest reply: justone Mar 4, 2012
    5 replies
  • Using VBA code: add Borders if Conditions Met Closed

    Hello, I am at the very beginning stages of trying to learn VBA in Excel 2007. I am trying to merge some cells in the next row, and I would...

    Josh | Latest reply: Josh Feb 29, 2012
    1 reply
  • VBA copy/paste cells then drop 1 row for next Solved/Closed

    Hello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...

    shannon | Latest reply: shannon Feb 29, 2012
    2 replies
  • calculations date & time in excel Closed

    Hello, I used office 2003. In excell 2003 i formatted cells to dd hh:mm from dd/mm/yy hh:mm, in order to do calculations and it was ok. Now i...

    seraton | Latest reply: pcsces Feb 29, 2012
    1 reply
  • Textbox on Excel Uerform Problem Closed

    I have a userform with several textboxes on it. The info that is typed into the textbox is copied into a cell in a spreadsheet where it is used to per...

    mike0123m | Latest reply: pcsces Feb 29, 2012
    1 reply
  • Microsoft Excel 2010 Closed

    Hello, I would like to figure out how to get a web address that I use to get data from the internet to always use the date that I put in cell A1. Any...

    trouble in T... | Latest reply: RWomanizer Feb 29, 2012
    3 replies
  • Excel Formula Help Please Closed

    Hello, I have only worked with formulas when working with numbers but I need to know what formula I can use. I need a formula to take a column that ...

    Tammy | Latest reply: TrowaD Feb 28, 2012
    1 reply
  • Excel 2007 filter bringing back last row Closed

    Hello, When I apply the filter option for a particual item, the last row of the data is being displayed even though it does not match the criteria. ...

    Lee | Latest reply: venkat1926 Feb 27, 2012
    1 reply
  • multiple sheet data in one sheet in excel Closed

    Hello, Want to copy data from multiple sheet from multiple columns in one workbook can you please help me with that macro as well Pran...

    pranjali | Latest reply: TrowaD Feb 27, 2012
    4 replies
  • Excel macro - copy data from one line, append Closed

    Hello, I have a spread sheet created from a PDF to XLS program. I have lines in which the address appears on two lines, with the extra text fallin...

    OKBigKid | Latest reply: OKBigKid Feb 26, 2012
    2 replies
  • excell delete row where column A = column B Closed

    Hello, This should be simple but I can't find the solution. I need to delete rows from a spreadsheet where column A = column B. Please help. ...

    sipherx | Latest reply: aquarelle Feb 24, 2012
    3 replies
  • Excel Formula Closed

    Hello, I am working on log spreadsheet. The concept is to keep a log of all of our near miss activities at work like a broken chair that needs to ...

    Help | Latest reply: TrowaD Feb 23, 2012
    1 reply
  • Excel Help Closed

    Hello, I'm trying to set a formula in below way, but it doesn't work, why?ould u plzz help? =IF(J10="Safari 4.5",650,IF(J10="Safari 7",850,IF...

    Mizan | Latest reply: TrowaD Feb 23, 2012
    4 replies
  • Formula challenge for the Excel wizzards. PLEASE HELP Closed

    Hello, This might be a long explanation, but only because I want to be clear about the problem. I have 3 different Workbooks and the names are ...

    Confused1 | Latest reply: RWomanizer Feb 23, 2012
    1 reply
  • Excel 2010 formula/macro help Closed

    Hello, I'm hoping some of you excel wiz's can help me, I've been off the tools too long. Worksheet 1 Column A contains dates Column B contain...

    AJ | Latest reply: RWomanizer Feb 23, 2012
    1 reply
  • Excel Logic Closed

    Hello, I am trying to create a worksheet in excel that will allow me to add a certain amount if 2 conditions are met. So far I can only get it to a...

    Alex | Latest reply: RWomanizer Feb 23, 2012
    1 reply
  • Insert row in excel by criteria Closed

    Hello, Configuration: Windows XP / Firefox 10.0.2 I want to insert row in excel using formula because i have dates in the and there is da...

    sachin | Latest reply: pcsces Feb 22, 2012
    1 reply
  • Copying value to another worksheet Closed

    Hello, I am trying to copy a value for from one worksheet, do some math --> say I have three values that I want to subtract separately from cell i...

    NewToMacro | Latest reply: pcsces Feb 22, 2012
    1 reply
  • Excel conditional formatting row color Closed

    Hello, Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. ...

    veegerbee | Latest reply: pcsces Feb 21, 2012
    1 reply
  • Excel Macro - Create new files from ranges Closed

    Hi. I am trying to create a macro that will create new excel files for ranges of rows in a worksheet. I want to copy the range F5:S61 and paste i...

    Jiminie.Glick | Latest reply: Jiminie.Glick Feb 20, 2012
    3 replies
  • Enter sheet update other worksheet with text Closed

    Hello, Can anyone help me with this problem. I am updating leave availability , As soon as I enter the name in one worksheet the other workshee...

    -Prakshe | Latest reply: TrowaD Feb 20, 2012
    3 replies
  • How to determine cell value in Excel column Solved/Closed

    Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...

    Nick | Latest reply: Nick Feb 20, 2012
    4 replies
  • Macro - Sort Range Error Closed

    Hello, I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it...

    Ari | Latest reply: pcsces Feb 17, 2012
    1 reply
  • Worksheet_Change from a data validation list Closed

    Hello, I want my pivots to rebuilt when a value in range("Book_Select") is changed. This range is a drop down data valiation list. What is wrong w...

    JLeeD | Latest reply: aquarelle Feb 16, 2012
    1 reply
  • Comparing values of 1 excel cell with column Closed

    Hello, Please can you assist me with this excel formula? In sheet 1 I have business rules specified in column A and all the requirements that exe...

    Bhavin Kurwa | Latest reply: TrowaD Feb 16, 2012
    1 reply
  • Excel Macro Solved/Closed

    Hello, I wonder if anyone can help me with a small (I think) problem, please? I'm trying to write a macro to manipulate a spreadsheet sent to m...

    Macro Newbie | Latest reply: MacroNewbie Feb 16, 2012
    4 replies
  • Pull data from one tab/sheet to another Closed

    Hello, Configuration: Windows Vista / Internet Explorer 9.0 Reading all of these posts I get a lot of ideas, but since I am a novice at this ...

    Novice and N... | Latest reply: venkat1926 Feb 15, 2012
    1 reply
  • Hide rows without conditional formatting Closed

    Hello, I'm creating an Excel spreadsheet and want to give it a cleaner look by hiding the contents of a row based on the value of a cell in that ro...

    obsidian | Latest reply: Beverley Feb 15, 2012
    3 replies
  • Macro Help Closed

    Hello, I am new to VB and Excel. I've got the following code: I've got everything working fine, but need the entire row to change colors...

    LostandConfused | Latest reply: venkat1926 Feb 15, 2012
    1 reply
  • Excel search and save problem Closed

    Hello, I'm a total Excel noobie so I hope you can help me, I will try and be as brief as posible. Each week I will be getting an Excel CSV of 4...

    Sharon | Latest reply: TrowaD Feb 14, 2012
    1 reply
  • Excel Copying Columns Closed

    Hello, I have a spreadsheet for labor hours - Reg & OT columns per employee for 26 pay periods. I have the spreadsheet sorted by employee. Each ...

    Anna | Latest reply: Anna Feb 14, 2012
    0 replies
  • How to make secondary cells color of primary Closed

    Hello, Is there a way to make cells automaticaly change to the color I chose for another? Example: I decide to make cell A1 red. When I do this ...

    markhackney | Latest reply: TrowaD Feb 14, 2012
    1 reply
  • filter-cut-paste to other sheet Closed

    Hello, Could you please help me on this one, i have a data sheet and i want to filter then cut the data if the criteria is met (Adhoc,Chaser,Excep...

    JONAS | Latest reply: TrowaD Feb 14, 2012
    1 reply
  • compare cell a1 to entire A col in sheet2 Solved/Closed

    Hello, I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to ...

    Bill | Latest reply: Guest Feb 9, 2012
    7 replies
  • Excel problem Solved/Closed

    Hello, Hello, I am hoping that someone can help with the following problem, I have a list of numbers, golf staplford scores, located in cell...

    ptkdave | Latest reply: ptkdave Feb 9, 2012
    2 replies
  • Macros and histograms Closed

    Hello, I want to create a histogram on sheet2 while the data required is on sheet1 using a macro. everytime I try, it either says no data availabl...

    lufc66 | Latest reply: TrowaD Feb 9, 2012
    1 reply
  • Excel - copy data macro Solved/Closed

    Hello, I am currently learning the tricks in excel but have become stuck. I have created an expenses sheet where employees record various expenses...

    fazster | Latest reply: fazster Feb 9, 2012
    6 replies
  • transfer value between cells Closed

    Hello, i am maintaining attendance on daily basis per day per sheet. but sheet 1 contains only number of present on that day. how to auto up...

    r@j | Latest reply: pcsces Feb 9, 2012
    1 reply
  • excel question Closed

    Hello, I am trying to find out how to get the following working, I have a list of numbers located in cells D-AN, these random numbers are loaded we...

    ptkdave | Latest reply: pcsces Feb 8, 2012
    1 reply
  • Excel Macro-Pasting on next available row Closed

    Hello, I am having issues with my macro, I hope someone can help. I have a list, where I would like the macro to see if the value in Column J "Paid...

    tomris | Latest reply: TrowaD Feb 7, 2012
    1 reply
  • read data from one excel and write to other Closed

    Hello, I am a newbie. I am trying to find out if we can achieve the below scenario using macros. We have 2 excels in our case. Excel1 contain...

    pinky | Latest reply: TrowaD Feb 7, 2012
    1 reply
  • Copy the data from this sheet to other sheet Closed

    Hello, I have a problem about macro excel as: I have the data in file excel: Exam: Vendor account Date Invoice Due date Amount c...

    carrot_1985 | Latest reply: msweli Feb 7, 2012
    1 reply
  • Convert rows to cols Closed

    Hello, I have an example as below A cac 20 A dwp 22 B cac 15 B dwp 22 B erp 20 I want output as A CAC 20 DWP 22 B ...

    Krishna | Latest reply: venkat1926 Feb 7, 2012
    1 reply
  • Conditional Formatting Based on 2 cells Closed

    Hi, I want to use conditional formatting to highlight a whole row based on text in 2 different cells. For example: I have 10 columns and I need...

    diggity | Latest reply: venkat1926 Feb 6, 2012
    1 reply
  • Help with macro Closed

    hey folks i am trying to create a macro to copy lines of data to another worksheet baed on the original date meeting certain criteria I have a s...

    Yizzal | Latest reply: Yizzal Feb 5, 2012
    4 replies
  • how to move data in rows to columns Solved/Closed

    The data now is in the below format 1 2 3 9 15 16 20 25 1 This has to come in this format 1 2 3 9 15 16 20 25 1 ...

    Anitha | Latest reply: Ema Feb 4, 2012
    2 replies
  • If, then statement in Excel Solved/Closed

    Hello, This formula sounds easy to come up with, but I cannot figure it out. I'm trying to figure out how to add a certain amount of days to a dat...

    Kim | Latest reply: Fergie Feb 3, 2012
    4 replies
  • VBA code in excel to work for many sheets Closed

    Dears who can help me. I have excel file includes 30 sheets for different 30 employees. I have the following VBA code. Private Sub Worksheet_C...

    issa | Latest reply: aquarelle Feb 2, 2012
    1 reply
  • Copy data from one sheet to a master sheet Closed

    Hello, I have a worksheet, sheet1 where I enter the product code and it gives me the Bill of Materials for this product. I would now like to cop...

    Hemal | Latest reply: venkat1926 Feb 1, 2012
    1 reply