Office Software Forum

Ask a question
Search
Close
Results 4601 - 4650 of about 16,700
  • 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: Anonymous User 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
  • VBA that Copies/Paste rows based on Amount Closed

    Hello, I have a spreadsheet that has our products. After the product is chosen then there are hundreds of options to choose from. I hav...

    Simpleminded... | Excel | Latest reply: SimplemindedDwight Apr 27, 2015
    0 replies
  • Can't open scanned document when broken up into 2 PDF's Solved/Closed

    When I scan a large color document on the color printer, the PDFs that are sent to me via Email can not be opened. The error message indicates it is n...

    shujaaishak | PDF | Latest reply: thierryhauet Apr 27, 2015
    1 reply
  • search functionality,copy and paste Closed

    Hello, I am new to VBA and looking for a search functionality macro.I am looking for three steps;- There are three sheets,in sheet one i just cre...

    pinki | Excel | Latest reply: pinkipanchal Apr 27, 2015
    2 replies
  • Push data to new table Closed

    Hello Everybody! I am trying to build a tool for our Company which helps plan future collection and eventually should turn into a Gantt. So... i...

    MaozH | Excel | Latest reply: MaozH Apr 27, 2015
    0 replies
  • repair outlook express dbx file Solved/Closed

    has a sent items.dbx file which is about 400 over MB.. when open it, there is only a few emails with the file size quite small. any recommended free s...

    altairbishara | Outlook | Latest reply: ruudromein Apr 26, 2015
    2 replies
  • All my office apps are not showing its icon. Closed

    Hello, I am using Office 2013. Now I can only see the windows generic icon instead of the Office icon. I am using the Professional Plus 2013 full ve...

  • if cell contains Closed

    Hello sir, Actually I wanted to know is there any formula if column contain description like - qty box size 1kg - ...

    NITIN | Excel | Latest reply: NITIN Apr 25, 2015
    0 replies
  • Exam Layout Closed

    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 start? I h...

    Dibble | Excel | Latest reply: Dibble Apr 24, 2015
    0 replies
  • How do I count the number of times a cell changes color Closed

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

    freygreer | Excel | Latest reply: freygreer Apr 24, 2015
    0 replies