Excel Forum - solved topics

Ask a question
Results 501 - 550 of about 1,710
  • Solved
  • Excel VBA to open a EULA script when opening a spesific workbook Solved/Closed

    Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...

    DataRV | Latest reply: vcoolio Jun 2, 2016
    3 replies
  • Copy all Rows with specific Name to new Sheet Solved/Closed

    Dear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL - NOR...

    Somanrajan | Latest reply: vcoolio Jun 1, 2016
    15 replies
  • macro that will allow tab 1 's information to be copy to tab 2 Solved/Closed

    Hello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, co...

    HappyPerson | Latest reply: HappyPerson May 28, 2016
    2 replies
  • transfer a row of data from one sheet to another same workbook Solved/Closed

    Hello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me thanks...

    Jess123! | Latest reply: vcoolio May 28, 2016
    25 replies
  • Convert number to letters in Excel Solved/Closed

    Hello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the letters. ...

    milindvc | Latest reply: hachiya May 27, 2016
    25 replies
  • Convert date of birth into words Solved/Closed

    Sir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one

    prakashdnl9 | Latest reply: vcoolio May 27, 2016
    1 reply
  • Automatically moving data Solved/Closed

    Hello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...

    Matt3502 | Latest reply: vcoolio May 27, 2016
    22 replies
  • location master file in excel Solved/Closed

    I have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...

    Param | Latest reply: ac3mark May 24, 2016
    1 reply
  • If Statements Solved/Closed

    Hello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...

    Aztec | Latest reply: ac3mark May 23, 2016
    1 reply
  • Verifing-Vin Numbers Solved/Closed

    Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...

    AndreOrion | Latest reply: AndreOrion May 16, 2016
    4 replies
  • formula that searches in a row for a cell/column that contains Solved/Closed

    Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...

    Zellie | Latest reply: Zellie May 12, 2016
    2 replies
  • Error in VBA Solved/Closed

    Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...

    Newmie2013 | Latest reply: Newmie2013 May 11, 2016
    1 reply
  • Replace function in Macro Solved/Closed

    Hello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...

    smuneeb | Latest reply: TrowaD May 10, 2016
    6 replies
  • Securing a Excel Workbook Solved/Closed

    Hey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...

    Newmie2013 | Latest reply: Newmie2013 May 10, 2016
    2 replies
  • Copying function using VBA Solved/Closed

    Hello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...

    Newmie2013 | Latest reply: Newmie2013 May 10, 2016
    5 replies
  • copy formulas from one sheet to another all at once Solved/Closed

    Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...

    Mflores81 | Latest reply: vcoolio May 4, 2016
    2 replies
  • Excel Doubt - IF Formula Solved/Closed

    Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...

    Joao Brito | Latest reply: Joao Brito Apr 29, 2016
    3 replies
  • add worksheets to excel workbook using count defined name Solved/Closed

    Hello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...

    raungst98 | Latest reply: raungst98 Apr 27, 2016
    2 replies
  • Changing font color in one cell when % in another cell changes Solved/Closed

    Hello, I have a balance in B1 of what's owed on my credit card. I have the % of use on that card in D1, IE 35%. I want the font color to change ...

    abqjukebox | Latest reply: abqjukebox Apr 22, 2016
    0 replies
  • Text format to date/month/year on excel Solved/Closed

    Hello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...

    Cheryl | Latest reply: ExcelNewbie Apr 22, 2016
    20 replies
  • I want to retrieve value from multiple sheets of same workbook Solved/Closed

    Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...

    Gokuneo | Latest reply: Mikkelo Apr 22, 2016
    9 replies
  • Copy range data in a column to new column. Solved/Closed

    Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...

    anthonyishere | Latest reply: anthonyishere Apr 21, 2016
    6 replies
  • Compare two columns Solved/Closed

    Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...

    kumar | Latest reply: kumar Apr 21, 2016
    2 replies
  • Transfer an entire row from one sheet to another Solved/Closed

    Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...

    JC | Latest reply: vcoolio Apr 20, 2016
    5 replies
  • Add to Excel Macros Solved/Closed

    Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...

    Victoria | Latest reply: vcoolio Apr 20, 2016
    6 replies
  • Protected worksheet Solved/Closed

    Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...

    whatsit | Latest reply: whatsit Apr 18, 2016
    2 replies
  • Copy row only if one cell's value is not 0 Solved/Closed

    I would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!

    victhor1977 | Latest reply: vcoolio Apr 18, 2016
    3 replies
  • A variation on the compare 2 columns in Excel Solved/Closed

    Guys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...

    BrianGreen | Latest reply: BrianGreen Apr 13, 2016
    2 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
  • 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
  • Check if there is a match to a cell in the rest of the workbook Solved/Closed

    Hello, I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that...

    Ixon | Latest reply: Ixon Apr 11, 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • transfer data between sheets in excel Solved/Closed

    Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...

    rodney hughes | Latest reply: Anonymouse Mar 16, 2016
    19 replies
  • Compare values of two separate sheets and returning value Solved/Closed

    Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...

    Camron | Latest reply: ac3mark Mar 15, 2016
    3 replies
  • Recording Macro To Duplicate Page And Rename To Numeric Value Solved/Closed

    Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...

    Shaun@1 | Latest reply: Shaun@1 Mar 15, 2016
    2 replies
  • Need to find a data in a column and copy below cell data or add Solved/Closed

    Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................

    hirdesh_saxena | Latest reply: hirdesh_saxena Mar 14, 2016
    2 replies
  • count days in excel Solved/Closed

    Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...

    Filippos | Latest reply: Banjo Mar 11, 2016
    18 replies