Office Software Forum

Ask a question
Search
Close
Results 2051 - 2100 of about 16,500
  • Copy rows into sheets depending on a condition in one column Closed

    Hi, This thread has been really helpful. The first part of my code works and copies data that includes the term "EMAS" into the appropriate sheet. Ho...

    Violet | Excel | Latest reply: ac3mark Jan 5, 2017
    1 reply
  • automatic copy paste Closed

    I want to copy same highlighted cells from one sheet to another ,for example sheet 1 contains a column with different highlighted colours now i want t...

    ayesha6 | Excel | Latest reply: ac3mark Jan 5, 2017
    1 reply
  • IF and IS TEXT or IS NOT Blank Solved/Closed

    Hello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...

    Jam | Excel | Latest reply: ac3mark Jan 5, 2017
    5 replies
  • Conditional Formatting range of date cells based on another cell Solved/Closed

    Hi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...

    cleaverr | Excel | Latest reply: cleaverr Jan 5, 2017
    7 replies
  • ExcelVBA-Find a listed Keyword & move entire string to the Sheet Closed

    Hello and greetings CCM Expert team. May I request you to kindly help me with the following request: 1. Looking-up a Keyword [one-by-one] from a pre...

    ajaydwivediji | Excel | Latest reply: ajaydwivediji Jan 5, 2017
    0 replies
  • i have a problem in match function Closed

    Hello, i want to ask u that if i have a text in one cell and i want to match more than one text from cell.for ex. cell contains(buy now this is a spa...

    upasana | Word | Latest reply: ac3mark Jan 4, 2017
    1 reply
  • Compare 2 excel documents and find the same data in both sheets Closed

    Hi I have 2 separate excel documents, 1 which had 2015/2016 data and the second which has 2014 data. What i need is to compare the 2 documents for m...

    ULAB2017 | Excel | Latest reply: xpcman Jan 4, 2017
    1 reply
  • wifi connected but no internet access Closed

    Hello, wifi conected but o inetrnet access Configuration: Windows 7 / Chrome 55.0.2883.87

    tricia | Outlook | Latest reply: ac3mark Jan 4, 2017
    1 reply
  • See which names are duplicates Closed

    Hi, I have a massive list of about 12,000 names and then another list of about 1000 names, formatted in different columns such as First Name | Las...

    sam123 | Excel | Latest reply: yg_be Jan 4, 2017
    2 replies
  • convert number to word with currency Closed

    Hello, I wank to ask you guys about exel. I want to convert number to word with currency. Ex: 150.5 to One hundred USdollars and fifty cents. H...

    Exel?? | Excel | Latest reply: xpcman Jan 4, 2017
    1 reply
  • Search for a Keyword. Add Value from another cell. Solved/Closed

    I'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...

    adam73647 | Excel | Latest reply: adam73647 Jan 3, 2017
    2 replies
  • A IF(istext) formula that needs a trimming, please help? Solved/Closed

    Hello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...

    Bluntobject | Excel | Latest reply: TrowaD Jan 3, 2017
    1 reply
  • trying to drag the formula down it just copies the same Closed

    Hello, I am using the " proper" formula on my mac , but when trying to drag the formula down it just copies the same name ? Please help Confi...

    Sinead | Excel | Latest reply: TrowaD Jan 3, 2017
    1 reply
  • Conditional Formatting Closed

    Hello, I conditionally formatted cell D4 that it's color changes from white to red when value in A1 is increased from 1 to 100. Now, can I make E4 a...

    textshiva | Excel | Latest reply: textshiva Jan 2, 2017
    2 replies
  • Worksheets into Workbook Solved/Closed

    Dear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...

    Game Start Now | Excel | Latest reply: Game Start Now Jan 2, 2017
    2 replies
  • Text from two different cells to give value shown in certain cel Solved/Closed

    Hello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...

    fgadmin | Excel | Latest reply: fgadim Jan 2, 2017
    4 replies
  • VBA: Send last updated row via email Closed

    Hi, I am looking for a VBA excel code to capture the last updated row and notify me via email. Thanks for help. regards, SAS

    SheetalAS | Excel | Latest reply: SheetalAS Jan 2, 2017
    0 replies
  • Conditional Formatting for Word and Date Solved/Closed

    Hello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...

    Tiffanypoche | Excel | Latest reply: Mazzaropi Jan 1, 2017
    3 replies
  • Pasting multiple ranges from excel into powerpoint slide as link Closed

    Hello, I'm an absolute beginner in VBA. I'm using the code below to copy and paste multiple ranges into PowerPoint slides. Instead of copying and pa...

    angelunderwrap | Excel | Latest reply: angelunderwrap Jan 1, 2017
    0 replies
  • Macro that can scrape websites Closed

    Hello, I want to create a macro that can scrape clearance data from a retailers website. I basically want to know each week how many items are on cl...

    ska5765 | Excel | Latest reply: ska5765 Dec 31, 2016
    0 replies
  • Macro that will scrape emails Closed

    Hello, I want to create a macro that will scrape promotional emails I receive from retailers. I have a spreadsheet where I keep all the promotions i...

    ska5765 | Excel | Latest reply: ska5765 Dec 31, 2016
    0 replies
  • Macro that will copy/paste data each week Closed

    Hello, I want to create a macro in a master sheet that will copy last weeks data and paste in the rows below. Then I want it to open a sheet that th...

    ska5765 | Excel | Latest reply: ska5765 Dec 31, 2016
    0 replies
  • Auto copy and paste cell range to a separate sheet Solved/Closed

    Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...

    bnoboa | Excel | Latest reply: bnoboa Dec 30, 2016
    4 replies
  • Need to create multiple tabs based on data in table Solved/Closed

    Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...

    Kylana | Excel | Latest reply: vcoolio Dec 29, 2016
    6 replies
  • Copy cell from a column into multiple worksheets Closed

    Good Afternoon! I've got a column of data (Months) that I need to insert into a cell in multiple worksheets. I know if it was within one worksheet...

    KylanaG | Excel | Latest reply: KylanaG Dec 28, 2016
    0 replies
  • Return Value in Cell Address Closed

    Hello, I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that i...

    Pluh | Excel | Latest reply: Mazzaropi Dec 28, 2016
    1 reply
  • Compare Data Closed

    Hello, I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need ...

    crazybadri | Excel | Latest reply: Mazzaropi Dec 28, 2016
    5 replies
  • How To Copy Data Between Several Sheets using another sheet Closed

    Hi All, I have a requirement to copy the data from source to target using macro excel file name: Testbook1 Source sheets Target sheets Test_Src1...

    naresh117 | Excel | Latest reply: naresh117 Dec 28, 2016
    0 replies
  • how to delete misline rows one worksheet by using macro Closed

    Hello, how to delete misline cloums by using macro plz give me code.i hoping you give me answer.

    naveen | Excel | Latest reply: naveen Dec 28, 2016
    0 replies
  • Copy a range of cell x number of times Closed

    Hello, Friend my query is I want to copy value from range (E1:F1) Base on the value from G1 And paste on range from A1&B1. It should continue ...

    Jai | Excel | Latest reply: ac3mark Dec 27, 2016
    1 reply
  • transferring data from one sheet to another in Excel Closed

    I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...

    KKunard | Excel | Latest reply: vcoolio Dec 27, 2016
    2 replies
  • Excel changes field format from date to text when date entered. Closed

    I have an Excel worksheet that has a variety of formula's and conditional formating in it. There are four different date formated columns in the spre...

    dbjerke | Excel | Latest reply: dbjerke Dec 27, 2016
    0 replies
  • Lettering malfunction (appearance) Closed

    there is a problem with my LT in lettering appearance!

    Dr. Leone L.... | Outlook | Latest reply: ac3mark Dec 27, 2016
    1 reply
  • Popup Reminder Excel 2010 Closed

    I am completely new to VBA and do not really know how to manipulate a code. I was hoping someone would be willing to formulate the codes I need to i...

    mdeza81090 | Excel | Latest reply: vcoolio Dec 27, 2016
    1 reply
  • excel arrow keys are moving the entire spreadsheet Closed

    Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do no...

    kelvin | Excel | Latest reply: santa Dec 26, 2016
    1 reply
  • how to copy row to several sheets based on cell value Closed

    Hi Ladies and Gents i really hope i can get some help here and your patience and support is highly apreciated. i have a daily tracker for all daily ...

    MO | Excel | Latest reply: MO Dec 26, 2016
    0 replies
  • Find what is the number, that will make 2 cells ABS equal Closed

    Hey guys, I will appreciate your help on this. I'm trading on CFD's and trying to build something that will help me calculate different scenarios. ...

    albertask | Excel | Latest reply: yg_be Dec 25, 2016
    3 replies
  • Comparing and scoring 2 workbooks for students quiz Closed

    Hi all I am teaching students basic Excel skills and they have a quiz to do where they do certain basic tasks on a spreadsheet. I have a workbook wi...

    harryarnold | Excel | Latest reply: harryarnold Dec 25, 2016
    0 replies
  • Delivery date should be change in one word DELIVERED Closed

    Hello, Is there any formula that we can change delivery date into just one word "Delivered" Configuration: Windows 7 / Chrome 55.0.2883.87

    azzuslove1017 | Word | Latest reply: azzuslove1017 Dec 25, 2016
    0 replies
  • function in excel 2013 Solved/Closed

    Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...

    Saber Elajam | Excel | Latest reply: yg_be Dec 24, 2016
    1 reply
  • find what is the number, that will make 2 cells ABS equal Closed

    Hey guys, I'm trading on CFD's and trying to build something that will help me calculate different scenarios. As you can see on the file attached, I...

    albertask | Excel | Latest reply: albertask Dec 24, 2016
    0 replies
  • sum if.. it think? Closed

    Hi, I have a column of cells that may contain either a 1 or 2 or.5 I need to add the column together and get a 1 to equal 15min, 2 to equal 25min a...

    Beckstar11 | Excel | Latest reply: Beckstar11 Dec 23, 2016
    0 replies
  • Copy all data from 2 worksheets into summary, excluding headings Closed

    Hello, I would like to automatically copy the entire rows of 2 different worksheets (excluding the top 3 header rows) into one complete summary work...

    MMEP | Excel | Latest reply: MMEP Dec 22, 2016
    0 replies
  • How to compare data between two worksheets, Closed

    Hi I have "sheet A", and "sheet B". I need to match the information in sheet A with sheet B and select the information needed from sheet B and writ...

    luislugosan | Excel | Latest reply: luislugosan Dec 22, 2016
    0 replies
  • macro to create a new sheet by copying a template from a list Closed

    i have two sheets one is "profile" and second is "template" . this second sheet has a defined layout. in the first sheet i.e profile sheet contains a...

    natarajk | Excel | Latest reply: natarajk Dec 22, 2016
    0 replies
  • creating different sheets in same workbook from master sheet Closed

    Hello, I have data in master sheet from Column A to Column L and about 17,000 rows. Column H contains the name of the sales persons. I have to cre...

    Nabeel | Excel | Latest reply: TrowaD Dec 22, 2016
    1 reply
  • how to spell in euro Closed

    Hello, Dear sir / Madam I apologise for my latest message. I need your help concerning the formula to spell in figures that is euro 7000. Which for...

    RAVIN | Excel | Latest reply: TrowaD Dec 22, 2016
    3 replies
  • Any faster version of the same code to handle 5000+ records Closed

    Hello, May i plz get a faster code for the same? currently for around 5000+ records this code takes around 10 minutes... i.e. Match all the cellva...

    upan275 | Excel | Latest reply: Smallman1 Dec 21, 2016
    15 replies
  • Nested IF functions using time values Solved/Closed

    Hello, can someone tell why this wont work. The time value functions work separately on their own, and I followed the excel help for nested if func...

    SharkMerry | Office Software | Latest reply: Harshada Chaudhari Dec 21, 2016
    5 replies
  • Moving information from one table to another Closed

    I need to move data from one table to another, then loop back through until all the information has been moved, I suck at vba code etc... can any...

    karlkeegan | Excel | Latest reply: ac3mark Dec 20, 2016
    3 replies