Office Software Forum - solved topics

Ask a question
Search
Close
Results 251 - 300 of about 2,650
  • Solved
  • Adding days to a date based on drop down menu Solved/Closed

    Column D shows Date Enrolled, Column E shows Experience (options are more than 1 year or Less than 1 year) I would like column F to add 35 days if "Le...

    mlip | Excel | Latest reply: mlip Aug 25, 2018
    0 replies
  • MACRO to copy / paste cell text down various rows Solved/Closed

    Hello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...

    debtiger99 | Excel | Latest reply: TrowaD Aug 14, 2018
    6 replies
  • MACRO submit data drop to next row upon submission Solved/Closed

    Hello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the comma...

    BMiller58 | Excel | Latest reply: vcoolio Aug 11, 2018
    11 replies
  • Recalculation Solved/Closed

    Hi friends I need your help to do an operation. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. ...

    endoox | Excel | Latest reply: endoox Aug 9, 2018
    4 replies
  • Making my macro independent on future Sheets Solved/Closed

    Hello All; 1st time posting anything so please bear with me. I really need some help and have going out of my mind for days with what I believe is...

    rizzob95 | Excel | Latest reply: vcoolio Aug 2, 2018
    7 replies
  • Outlook syncing/sharing. Solved/Closed

    Hi All, Do we have any Outlook gurus here? Something I've never had to do before, and dont know how to start - even google searches arent helpful a...

    BrianGreen | Outlook | Latest reply: Ambucias Jul 29, 2018
    15 replies
  • Making formulas work, which work on other computer Solved/Closed

    Hello, My boss is using a large spreadsheet with multiply formulas in and has been using it for quite a while, updating the figures as and when ne...

    Hoffy | Excel | Latest reply: ac3mark Jul 25, 2018
    3 replies
  • Removing a 'FALSE' result Solved/Closed

    Hello, In the following formula, I am getting a 'FALSE' as opposed to a '0' result. =IF((F28+F31)

  • Multiple IF statements in Excel Solved/Closed

    Hello, I am trying to calculate a cell based on values , so if A1 =between 1 to 10 than it will equal 10.00 if A1 = between 11 to 20 that it e...

    nesto2008 | Excel | Latest reply: Nesto2008 Jul 17, 2018
    2 replies
  • Highlighting future dates Solved/Closed

    Hi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...

    Hoffy | Excel | Latest reply: Hoffy Jul 13, 2018
    4 replies
  • Copy rows to other sheets based on value in column Solved/Closed

    Hello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...

    Need_2Know | Excel | Latest reply: Need_2Know Jul 13, 2018
    2 replies
  • Make userform Solved/Closed

    Hello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...

    Immortal | Excel | Latest reply: ac3mark Jul 9, 2018
    1 reply
  • VBA code for copy & paste items for multiple times Solved/Closed

    Hi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...

    andrewhu91 | Excel | Latest reply: andrewhu91 Jul 3, 2018
    4 replies
  • Create sheets for additions to list on sheet one. Solved/Closed

    I have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...

    Michelle | Excel | Latest reply: TrowaD Jul 2, 2018
    9 replies
  • Overwriting data during transfer Solved/Closed

    Sir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...

    MUKUL_1308 | Excel | Latest reply: MUKUL_1308 Jul 2, 2018
    3 replies
  • VBA code for command button Solved/Closed

    hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...

    MUKUL_1308 | Excel | Latest reply: MUKUL_1308 Jun 20, 2018
    4 replies
  • How can I separate each slides from one PPT file? Solved/Closed

    Hi Everyone. I have a powerpoint file(Power point 2016) which has 100 page(slides). What I want is to automatically separate each slide to create ...

    DenizSea | PowerPoint | Latest reply: Ambucias Jun 5, 2018
    5 replies
  • When the field is =N, want to subtract that field Solved/Closed

    Hello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work? =(COUN...

    JBALLEST | Excel | Latest reply: ac3mark May 31, 2018
    3 replies
  • Conditional formatting across multiple columns Solved/Closed

    Hi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) an...

    wolfy1s13 | Excel | Latest reply: wolfy1s13 May 28, 2018
    2 replies
  • Copy conditional formatting for an entire row based on one cell Solved/Closed

    Hello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in t...

    Maurits Kvåle | Excel | Latest reply: guest May 17, 2018
    23 replies
  • Duplicate rows from multiple worksheets Solved/Closed

    Hello, I have a workbook that I'm hoping will be the template for a monthly log. It is almost done, but I cannot figure out the best way to perfor...

    iksta | Excel | Latest reply: vcoolio May 8, 2018
    8 replies
  • Excel "IF" function w/ date in test cell Solved/Closed

    Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...

    Mike in PA | Excel | Latest reply: salim Apr 29, 2018
    6 replies
  • Change color for specific number of cells by value Solved/Closed

    I have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each r...

    ChrisK | Excel | Latest reply: TrowaD Apr 19, 2018
    3 replies
  • Auto populate from master file to other Solved/Closed

    Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...

    MohamedGhouse | Excel | Latest reply: TrowaD Apr 19, 2018
    7 replies
  • Auto create info sheets from master spreadsheet Solved/Closed

    UPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My remaini...

    wbarn17 | Excel | Latest reply: ac3mark Apr 16, 2018
    3 replies
  • Microsft Word icon is gone. Solved/Closed

    Hello, I have a question. Until recently there has been a Micorosft icon on my desktop and it showed up under the "All Programs" list on my Start ...

    Nate | Word | Latest reply: Schly Apr 9, 2018
    44 replies
  • Convert PDF to Word without altering PDF images Solved/Closed

    Can converting from PDF to word be done without alterations of the PDF images?

    volunteer33 | PDF | Latest reply: Ceemaru Apr 6, 2018
    2 replies
  • Use in Scripting.Dictionary- item join string 3col Solved/Closed

    Hello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of-the-sa...

    mokie1 | Excel | Latest reply: mokie1 Mar 28, 2018
    1 reply
  • How to change date format from yyyymmdd to mm/dd/yy in Excel? Solved/Closed

    Hello, I have data with dates arranged in yyyymmdd format. Is there an easy way to change the format to mm/dd/yy in Excel 2010? Thanks!

    lmw | Excel | Latest reply: Sf Mar 28, 2018
    12 replies
  • How can I automatically copy table to next sheet? Solved/Closed

    Hello, I have an Excel file with 30 sheets containing the same table. In the table, the last column is a Yes/No (using data validation). Once a d...

    DanielOfir15 | Excel | Latest reply: vcoolio Mar 28, 2018
    13 replies
  • Change date format dd.mm.yyyy to dd/mm/yyyy Solved/Closed

    Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently Shatrughna System Configuratio...

    shatrughna | Excel | Latest reply: Ray Mar 26, 2018
    47 replies
  • Excel partial match Solved/Closed

    Hello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some ...

    machoman4lyf | Excel | Latest reply: machoman4lyf Mar 25, 2018
    6 replies
  • Convert number to spelling Solved/Closed

    Hello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) = Fifty ...

    Sukumar | Office Software | Latest reply: mrwagh85 Mar 22, 2018
    28 replies
  • Transfer data from 1 sheet to another with cond. Solved/Closed

    Hi, I am having trouble working out how I would code this using VBA: In Sheet 1 I have 2 rows. The first row is the title and then the second ro...

    Kate.K22 | Excel | Latest reply: vcoolio Mar 21, 2018
    3 replies
  • Macro to manipulate lines of text Solved/Closed

    I have data that is arranged as this in four columns x emailx nameofx 123 x emailx nameofx 4456 x emailx nameofx 67 y emaily nameofy 12 z email...

    yuenja | Excel | Latest reply: TrowaD Mar 20, 2018
    26 replies
  • Find and replace from a dropdown Solved/Closed

    hi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel file...

    DG83 | Excel | Latest reply: DG83 Mar 19, 2018
    2 replies
  • How to easily cummulate data Solved/Closed

    Hi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, wee...

    DG83 | Excel | Latest reply: Mazzaropi Mar 17, 2018
    3 replies
  • How to add 200 working days to a given date. Solved/Closed

    Hello, Please I want to know how I can add 200 working days to a specific date to get a new date

    Bebs | Excel | Latest reply: Mazzaropi Mar 1, 2018
    3 replies
  • Auto populate data between Excel sheets Solved/Closed

    Have project management data that should be automated to populate from two Excel sheets to the desired Excel sheet. I was thinking that it could be A...

    Excelerator663 | Excel | Latest reply: Excelerator663 Feb 28, 2018
    3 replies
  • Cannot change the date format in Excel 2007 Solved/Closed

    Hello, I have tried everything mentioned in this forum and they still do not work. I have a sheet with the date appearing dd/mm/yyyy, I have ...

    Shayon | Excel | Latest reply: Roja Feb 27, 2018
    25 replies
  • Excel lookup 2 cells to match in 2 rows. Solved/Closed

    Hello, I am using Excel to makes archives of PC issues we have in our compagny I have Info that i have to write in two cells that are standard...

    tyraxor | Excel | Latest reply: mm Feb 22, 2018
    11 replies
  • Row conditional formating in Excel Solved/Closed

    Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text....

    christossol | Excel | Latest reply: Mazzaropi Feb 22, 2018
    3 replies
  • Highlight Help Solved/Closed

    Hello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needi...

    DarickParson | Excel | Latest reply: Mazzaropi Feb 14, 2018
    3 replies
  • Counting sites visits within a year Solved/Closed

    Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits ...

    christossol | Excel | Latest reply: Mazzaropi Feb 13, 2018
    5 replies
  • How to apply conditional formatting Solved/Closed

    I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and unhighligh...

    smith145 | Excel | Latest reply: smith145 Feb 8, 2018
    4 replies
  • How to copy data to a different worksheet? Solved/Closed

    Hello, I would like to copy data from a specific cell of a worksheet and paste into a specific cell in a different worksheet Eg from cell b2 of a l...

    hanshylkema | Excel | Latest reply: vcoolio Feb 7, 2018
    11 replies
  • Conditional Formatting - Dates Solved/Closed

    Hello, On a spreadsheet, the cells in column N contain a date. I need any date that is 6 weeks ago or longer to be highlighted. How do I do ...

    BethanMary4 | Excel | Latest reply: BethanMary4 Feb 6, 2018
    4 replies
  • Rearrange multiple columns in four columns, VBA Solved/Closed

    Hello guys, An excel rookie needs the help of more experienced users of Excel and VBA. I have a data set that looks the following way: There ...

    eguzun | Excel | Latest reply: ac3mark Feb 5, 2018
    1 reply
  • Matchpoint score Solved/Closed

    hello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points acc...

    whatsit | Excel | Latest reply: Mazzaropi Feb 5, 2018
    5 replies
  • Can't reinstall Office 2010 Solved/Closed

    Can't reinstall Office 2010. Always get a notice that an error has happened and it will not install !