Excel Forum

Ask a question
Results 2601 - 2650 of about 9,840
  • changing font colour in a range based on conditions in another Closed

    Many thanks for the answer provided so far. But what I actually want have not been solved. For example if any cell value in the range D4:D40 is betwee...

    marshal | Latest reply: marshal Apr 8, 2016
    0 replies
  • How to make Macro Repeat Closed

    Hello, I am trying to run a macro where I multiply a range (B3: B615) by a number (B2). The problem is I want to do this for every column in my wo...

    Fred | Latest reply: ac3mark Apr 8, 2016
    1 reply
  • Changing font colour in a range based on criteria in another Closed

    Hello, I am trying to change the font colour in a range of cell based on conditions i set in another range of cell. How do i go about it, its giv...

    Marshal | Latest reply: ac3mark Apr 8, 2016
    1 reply
  • Relating today to other dates Closed

    Hello, =IF(M38>=A197;(M38);(O38)) M38 - date for the first payment A197 - =Today() O38 - date for the second payment What I wanted with th...

    Carolina | Latest reply: vcoolio Apr 8, 2016
    1 reply
  • Macro needed Closed

    Hi, I am a complete novice and have never written a macro before. I have an excel workbook with 1 worksheet called 'VOID MASTER' , I would like a macr...

    nadge1974 | Latest reply: vcoolio Apr 8, 2016
    1 reply
  • Run-time error '1004': Closed

    Hello, First of all I am not a programmer so am very new to macros. I have used the TwoSheetsAndYourOut macro which works in general workbooks ...

    Nei | Latest reply: Nei Apr 7, 2016
    0 replies
  • cell data xfer between files Closed

    Hello, I have two files in separate folders. I want to transfer data from one cell into a cell in a file in a separate folder. If I put = in the mas...

    billybob | Latest reply: billybob Apr 7, 2016
    0 replies
  • Excel: comparing two columns and their rows Closed

    Help! Here's what I'm trying to do: take a value in the N column of TABLE A, match it to the AB Column of REFERENCE TABLE B; then once that match ...

    CJMartin | Latest reply: CJMartin Apr 7, 2016
    0 replies
  • Fill color of one cell based on contents of another cell Closed

    Hello, I'm using office 2010.. how do i make one cell change color by adding an indicator in another cell... For example..when i put an x in a cell ...

    DPACK | Latest reply: Mazzaropi Apr 7, 2016
    1 reply
  • If condition Closed

    Dear Freinds I need your help for below requirement. I have 3 columns. Column contains text like Wk1, Wk2, Wk3. Column 2 and 3 contains numeric va...

    Karthikeyan1207 | Latest reply: Karthikeyan1207 Apr 7, 2016
    0 replies
  • Reminder Solved/Closed

    Friends Hi can anyone please help me? I need to set up a reminder in excel. I have a workbook containing a sheet that contains all our permits and in...

    lynng | Latest reply: vcoolio Apr 7, 2016
    7 replies
  • automaticaly transfer a line of information to another sheet Closed

    Hello, HI, I have a workbook that has 2 sheets, on sheet 1, I have 22 columns with different information, on sheet 2, I would like to automati...

    Rubel | Latest reply: ac3mark Apr 6, 2016
    1 reply
  • Filter data in a sheet from values in another sheet Closed

    Hello, I really hope someone could assist me as I am very new to Macro's/VBA and I have a requirement that needs coding. I have a sheet (Total)...

    MM13 | Latest reply: MM13 Apr 6, 2016
    0 replies
  • Changing values in a cell dependant on another Closed

    Hi guys, first time on here, i've gone through a few previous posts and found some helpful stuff, but still having trouble with something. I've ...

    NCMelb | Latest reply: NCMelb Apr 5, 2016
    0 replies
  • Stupefying differential result! Solved/Closed

    Hello, in the attached picture you can see that in cell E23 I inserted my budget and in cell E23 I inserted what I actually spent (the same amount) sh...

    j1969c | Latest reply: j1969c Apr 5, 2016
    4 replies
  • Open Excel files on my Mac Closed

    Hello, When I open any attachment that is a excel worksheet it goes to all the files in my documents?? help? Configuration: Mac OS X (10...

    sheila | Latest reply: sheila Apr 5, 2016
    0 replies
  • Excel - Repeat certain rows 4 times consecutively Closed

    Hello, I am a complete novice when it comes to excel so please bear with me. If I had a Data Base of lets say 1000 numbers (0001 to 1000) and...

    Grahamo | Latest reply: Grahamo Apr 5, 2016
    0 replies
  • Copy from multiple worksheets to a summary sheet Closed

    Hello, My name is Nelson, I recently came across your website and i am hoping that my problem can be solved. I am new to VBA. I want to loop th...

    Uzeenel | Latest reply: Uzeenel Apr 5, 2016
    0 replies
  • checking for type of day Closed

    I need excel to check =if a DATE = Monday, then, else EG; =if(a1=Friday,+a1+1,+a1) =if(a1=Sunday,+a1+1,+a1) I am trying to build a data base wor...

    vanyboy | Latest reply: vanyboy Apr 5, 2016
    0 replies
  • Not sure which formula to use? please help Closed

    Hello, I need a formula to work out the following: 30 meters = 7 squares 60 meters = 14 squares 90 meters = 21 squares etc etc so when I t...

    Bexster05 | Latest reply: ac3mark Apr 4, 2016
    1 reply
  • Test for quarter of year Closed

    How do I test for what quarter of the year a date is in?

    leebittinger | Latest reply: TrowaD Apr 4, 2016
    1 reply
  • Insert Lines & sequential numbers based on quantity Closed

    I have an order form with multiple macros including a macro to "Total" each order to show only the items and the quantity of each item that is ordered...

    Coley925 | Latest reply: TrowaD Apr 4, 2016
    11 replies
  • change mm/dd/yyyy in dd/mm/yyyy Closed

    Hello, i have 250+ entries in excel sheet in format mm/dd/yy i want to change all in 1 time in dd/mm/yy format how can I do it. advise me ...

    VISHNU | Latest reply: kieferschild Apr 4, 2016
    1 reply
  • Format two-level axis in stacked column chart using vba Closed

    Hello all, I have a stacked column chart with two-level axis. Please refer the image I want to make the first level axis (a,b,c) font size...

    Poojapriya | Latest reply: Poojapriya Apr 4, 2016
    0 replies
  • Copy conditional formatting- different version Closed

    Hello, I'm a novice, but have been getting by. The intent is to modify the text of a cell when ordering material, if we have that material already ...

    rathat76 | Latest reply: rathat76 Apr 3, 2016
    0 replies
  • Macro of reminder When Time in Particular cells orrurs Closed

    Hi, Can someone please help on this. I have daily excel to be mainteined in which client assigns me tasks and i need to approach them back withing...

    HARDIK99 | Latest reply: HARDIK99 Apr 2, 2016
    0 replies
  • Macro for Copy data and paste in all following blank cell Closed

    Hello, I am working on a data sheet with several columns. I need a macro that copies a value and keeps pasting it in the following rows till a ...

    sanjeet | Latest reply: sanjeet Apr 1, 2016
    0 replies
  • Macro Run time error 1004 Closed

    Hello, I want to write a macro to do the following: Automate an action so that when you select a content from a drop down list, it triggers content...

    HappyPerson | Latest reply: HappyPerson Mar 31, 2016
    0 replies
  • compare 1 date to several dates Closed

    Hello Excel Experts. Please bare with me as I am trying to use Excel and can't seem to figure out how to proceed and am hopeful yall will be able to...

    Rainbowman1 | Latest reply: Rainbowman1 Mar 31, 2016
    0 replies
  • Automatically transfer data Closed

    Hello, I am trying to automatically transfer data when entered on sheet 1 to sheet 2. Can you please explain how to do this?

    Denise | Latest reply: ac3mark Mar 31, 2016
    3 replies
  • Graphing gym membership over time Closed

    Hello, I have a spreadsheet with data on when certain people joined a gym, looking something like this: October 2011 May 2012 December 2012 Oc...

    Nora | Latest reply: ac3mark Mar 31, 2016
    1 reply
  • 1 to many compare Closed

    I am using Excel 2013. Have a multiple Projects (>1000), each project has a start date. Each project can have several Tasks (1 to many). Each Task ...

    Rainbowman1 | Latest reply: Rainbowman1 Mar 31, 2016
    0 replies
  • How to use Macro to generate different reports Closed

    Hello, I come across a question recently. I am hoping someone could help me. I work for a property management company with over thirty properties...

    Veronica | Latest reply: ac3mark Mar 31, 2016
    7 replies
  • convert number to word in excel Closed

    Hello, I want to write number but dont want to spell the the same in word please suggest the formula to convert the same. Ex:-6000 Six Thousand...

    Indronil | Latest reply: Ambucias Mar 31, 2016
    2 replies
  • Copy a cell value from most recent workbook from a folder Closed

    Hello, Dear .. i try to make a excel file for my shop here when i open my work book it should automatically update the cell value from a recen...

    vinokuranku | Latest reply: vinokuranku Mar 31, 2016
    0 replies
  • Dates written in different ways Solved/Closed

    Hello, I have a spreadsheet with dates written in different ways. August 2010 is written both August-10 and August 2010. How can I change this so ...

    Nora | Latest reply: vcoolio Mar 31, 2016
    3 replies
  • Excel Macro Help Closed

    I'm trying to figure out the VBA code or Macro to find the specific text of "AM2," in one column D and if it is there then replace it with the info fr...

    sgtmouse83 | Latest reply: Computertech Mar 31, 2016
    1 reply
  • Help Excel transfer/copy specific data from one sheet to another Closed

    I have this problem. I have this name and address on sheet 1, then i want to transfer or copy it from another sheet with differrent cell format. What ...

    sheaborque | Latest reply: sheaborque Mar 31, 2016
    0 replies
  • Count all cells containing a particular text Solved/Closed

    I am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An e...

    chemisecure | Latest reply: RayH Mar 30, 2016
    3 replies
  • Auto Populating Spreadsheets Closed

    Hello, I have a workbook; I want to place a $ amount for a certain type of light fixture and have it populate the amount in a certain column for onl...

    PEC | Latest reply: ac3mark Mar 30, 2016
    1 reply
  • Payment Transfer Closed

    Hello, I have a spreadsheet with the following columns on a sheet called PAYMENTS D=name E=date F=Payment G=ref# I also have addit...

    Michael T | Latest reply: vcoolio Mar 30, 2016
    2 replies
  • if formula question Closed

    Hello, i am trying to write a fomula so that if the text in one column 1 is a,b, or c, than the text in Column 2 is a,b, or c Configuration: Wi...

    Jim | Latest reply: RayH Mar 29, 2016
    2 replies
  • Column A has data return Column C Closed

    Hello, If Column A or Column B has a date in it then I need the info from Column C to appear in another column Column A Column B Column...

    Frustrated | Latest reply: Frustrated Mar 29, 2016
    0 replies
  • need only comapny name from email add Closed

    n excel sheet, i want only company name separately from email address column. Ex. from" mike@edwardstelecom.com " i want the company name i.e edwardst...

    sittanshu | Latest reply: TrowaD Mar 29, 2016
    1 reply
  • Removing "FALSE" from an IF statement with a VLOOKUP Solved/Closed

    Hello, I would like to remove the "FALSE" result I get when using my IF formula. The formula is a VLOOKUP that is looking at 2 different cells. ...

    RayRay | Latest reply: RayRay Mar 29, 2016
    2 replies
  • Calculating monthly attendance to percentage Closed

    i have a total of 8665 employees monthly attendance and i need to calculate that into percentage for the a month say for the month of March (31 days) ...

    DephyVIII | Latest reply: DephyVIII Mar 29, 2016
    0 replies
  • What is vba code to find if an active cell has a button over it? Closed

    Hello, In a column, i have a Macro Button for first row. I have programmed the Macro such that on pressing the Button, a data against the Empl...

    Shivam | Latest reply: Computertech Mar 29, 2016
    1 reply
  • Comparing Excel Closed

    I had a large excel file with multiple pages I was working on and computer shut down and created same file auto saved. I subsequently worked on one o...

    VPSC | Latest reply: VPSC Mar 28, 2016
    0 replies
  • How to bring searched columns copy and paste another sheet Closed

    Hello, I have set of data in sheet one. I have to search particular string in first row, if its found I need to copy that particular column and past...

    Aruna | Latest reply: Aruna Mar 28, 2016
    0 replies
  • Ask a question Message list Topic thread Forum list Report Macr Closed

    I tried the code and I getting a runtime error 9 on the following line Subscript out of range. lMaxRows_t = Workbooks(sBook_t).Sheets(sSheet_t).Cells...

    Lo2_35 | Latest reply: Computertech Mar 28, 2016
    1 reply