Excel Forum

Ask a question
Results 1751 - 1800 of about 9,870
  • Search for a word in a worksheet and return row Closed

    Hi, Hoping to get some help. I have a spreadsheet full of data in Sheet 1 from A1:AG159382. I would like to use a separate worksheet to search for...

    tina16marie | Latest reply: vcoolio Apr 13, 2016
    3 replies
  • If Then Formula Closed

    Hello, I am trying to build an If Then formula. I am trying to reference a cell with a specific text in one cell like A2=Light and only if Lights is ...

    The Glyde | Latest reply: vcoolio Apr 13, 2016
    3 replies
  • How to change word in cell using another word in another cell Solved/Closed

    Hello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...

    Cherietan | Latest reply: Cherietan Apr 13, 2016
    10 replies
  • copying macro Closed

    I want to write a macro where it groups my data by group # and copy the data of each group # into different sheets. Afterward, rename each sheets t...

    group123 | Latest reply: group123 Apr 12, 2016
    5 replies
  • IF Function Time Solved/Closed

    Hello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...

    Ashakil | Latest reply: Ashakil Apr 11, 2016
    2 replies
  • Copying an entire worksheet to another worksheet automatically Closed

    Hello, How can I automatically copy all data from one worksheet to another to include charts etc. Basically a copy of another worksheet tab. than...

    Andy | Latest reply: vcoolio Apr 9, 2016
    3 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • transfer data Solved/Closed

    Hello, Is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that wor...

    lynng | Latest reply: vcoolio Mar 27, 2016
    4 replies
  • Pop up reminder message in excel Closed

    Hi Guys, I'm just wondering if you would be able to assist me with this one, I have been trying to work this out myself but this is causing me a g...

    Blane | Latest reply: vcoolio Mar 25, 2016
    3 replies
  • How to calculate no of days between dates Closed

    Hello, How to calculate no of days between one constant date not written in excel sheet i.e. 31-03-2016 and other dates which is written in excel ...

    Trapti | Latest reply: Mazzaropi Mar 24, 2016
    1 reply
  • Hiding rows when validation list is changed Solved/Closed

    Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...

    Danny | Latest reply: tani Mar 24, 2016
    2 replies
  • Userform to export data to another sheet Solved/Closed

    Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...

    redbaby | Latest reply: redbaby Mar 24, 2016
    4 replies
  • counting and stop counting days in a cell Solved/Closed

    Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...

    diestra123 | Latest reply: diestra123 Mar 23, 2016
    4 replies
  • Match columns and assign a value from 3rd column Closed

    I have a list of ticket buyers from a recent event, including their zip code. I have a separate spreadsheet with every California zip code and it's...

    Jen | Latest reply: Coley925 Mar 22, 2016
    1 reply
  • Excel userform question Closed

    Hello, I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I...

    lmeyer13 | Latest reply: TrowaD Mar 22, 2016
    1 reply
  • vlookup formula help please Solved/Closed

    =IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...

    redbaby | Latest reply: redbaby Mar 22, 2016
    6 replies
  • VBA Excel 2013 Pleae Help Closed

    Hello, My question is and if this can be done. Say I have a date entered 3/15/2016 and have information in my excel file. Then I have to enter a...

    Scott T | Latest reply: Nado2oo2 Mar 22, 2016
    2 replies
  • How do i get the sales tax to pop up??? Closed

    Hello, how do I make it so I cant type in a city and have it so the sales tax automatically inserts itself in? Thank you Configuration: Windows...

    mgamble1990 | Latest reply: Coley925 Mar 22, 2016
    1 reply
  • Conditional formatting one cell based on another excel 2016 Closed

    Hello, I want to conditionally format one cell in a row based on another cell in the row. i.e. If cell F1 has a value greater than 2009 I want cel...

    kd | Latest reply: TrowaD Mar 21, 2016
    1 reply
  • Need a formula to sum a column with #Value error Solved/Closed

    I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.

    redbaby | Latest reply: redbaby Mar 21, 2016
    2 replies
  • auto copy/paste data if criteria (same value in 2 cells) is met Solved/Closed

    Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...

    JensBCN | Latest reply: JensBCN Mar 20, 2016
    1 reply
  • Creating a macro that will create a new sheet and copy data from Closed

    Hello, I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create...

    Susan | Latest reply: vcoolio Mar 19, 2016
    3 replies
  • Duplicating data from one line on sheet 1 to sheet 2 Solved/Closed

    Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...

    Buford | Latest reply: vcoolio Mar 19, 2016
    6 replies
  • display a range of cells if a condition (text) is met Closed

    well, i am regular for excel. now i need a help, if a cell value, is a particular text, then i want to display a range of cells at a particular loc...

    BEKNAL | Latest reply: TrowaD Mar 17, 2016
    1 reply
  • colour changing in rows determined by text in 2 different cells Solved/Closed

    Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...

    kitchens | Latest reply: TrowaD Mar 17, 2016
    1 reply