Office Software Forum

Ask a question
Search
Close
Results 3101 - 3150 of about 16,600
  • 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 | Excel | Latest reply: anthonyishere Apr 21, 2016
    6 replies
  • Counting between dates Closed

    Hello, I want to count the response to applications made to different organisations between set dates. In column C i use a simple 1 or 0 to indic...

    excelsimpleton | Excel | Latest reply: Zohaib R Apr 21, 2016
    3 replies
  • Word processing software Closed

    My computers have always come with word processing software already installed. I purchased one recently and it looks like there is none installed. I...

    marlay53 | Word | Latest reply: Marlay53 Apr 21, 2016
    2 replies
  • Find number in cell and return text in adjacent cell. Closed

    Hello, I'm trying to search a cell for a number, and if the cell contains a number I need to return a word in the next cell (the cell I am doing t...

    Apples | Excel | Latest reply: Apples Apr 21, 2016
    0 replies
  • What does this macro code mean? Closed

    Hey, The below macro was posted by another user, aquarelle, and is very useful for inserting copies of rows in an excel sheet. I tried asking them ...

    nbe9 | Excel | Latest reply: nbe9 Apr 21, 2016
    4 replies
  • How to copy Data from one excel sheet to another by criteria vba Closed

    I have data in Sheet1 and am trying to copy Range("A1:B8") from sheet1 to Sheet2 But while copying there are some condition Conditions are as foll...

    alex4611 | Excel | Latest reply: alex4611 Apr 21, 2016
    0 replies
  • Compare Fields Closed

    Hello, My name is Swapnil Veer. I have two sheets in excel. I have to compare two different columns in sheets and add respective entry in front of...

    Swapnil Arju... | Excel | Latest reply: Mazzaropi Apr 21, 2016
    1 reply
  • VBA group by code Closed

    Hi Everyone, I have data which looks like MANUFACTURER BRAND SEGMENT VALUE COLGATE Colgate BASE 500 COLGATE C...

    Sonal | Excel | Latest reply: Sonal Apr 21, 2016
    0 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 | Excel | Latest reply: kumar Apr 21, 2016
    2 replies
  • Counting number of times a value appears if.. Solved/Closed

    Hello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a cert...

  • PDF converter Closed

    Hi Greetings I need the PDF converter from any kind of file like word, Excel etc

    Apavad | PDF | Latest reply: Zohaib R Apr 21, 2016
    1 reply
  • 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 | Excel | Latest reply: vcoolio Apr 20, 2016
    5 replies
  • decrease in megapixels when converting? Closed

    Hello, For some reason my pdf files lower their quality only when I use the pdf creator. I open the pdf file with multiple pages with the pdf a...

    best jess | PDF | Latest reply: best jess Apr 20, 2016
    0 replies
  • Auto fill a Macro Closed

    Hello, I want to auto fill a macro button down column A, that copies the information from several cells to a different sheet in the work book. here ...

    marco 1 | Excel | Latest reply: vcoolio Apr 20, 2016
    5 replies
  • Funct for adding +1 to a cell if there's a value in other cells Closed

    Hope someone can help me with this, idk if it's possible in excel 2007. So basically I have a series of cells where 1 needs to be added depending ...

    helloitsme | Excel | Latest reply: helloitsme Apr 20, 2016
    0 replies
  • Conditional formatting, graded color scale Closed

    Hello, I use graded color scale from green to red to color cells based on value Example: Value (color) 1 (green) 10 (yellow) 20 (red) If m...

    Henrik | Excel | Latest reply: Computertech Apr 20, 2016
    1 reply
  • Barcode scan Closed

    Hello everyone, I would really appreciate if someone could help me out.. I'm a small reseller but now I have over 600 items. I use the same barc...

    JC | Excel | Latest reply: vcoolio Apr 20, 2016
    1 reply
  • 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 | Excel | Latest reply: vcoolio Apr 20, 2016
    6 replies
  • Formula for Fetch Data from another sheet Closed

    Hello, First I would like to asked that how could I insert a excel file or create a link, to understand my query. because the query that I want t...

    smuneeb | Excel | Latest reply: smuneeb Apr 19, 2016
    2 replies
  • Formula to copy data based on the text in the cell Closed

    Hello, I need to find out how to do this (and would be grateful if anyone could help me with this): I have a tab (1) in Excel with ten thousand...

    Aska | Excel | Latest reply: Mazzaropi Apr 19, 2016
    3 replies
  • Locking/unlocking a range of cell depending on other cell Closed

    Hi, I need some help - in cell A2 there can be entered a value from 1-48. If A2 is 1, then only cell B2 in column B should be unlocked (one cel...

    Sippenip | Excel | Latest reply: Sippenip Apr 19, 2016
    0 replies
  • MS Office Activation Key Closed

    Please I need an activation key for Micro Soft Office 2010 and 2013. Please help.

  • A macro to insert pictures into Powerpoint slide from Excel Closed

    Hi guys, I need your help with my problem. I have two files, one excel file that include a schedule for the whole year with 6 coloum (A Week, B ...

    rodi.ali1 | Excel | Latest reply: rodi.ali1 Apr 19, 2016
    0 replies
  • droplist of tab names Closed

    Hello, I have a dropdown list of all my tabnames in a workbook. I want to create formulas that will read the selection in the drop down list and ...

    ExcelMiner | Excel | Latest reply: ExcelMiner Apr 18, 2016
    0 replies
  • formula to check days of the month and display only weekdays Closed

    Hello, Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and...

    Middo | Excel | Latest reply: TrowaD Apr 18, 2016
    1 reply
  • Multiple sheet, find, copy specific cell and paste Closed

    Hello, i have a challenge for you. Im working on a doccument to pull information from a different sheet, that was imported from a web based huma...

    Jeremyknight85 | Excel | Latest reply: TrowaD Apr 18, 2016
    1 reply
  • 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 | Excel | Latest reply: whatsit Apr 18, 2016
    2 replies
  • Inserting image files from a directory specified by text string Closed

    G’day CCM forum Quick hypothetical; I have a list of image file names in a column on an excel spreadsheet and a cell at the top of the page contain...

    MattRNR | Excel | Latest reply: MattRNR Apr 18, 2016
    16 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 | Excel | Latest reply: vcoolio Apr 18, 2016
    3 replies
  • Update value from table1 to table2 Closed

    HI I have following two tables in excels. I want to copy values from table1 to 2nd one Criteria- we need to copy last five value. example shows in ...

    Jeet | Excel | Latest reply: Jeet Apr 18, 2016
    0 replies
  • F2+Enter key for Macro Closed

    Hi I would like to request for a Macro that which execute a F2 and Enter keys. Please don't make a selection for a cells. I have a sheet where ...

    smuneeb | Excel | Latest reply: smuneeb Apr 17, 2016
    2 replies
  • Microsoft Office Adding Publisher Closed

    I purchased the 365 days of Microsoft Office along with my new computer in December and it didn't include Publisher. How can I add that?

  • Help with simple 2 step macro? Closed

    Hello, I ask help to write a macro that 1. searches for 1 name "(Nghiem, Emily)" 2. and then types "X" in the next cell to the right. (What I tr...

    emilynghiem | Excel | Latest reply: ac3mark Apr 15, 2016
    1 reply
  • multiple IF to show different statuses Closed

    Hello, I am trying to have different status in my reports depending on the dates in different cells H START I ACTUAL START J DUE K DATE COMPLETED...

    annemarie ric | Excel | Latest reply: JasmineJasmineVV Apr 15, 2016
    1 reply
  • Copy Cells Relevant to Unquie Col Match and Save to Local Drive Closed

    Hello, I am new to VBA, and was going back and forth between the available codes trying to create VBA to execute the following, but was not able to...

    Shanl7 | Excel | Latest reply: Shanl7 Apr 15, 2016
    0 replies
  • Conditional Formatting based on Text in another Sheet Closed

    Hello! I'm currently using Google Sheets, but I believe the formatting is the same. I am working on two separate sheets, one "Cashflow" and one "In...

    katrich | Excel | Latest reply: katrich Apr 15, 2016
    0 replies
  • How to get a macro to work in all worksheets Closed

    I know I am missing something simple here. I made a macro to create a chart from a template based on two ranges in a worksheet (Brisbane April Sales ...

    Robbo | Excel | Latest reply: Robbo166 Apr 14, 2016
    3 replies
  • ibm lotus symphony Closed

    Sir, I tried severel times to download ibm lotus symphony but failed. please help. With regards Mantu

    mantu1 | Open Office | Latest reply: Ambucias Apr 14, 2016
    1 reply
  • double conditional formatting Closed

    Hello, I would like to ask for your help with some conditional formatting, can’t really get my head around it. What I have: 1. Two columns in C an...

    leep94 | Excel | Latest reply: leep94 Apr 14, 2016
    0 replies
  • Put in today's date if other cell has color. Closed

    Hi there everyone, I have a question about excel and I would love if someone could help me with it! I have an accountant sheet with invoices. When a...

    Anands | Excel | Latest reply: Anands Apr 14, 2016
    0 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 | Excel | Latest reply: BrianGreen Apr 13, 2016
    2 replies
  • Automatic Data Transfer Closed

    Hello, i am trying to extract data (certian colums )from one workbook to another workbook from a certian date, and everytime the orgininal workboo...

    shal | Excel | Latest reply: shal Apr 13, 2016
    0 replies
  • Call createJpg (reference sheet) Closed

    Hey I have a doubt on this code ... > With OutMail > .SentOnBehalfOfName = "***@***" > .Display > ....

    rodrigo723 | Excel | Latest reply: rodrigo723 Apr 13, 2016
    0 replies
  • 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: group123 Apr 12, 2016
    5 replies
  • Outlook 2010 configuration for mail.com Solved/Closed

    Hello, I am not able to configure outlook 2010 for mail.com. OS- window 7 64 bit Could you please provide me the server, port details.. Thank y...

    tanza2012 | Outlook | Latest reply: Rod B. Apr 12, 2016
    11 replies
  • How to extract&automate dailymaster excel sheet using macros/vba Closed

    Well, On daily basis I get master data sheet and create a excel reports manually, I can add columns and use formulas to get required result, you can s...

    bgn07 | Excel | Latest reply: bgn07 Apr 12, 2016
    0 replies
  • trying to get an if statement working Closed

    i am trying to make a formula that when these cells have text in them, a counter goes up. my code here =IF(ISTEXT(C3),1,"")+IF(ISTEXT(D3),1,"")+IF(...

    ayylamo | Excel | Latest reply: ayylamo Apr 12, 2016
    0 replies