Office Software Forum

Ask a question
Search
Close
Results 4551 - 4600 of about 16,600
  • Master Sheet and Subsets Closed

    Hello, I use Excel for keeping track of flights in a flight simulator. At the moment I have everything on a master sheet. There are 20 columns and ...

    JoHubb | Excel | Latest reply: JoHubb May 10, 2015
    0 replies
  • Reformatting a Date in Excel Solved/Closed

    Hello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...

    Bert | Excel | Latest reply: Bert May 8, 2015
    4 replies
  • Struggling with dependent text or list display in cell Closed

    Hi - thanks for reading I'm not sure if this is possible but I'd like to get the following to work: - Cell A1 contains a small pick from list -...

    leecey1 | Excel | Latest reply: MaxStart May 8, 2015
    1 reply
  • Expiration Date Search, Copy to Sheet2 Closed

    Hi! I have a spreadsheet with dates in column C starting at C7, and other info to do with the dates in columns A through L Im wanting to have a c...

    AJohn403 | Excel | Latest reply: vcoolio May 8, 2015
    1 reply
  • Copy Data from One sheet in a workbook to another Sheet Closed

    Hi, I'm trying to copy one sheet automatically in one workbook to multiple workbooks. For example the workbook is May 2015 Sales Numbers and the S...

    Loren@Tsep | Excel | Latest reply: MaxStart May 7, 2015
    1 reply
  • get a percentage in microsoft excel Solved/Closed

    Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...

    theocupent | Excel | Latest reply: kb May 7, 2015
    3 replies
  • How to use name range..Please help to solve this issue.. Solved/Closed

    Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...

    mathewmunna | Excel | Latest reply: Mathewmunna May 7, 2015
    4 replies
  • Automatically Syncing Data from my master sheet to Individual Sh Closed

    Hi, What would be the procedure for automatically Syncing Data from my master sheet to Individual Artist sheet. I basically would be enteri...

    saral.saraf | Excel | Latest reply: vcoolio May 6, 2015
    1 reply
  • Excel Partial Cell Match Closed

    Hello, I am doing a report of online tracking with automatic data generator raw data output format tracking ID / Views ...

    Eric | Excel | Latest reply: Eric May 6, 2015
    0 replies
  • comparison Closed

    Hello, I have two spreadsheets with different quarters of the year however, the names changes because some are in the first quarter and not in the s...

    jg | Excel | Latest reply: jg May 5, 2015
    0 replies
  • Transpose every 4 rows Closed

    Hello, I have a problem. How can I transpose this: 1 2 3 4 5 6 7 8 to this: 1 5 2 6 3 7 4 8 Help much appreciated!

    Justyn | Excel | Latest reply: Justyn May 5, 2015
    0 replies
  • Need macro to copy paste from Sheet1 to Sheet2 with condition Closed

    Hi Everyone, Please help to simplify below macro code. Sub Macro2() Sheets("Sheet1").Range("A2").Copy Sheets("Sheet2").Range("A2:A21") Sheet...

    zushi | Excel | Latest reply: zushi May 5, 2015
    0 replies
  • Macro:Combining related rows into one, but keeping some fields Closed

    Hello, I am referring to this resolution: https://ccm.net/faq/20104-excel-a-macro-to-combine-selected-rows What I need is is say each row of col...

    KSWI | Excel | Latest reply: KSWI May 4, 2015
    0 replies
  • How to change date in order of dd/mm/yy in excel 10 Closed

    Hello, I want a solution for this!?! pls Configuration: iPhone / Safari 4.0

    Prabhu | Excel | Latest reply: MaxStart May 4, 2015
    1 reply
  • Please help! Excel Auto-Move Row to New Sheet Closed

    Hello! I am stuck and could use some help please. I'm trying to make a dynamic spreadsheet workbook that has sheets based on project with a roll-u...

    jtalbot13 | Excel | Latest reply: jtalbot13 May 4, 2015
    0 replies
  • Help in Excel ignore blanks Closed

    I wish to list out certain data from a source file. While listing in the new file, it should ignore blanks. How do I do it, please? Source File ...

    jsridhar | Excel | Latest reply: jsexcel May 4, 2015
    0 replies
  • what it mean RS = 7: Sheets(F1).Select Closed

    Hello, im stater excel vba i see this code and im not clear what it mean please any one explain me.

    niroth | Excel | Latest reply: MaxStart May 3, 2015
    1 reply
  • POP3 and SMTP for Yahoo.ca Closed

    Hello, What is Yahoo.ca not Yahoo.com mail's incoming mail server (POP3 or IMAP)? And what is the Outgoing email server's (SMTP)name?

  • Selecting Currency type Closed

    while converting a numeric value to the words I wish to choose currency type like Dollar, AED etc. while using following article https://support.mic...

    mnavids | Excel | Latest reply: mnavids May 2, 2015
    0 replies
  • I have a excel sheet and i want same data to be copied in other Closed

    Hello, I have a excel sheet and i want same data to be copied in other folder. Other folder is my google drive so as i do the work i have a backup...

    srigopal | Excel | Latest reply: srigopal May 1, 2015
    0 replies
  • Filtering data from another worksheet cell value Closed

    Hi I have a graph where I'm displaying some points from a worksheet, in this worksheet I have a simple autofilter filter criteria (Display = Yes or N...

    OctavioHe | Excel | Latest reply: OctavioHe May 1, 2015
    0 replies
  • Excel master list Closed

    Hello, I will be creating a spreadsheet with lots of text data, addresses, phone numbers, names, ect. I have all the data set up in rows so I will j...

    Jason | Excel | Latest reply: MaxStart May 1, 2015
    1 reply
  • Excel VBA input data to next empty Range Closed

    HI everyone, I am excel vba stater I have crazy problem to solve. I want to input data into range j6 by use inputbox and if j6 had value next input wi...

    Niroth | Excel | Latest reply: MaxStart May 1, 2015
    1 reply
  • Exam layout help Solved/Closed

    Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...

    Dibble | Excel | Latest reply: addseo1115 May 1, 2015
    8 replies
  • Conditional formatting cell if every cell contains "YES" Solved/Closed

    Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...

    LizzyDashwood | Excel | Latest reply: LizzyDashwood May 1, 2015
    2 replies
  • i need my reset password Closed

    Hello, i dont no my gmail password plz help me Configuration: iPhone / Chrome 30.0.0.0

    bhuvee | Word | Latest reply: mharon May 1, 2015
    1 reply
  • VBA/Macro - copying rows onto new excel Closed

    HI I have Excel 2013. I have a file that I need to copy the rows onto a new excel workbook if it meet two criteria using VBA/Macro. For example,...

    B | Excel | Latest reply: B Apr 30, 2015
    0 replies
  • replacing any alphabet with C, and number with 0 in an alphanume Closed

    Hello, I have huge list of alphanumeric string in each row. And I want to replace any alphabet with C, and number with 0 in an alphanumeric. e.g I...

    Raj | Excel | Latest reply: TrowaD Apr 30, 2015
    1 reply
  • Excel help Closed

    I think I need to use multiple formula to find this. I think an If function is used for sure. I need to find a formula that gives me the difference be...

    nele8118 | Excel | Latest reply: TrowaD Apr 30, 2015
    1 reply
  • Compare 2 Sheets -> Summary differences Solved/Closed

    For an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...

    SidK | Excel | Latest reply: SidK Apr 30, 2015
    4 replies
  • Coding Closed

    Hello, i want coding for excel to create multiple sheets for different row data in other sheet. Basically i have one input sheet, in which i enter...

    Swaksha | Excel | Latest reply: Swaksha Apr 30, 2015
    0 replies
  • Conditional Formatting for a particular column Solved/Closed

    Hello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...

    Harish | Excel | Latest reply: Harish51290 Apr 30, 2015
    11 replies
  • copy & Paste based on specific condition Solved/Closed

    Please provide me the macro coding for the below scenario. I have four columns in my sheet 1 say Date,Name,Reference and Rate. When I am entering the...

  • How to search for a value in a range if found run a procedure. Solved/Closed

    Hello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...

    Tiny | Excel | Latest reply: Tiny Apr 29, 2015
    4 replies
  • Find Closes Data Match Closed

    Hello, I am hoping that someone could give me some support, and any efforts would be greatly appreciated. I am looking for the some help doing...

    nsettlemire | Excel | Latest reply: nsettlemire Apr 29, 2015
    0 replies
  • change the date format in excel 2007 worksheet Closed

    Hello, i want to know that howcan i change the date format in excel 2007 worksheet if i want it like :- yyyy/mm/dd regards, Amol. ...

    amol | Excel | Latest reply: MaxStart Apr 29, 2015
    1 reply
  • finding a date (N30) in a date range B5:B30 and returning A3text Solved/Closed

    Hello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...

    Kelley | Excel | Latest reply: MaxStart Apr 29, 2015
    3 replies
  • Removing False Word in Excel Closed

    Hello! How to remove the false word in this formula and retain only the amount instead? =IF(O50,VALUE(M5)) Thanks!

    baren91 | Excel | Latest reply: baren91 Apr 29, 2015
    2 replies
  • Finding Closest Data Match Closed

    I am looking for the some help doing the following. Assume each cell in Column B is the target cell, and the data in Column A is to be interigated...

    nsettlemire | Excel | Latest reply: nsettlemire Apr 28, 2015
    0 replies
  • After Pushing Command Button on Sheet1, Sheet 2 Auto. opens up. Closed

    Hello, I have created a workbook with several pages of Information. One of the pages sheet2 ("Order Form") will figure information. There is a ...

    Simpleminded... | Excel | Latest reply: MaxStart Apr 28, 2015
    1 reply
  • Counting the number of Times a Cell changes colors and Archive Closed

    Hello, Hello, I would like to count the number of times a cell goes green and archive it. How can I do this? Thank you for any help you can give. ...

    freygreer | Excel | Latest reply: MaxStart Apr 28, 2015
    1 reply
  • Auto. copy a row of data onto another sheet using conditions Solved/Closed

    Hello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...

    DON'T KNOW | Excel | Latest reply: Don't Know Apr 28, 2015
    8 replies
  • Auto populating multiple sheets Closed

    Hello, I have read some of the Qs and As and they are scary if you don;t know Excel. ! Is there not a simple formula for entering data into a sp...

    DumbUser | Excel | Latest reply: MaxStart Apr 28, 2015
    1 reply
  • macros to copy conditional data Closed

    Hello, I am beginner in macros and am trying a macro code which does the following. I have 2 sheets by name sheet1 and sheet2, sheet1 consists of...

    solo | Excel | Latest reply: TrowaD Apr 28, 2015
    1 reply
  • Amexxx1 Closed

    Hello, I don't seem to be able to run this simple code; I copy and paste but when trying to run in my General tab by pressing alt+F8, no macro is ...

    Amexxx1 | Excel | Latest reply: TrowaD Apr 28, 2015
    3 replies
  • Macro to Search for a word and put a code on the cell next to it Solved/Closed

    Hello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...

    A.E | Excel | Latest reply: A.E Apr 28, 2015
    2 replies
  • Archived Mails issue Closed

    Hello, If the archived file is over written and the data is lost then is there any way to recover my old mails? Please suggest as one my approx...

    Sumeet | Outlook | Latest reply: Sumeet Apr 28, 2015
    0 replies
  • Count if Based on Cell Color & Date Range in a Column Closed

    Hello, Any help on this would be greatly appreciated. I am trying to build a macro. That would look at a start date and end date manually entered...

    vj | Excel | Latest reply: vj Apr 28, 2015
    0 replies
  • Automated Data Insertion Closed

    Hello, I'm glad I have found this forum. On generic spreadsheets I can maneuver fairly well, but I believe I have stepped off a steep ledge here....

    j518 | Excel | Latest reply: j518 Apr 27, 2015
    0 replies
  • Macro which can be calculated every month Rent Closed

    I have 400+ agreements and the agreements start date and end dates are different. Also the rent incremental days and incremental percentage are differ...

    VKumar2210 | Excel | Latest reply: xpcman Apr 27, 2015
    1 reply